How to Compare Two Excel Spreadsheets Online (Formulas, Values, and Formatting)

Someone sends you “the updated spreadsheet.” You need to know exactly what changed before you trust it — did they fix the one cell you asked about, or did a formula shift and silently recalculate half the sheet?

Excel doesn’t have a built-in diff view. Opening two workbooks side by side and eyeballing them works for ten rows; it falls apart at ten thousand.

Why spreadsheet diffing is harder than text diffing

A spreadsheet isn’t really a grid of text — it’s a grid of cells, and a cell can differ in three independent ways:

The displayed value — what you see: 142.50.
The underlying formula — =SUM(B2:B14) vs a hardcoded 142.50 that looks identical but will never update again.
The formatting — currency vs plain number, a fill color flagging a manual override.

A tool that only compares the rendered text (or a screenshot) will call two sheets identical when one has live formulas and the other has stale pasted values — which is exactly the bug that causes “but the report said something different last week.”

The fastest reliable method: export to CSV, then diff the text

If you only care about values (not formulas or formatting), export both versions to CSV and run a plain text comparison:

In Excel or Google Sheets: File → Save As / Download → CSV.
Open DiffALL’s text comparison tool and paste or upload both CSVs.
Read the line-by-line diff — each row is a line, so an added row, a deleted row, or a changed cell all show up as a highlighted line.

This catches the case people actually ask about most often: “did row 47 change?” It won’t tell you whether a change came from a formula recalculating or someone typing over a cell — for that, you need to look at the formula view.

Comparing formulas, not just values

Excel has a hidden switch that shows formulas instead of results:

Windows/Mac: Ctrl + ~ (backtick) toggles formula view.
Take a screenshot or export in this mode for both files, then diff the formula text the same way — line by line.

A common real-world case: a shared budget template where one branch has =B2*1.08 (with tax) and another has =B2 (without). The values might coincidentally match this month and diverge next month — comparing formulas catches the landmine before it goes off.

What to check row by row

Change type	How it shows up	Why it matters
Value changed	Same row, different number/text	The most common — did the number actually change
Formula replaced with hardcoded value	Formula bar shows a literal instead of `=`	Report will never update again
Row inserted/deleted	All subsequent row numbers shift	Naive cell-by-cell (A1 vs A1) comparison misreads every row after the insertion
Column reordered	Same data, different column position	Looks like every cell changed if compared positionally
Number formatting only	`1200` vs `$1,200.00`	Same value, cosmetic difference — usually safe to ignore

The row-insertion case is the one that breaks naive diffing tools the hardest: if row 5 is deleted, every row from 6 onward now sits one position earlier, and a position-based comparison flags the entire rest of the sheet as “changed” even though nothing but row 5 actually moved. Line-based text diffing (comparing content, not position) handles this correctly — it matches unchanged rows wherever they land.

When you need more than a CSV export

For spreadsheets where formatting is the point — a styled invoice template, a color-coded status report — a visual comparison catches what a text export throws away. Export both versions as PDF or take full-page screenshots, then run them through DiffALL’s image comparison to get a heatmap of exactly which cells changed visually, including fill color and borders.

Quick checklist before you trust “the updated spreadsheet”

[ ] Export both versions to CSV and diff the text for value-level changes.
[ ] Toggle formula view (Ctrl + ~) and check whether any formulas were replaced with static values.
[ ] Confirm row counts match, or account for legitimate insertions/deletions.
[ ] If formatting matters (invoices, dashboards), compare rendered screenshots, not just raw values.
[ ] Re-check any cell that feeds a downstream formula — a small upstream change can cascade.

The spreadsheet itself won’t tell you what changed. A CSV export plus a text diff gets you there in under a minute, and a screenshot comparison covers the cases where the numbers are right but the formatting silently isn’t.