How to compare two Excel workbooks
To compare two Excel workbooks, open both, then use the Inquire tab and choose Compare Files. Spreadsheet Compare shows the differences cell by cell, colour-coded by kind, and can export the result. Microsoft documents it for Excel for Windows in Microsoft 365 Apps for enterprise plans.
The native Excel method
- Open both versions of the workbook in Excel for Windows.
- Select the Inquire tab on the Ribbon and choose Compare Files.
- In the Compare Files dialog, choose the earlier file as the Compare side and the later one as the To side.
- Choose OK to run the comparison and read the side-by-side grid of differences.
- Export the results with Home, then Export Results, if the differences need to be attached to a review note.
What the native comparison gives you
Microsoft describes Spreadsheet Compare as the engine behind Compare Files, showing differences cell by cell and colour-coding them by the kind of content — entered values, formulas, named ranges and formats — with a window that can show VBA changes line by line (Microsoft Support).
Two details from the documentation matter in practice. Hidden worksheets are still compared, so a hidden sheet cannot hide a change. And results can be exported to an Excel file with Home, then Export Results (Microsoft Support).
The licence catch
Spreadsheet Compare is not in every edition. Microsoft’s page states that it is available only in Excel for Windows in Microsoft 365 Apps for enterprise plans and equivalent editions (Microsoft Support). If the Inquire tab is missing, the add-in may need turning on first.
Structural changes are still hard
An inserted row shifts everything below it. The comparison will report the shift, but reading which changes are real and which are noise is still manual work — that is the part a reviewer spends time on.
The CalcoraSuite way (planned)
The planned compare view aligns the two versions before it looks for differences, so an inserted row is reported once rather than as a few hundred changed cells. See the compare workbooks page for its status.
The CalcoraSuite way
Planned, not released. The compare workbooks page carries the current status of each step (planned).
- Pick the earlier workbook as the base and the later one to compare against.
- Read the differences grouped by sheet, filtered to formulas when the question is about logic.
- Export the list as it stands, then re-run after fixes.
Sources
Every native step above was checked against these Microsoft pages on 16 November 2026.
Get the add-in before release
Early access testers get each add-in first, with a short list of what to try.