How to Compare Two Excel Files (and Find the Changes That Matter)

Updated October 12, 2026

When a workbook comes back as v7_final_FINAL.xlsx, the question is never “what is different?” — it is “what changed that I need to care about?” A typical budget round touches hundreds of cells. Only a handful of those changes alter the logic of the file.

This guide covers four ways to compare two Excel files, what each one is good at, and a simple process for reviewing the result.

1. A difference formula (fast, fragile)

Copy both versions into one workbook as sheets Old and New, add a third sheet and enter:

=IF(Old!A1<>New!A1, "Old: "&Old!A1&" → New: "&New!A1, "")

Fill it across the used range. Every non-blank cell is a difference.

Good for: small, fixed-layout sheets. Breaks when: a row or column is inserted — every cell below it shows as changed. It also compares results, so a formula overwritten with the same number looks identical.

2. Conditional formatting

Select the range on New, add a rule with the formula =A1<>Old!A1 and a fill colour. You get a visual map of changes, with the same row-insertion problem as the formula approach.

3. Microsoft Spreadsheet Compare (Windows only)

If you have Office Professional Plus or Microsoft 365 Apps for enterprise on Windows, search the Start menu for Spreadsheet Compare. It lists entered values, formulas, names and formatting separately and exports the result to Excel.

It is not available on Mac or in the standard Microsoft 365 Business plans — see Spreadsheet Compare for Mac for alternatives.

4. A comparison tool that ranks risk

The DraftReview compare tool runs in your browser and does three things the manual methods cannot:

• Aligns rows by their labels. An inserted “Other income” row shows up as one added row, not as 40 changed cells.
• Compares formulas by logic. A formula that moved down one row because of an insert is not reported as changed.
• Ranks changes by risk. Formulas overwritten with typed numbers come first, then changed formulas, then value edits. Formatting is ignored unless you ask for it.

Because it runs locally, the files are never uploaded.

A review process that scales

1. Start with structure. Were sheets added, removed or hidden? Were rows inserted in the middle of a range that a total depends on?
2. Then logic. Look at every formula that changed or became a constant. These are the changes that silently alter future results.
3. Then inputs. Value changes in input cells are expected in most rounds — check the large ones against the change log or email trail.
4. Ignore noise deliberately. Set a rounding tolerance and leave formatting out unless presentation is what you are reviewing.
5. Keep evidence. Export the list of changes with the version names and date so the next reviewer does not start from scratch.

Common pitfalls

• Comparing values only. A formula replaced by the same value it produced looks unchanged today and breaks next month.
• Sorting one version. Sorting changes every row position; compare by labels, not positions.
• Comparing exports. CSV exports lose formulas, so you cannot see logic changes at all.