How to Compare Two Workbook Versions Like Word’s Compare Feature

If you have two saved Excel workbook versions and want to see what changed, start by choosing the kind of difference you need. A report of changed customer amounts is a different job from finding edited formulas, changed formatting, or the person who edited a cell. For exported tables, match the same record in both versions before comparing its values.

What Word’s Compare feature does—and what to ask for in Excel

Microsoft documents Word’s comparison of an original and revised document with the result shown in a new document by default. That is a useful starting idea for spreadsheets too: keep two source versions and review a separate result.

The result need not look like Word’s insertion and deletion marks. A spreadsheet row can move while its record stays unchanged. For lists of customers, invoices or products, a report grouped by record ID often answers the practical question more directly than a comparison of cell positions.

Choose between record differences, workbook details and edit history

Microsoft’s Spreadsheet Compare guide covers eligible Windows editions and workbook-level differences, including formulas and formatting. If the command is missing, use the availability guide; if it is disabled, use the greyed-out command checklist.

Compare two saved exports and keep the originals

TidyCell Compare Files compares selected XLSX or CSV tables by a single or composite record key. Its output is a separate Excel report, not a workbook with Word-style revision marks or accept/reject controls.

1. Choose the earlier export as First file and the revised export as Second file. If the workbooks contain multiple worksheets, select the table in each that you actually want compared.
2. Check the suggested record ID. Customer ID or Invoice ID can work when unique; several columns together may be needed for invoice lines or stock by warehouse.
3. Choose the fields you want checked. An amount, status or address can change while the ID stays the same.
4. Inspect Added, Removed, Changed, Unchanged and Needs review. Confirm the source-row reconciliation totals on both sides.
5. Download the XLSX report, containing Summary, Records, Cell changes and Needs review worksheets. Use source coordinates and stored values to inspect a difference against the original files.

The comparison itself runs in your browser and leaves the originals untouched. It compares stored typed values, including saved formula results. It does not recalculate formulas, compare their text, audit formatting or macros, identify editors, or merge a revised value back into either original.

Example: both versions have four rows, but the records differ

The earlier export contains C001, C002, C003 and C004. The revised file lists C003, C001, C005 and C002. C001’s amount changed from 100 to 125; the other shared customers kept their amounts.

Expect one added, one removed, one changed and two unchanged records, with five record groups across the pair. Each source reconciles to four rows. Equal row counts did not mean the two versions contained the same records. For unequal totals, see the different-row-count walkthrough.

When Show Changes is the better answer

If your real question is who changed a cell and when, Microsoft’s Show Changes workflow displays recorded edits in a changes pane. It serves a different purpose from comparing two independently saved exports.

Microsoft also documents Show Changes limitations, including unsupported edit types, gaps and actions that can clear the pane. Do not assume a blank pane proves that a workbook never changed. The same help page explains using available version history to inspect older versions. A two-file record report cannot recreate missing history or establish an editor’s identity.

Review the comparison before sharing it

Check one known changed record and one moved-but-unchanged record. Resolve missing or duplicate IDs rather than forcing a match. A removed record means absent from the revised export, which could reflect filters or dates rather than deletion from the source system. Unavailable saved formula results and spreadsheet errors need review rather than being treated as blank values.

If the revised export also renamed or added columns, use the different-columns and headers guide to map equivalent fields before interpreting the result. State which fields you compared when you share the report.