Step-by-step guide
How to compare two Excel sheets
There are six common ways, and the right one depends on your data. Here’s each method with an honest “good for / breaks when”, plus the one-drag shortcut if you just want the answer now.
The fast path: drop two sheets here
No formulas and no add-ins. SheetDelta aligns the sheets and color-codes every change in your browser — nothing is uploaded. Or read on for every in-Excel method.
Old / Base file
.xlsx .xlsm .xls .xlsb
or click to browse
New / Modified file
.xlsx .xlsm .xls .xlsb
or click to browse
Six ways to compare two sheets
Before you pick one, know what you’re really asking. “Compare two sheets” usually means one of two jobs: version comparison (the same sheet over time — what changed since last week?) or reconciliation (two lists keyed by ID — which rows are missing or disagree?). Some methods below only do one well. Each card says which.
Method 1
View Side by Side (eyeball it)
Open both workbooks (or two windows of the same one via View → New Window), then View → View Side by Side. Turn on Synchronous Scrolling so both panes move together, and scan for differences by eye.
Good for
A quick look at small, similarly laid-out sheets, or sanity-checking a region you already suspect changed.
Breaks when
There’s real data. Nothing is highlighted, so a one-digit change hides easily, and a single inserted row throws both panes out of alignment.
Method 2
A comparison formula + conditional formatting
The classic in-Excel approach. On a third sheet, write a formula that compares the two cells, then fill it across the whole used range:
Side-by-side cell check, copied across the whole used range:
=Sheet1!A1=Sheet2!A1 → TRUE where equal, FALSE where different
=Sheet1!A1<>Sheet2!A1 → TRUE where different (often easier to scan)
=IF(Sheet1!A1<>Sheet2!A1,"changed","") → label only the changed cells =Sheet1!A1=Sheet2!A1 returns
TRUE where the cells match;
=Sheet1!A1<>Sheet2!A1 flips it so the differences read as
TRUE, which is usually easier to scan. To label
them instead, use =IF(Sheet1!A1<>Sheet2!A1, "changed", "").
To highlight differences in place rather than on a third sheet, select the range on
Sheet1, add a conditional-formatting rule → Use a formula, and enter
=A1<>Sheet2!A1 with a fill color. Every cell that
differs from the matching cell on Sheet2 gets shaded.
Good for
Two sheets with the same shape and row order, when you want a result that lives in the workbook and updates as the data changes.
Breaks when
Rows are inserted, deleted, or sorted differently — every row below the change reads as different. It also compares position, not records, and ignores added or removed sheets entirely.
Method 3
Power Query merge / anti-join
When the two sheets are lists keyed by an ID — customer number, SKU, account — and the rows may be in any order, this is the right tool. Load each sheet as a query (Data → From Table/Range), then Merge Queries on the key column. A normal merge lets you compare the matched columns; a left/right anti-join returns only the rows that exist on one side and not the other.
Good for
Reconciling two keyed lists — finding missing rows and mismatched values regardless of row order. Repeatable: refresh the query when the data updates.
Breaks when
There’s no clean key, or you care about formulas and structure rather than rows of data. Setup takes a few steps, and it won’t tell you a formula changed behind an unchanged value.
Method 4
COUNTIF, XMATCH, and XLOOKUP tricks
For “which values on this sheet are missing from that one”, a lookup is quicker than a full
merge. =COUNTIF(Sheet2!$A:$A, A2) returns
0 for any value in column A that doesn’t appear on
Sheet2. =XMATCH(A2, Sheet2!$A:$A) gives
#N/A for unmatched keys, and
=XLOOKUP(A2, Sheet2!$A:$A, Sheet2!$B:$B, "missing") pulls the matching value across so
you can compare it, returning "missing" when there
is no match.
Good for
A fast, ad-hoc check for presence or a single mismatched column, without setting up a query. Familiar functions most people already know.
Breaks when
Keys aren’t unique, or you need a full row-by-row reconciliation. You end up wiring several columns of helper formulas, and it still won’t see formula or structural changes.
Method 5
Microsoft Spreadsheet Compare
Microsoft ships a dedicated tool, Spreadsheet Compare, that shows cell and formula differences side by side and even flags VBA changes. It’s genuinely useful — when you can run it.
The catch is availability. It only comes with specific editions — Office Professional Plus and some Microsoft 365 enterprise/apps-for-enterprise plans — and only on Windows. If you’re on a Mac, on Home or Business editions, or on the web, it simply isn’t there, which is the wall most people hit.
Good for
A thorough side-by-side cell/formula comparison if you’re on Windows with a qualifying Office edition already installed.
Breaks when
You’re on a Mac, the web, or an edition that doesn’t include it. No install option fixes that. See the alternative.
Method 6
SheetDelta — one drag, no formulas
Drop two sheets (or two files) into the tool above. SheetDelta pairs the sheets, aligns the rows the way you would by eye, reads formulas as logic, and filters the cosmetic churn Excel writes on every save. What’s left is color-coded: green for added, red for removed, amber for changed. No third sheet of helper formulas, no add-in, and nothing leaves your browser.
Good for
Version comparison without setup, on any OS, including inserted rows and renamed tabs. Free, no account, nothing uploaded.
Worth knowing
The free web tool does cell and basic formula comparison; for logic-level (AST) formula diff, VBA, and .xlsb/.xls, use the desktop app. It doesn’t merge workbooks — it makes changes reviewable.
So which one should you use?
Short version: if you’re reconciling two keyed lists, reach for Power Query or a lookup. If you’re asking “what changed in this model since last week?”, a positional formula compare falls apart on the first inserted row, so use the tool — it aligns first. And if this is a question you ask every week on the same workbook, stop doing it by hand: the hosted platform watches the file and keeps the history for you.
Frequently asked questions
What’s the easiest way to compare two Excel sheets?
How do I compare two sheets without writing formulas?
How do I highlight the differences between two sheets?
=A1<>Sheet2!A1 to shade cells that differ from the other sheet — the steps are in the formula section. For a color-coded view without touching the workbook, see highlight differences. Is comparing two separate files different from comparing two sheets?
[Budget.xlsx]Sheet1, and both files need to be open for live references. The tools sidestep that entirely — see compare two Excel files. Which method handles inserted or deleted rows?
Keep reading
Drop two workbooks and see every changed cell, formula, and sheet — free, in your browser.
Match sheets and rows even after they move, so inserts don’t drown the real changes.
A modern, cross-platform alternative to Microsoft Spreadsheet Compare.
Color-coded added, removed, and changed cells at a glance.
The cross-platform option when the built-in tool isn’t available to you.
Comparing the same two sheets every week?
Let SheetDelta watch your SharePoint or OneDrive files, keep the version history, and route each change for review — so you stop rebuilding the comparison by hand.