Compare Excel Workbooks for Added, Deleted, and Changed Data
Question details
The user wants to compare two Excel workbook versions and identify added, deleted, and changed data.

- Product
- Microsoft Excel and Spreadsheet Compare
- Device & OS
- not provided
- Scenario
- The user has revised spreadsheets to compare, but the Review tab does not include the Changes feature.
- Observed behavior
- The Review tab does not show the Changes feature needed for the user's intended comparison.
Locate the older and newer workbook files so you can select both in the comparison tool. Spreadsheet Compare is available with some Microsoft Office installations; check whether it is installed before starting.
Compare workbook versions with Spreadsheet Compare
Use Microsoft's standalone comparison tool to review differences in values, formulas, and workbook structure.
On Windows, open Start and search for Spreadsheet Compare. You can also look under Start > All Apps > Microsoft Office Tools if that folder is available.
In Spreadsheet Compare, select Home > Compare Files. Browse to the older workbook in the Compare field and the newer workbook in the To field, then select OK.
Inspect the color-coded results and the differences list to find changed, added, or deleted values, as well as formula and structural changes.

Review Excel Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and reviewing Excel workbooks. Its Excel format compatibility makes it easier to move existing files to WPS, although it does not replace Microsoft's Spreadsheet Compare tool.

Frequently Asked Questions
Where can I find Spreadsheet Compare?
On Windows, search for Spreadsheet Compare from Start, or look under Start > All Apps > Microsoft Office Tools. It is included with some Office installations, so it may not appear on every computer.
Which workbook should I select first?
In Home > Compare Files, select the older workbook in the Compare field and the newer workbook in the To field. This makes the direction of the changes easier to interpret.
Can Spreadsheet Compare find formula changes?
Yes. After selecting both files in Home > Compare Files, review the results for differences in formulas, values, and workbook structure.
Can I compare workbooks if the Changes feature is missing from Excel?
Yes, if Spreadsheet Compare is installed. Open the standalone tool from Start, then use Home > Compare Files to select the two workbook versions.




