Version History Issues

Compare Excel Workbooks for Added, Deleted, and Changed Data

Anum MushtaqAnum Mushtaq Nov 18, 2026 870 views

Question details

The user wants to compare two Excel workbook versions and identify added, deleted, and changed data.

Compare Excel Workbooks for 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.
Before you start

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.

Solution 1Recommended

Compare workbook versions with Spreadsheet Compare

Use Microsoft's standalone comparison tool to review differences in values, formulas, and workbook structure.

1
Open Spreadsheet Compare

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.

2
Select the workbooks

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.

3
Review the differences

Inspect the color-coded results and the differences list to find changed, added, or deleted values, as well as formula and structural changes.

Compare workbook versions with Spreadsheet Compare
Availability varies: Spreadsheet Compare is included with some Microsoft Office editions and installations. If it is not installed, check your Office edition or ask your administrator whether it is available.
Free Microsoft Office alternative

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.

Open and review workbook versions in WPS SpreadsheetCompatible with Microsoft Excel XLS and XLSX formatsFamiliar spreadsheet interface for an easier transition from OfficeFree and lightweight office suite
microsoft office alternative - wps office

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.