Home›Tools›Compare Excel Files
🔒 No uploadOld → new valuesColour-coded report

Compare Two Excel Files and Find the Differences by AIMerger

See exactly what changed between two versions of a spreadsheet: rows added, rows removed, and every changed cell with its old and new value. Rows are matched by an ID or key column, so sorting or inserting rows doesn’t create false differences.

🔒 Processed locally in your browser — your files never leave your device
1

Add the old and the new file

Excel or CSV — pick the sheet and the header row for each.

Old file (before)

📊 Drop the old file or tap to choose

Excel .xlsx/.xls, .ods or CSV

New file (after)

📊 Drop the new file or tap to choose

Excel .xlsx/.xls, .ods or CSV

2

Choose how to compare

Pick a key column so moved or re-sorted rows still match.

How to line rows up
Columns to compare
What counts as a difference
3

See the differences & export

Every change is labelled in words, not only colours.

🔒 Both files are compared on your device. Nothing is uploaded.

Limits on this device

Up to about 80 MB per file and a few million cells on a computer (less on phones). Formulas are compared by their last calculated values. Rows whose key appears more than once are listed but not compared, so they are never matched to the wrong row.

Compare Excel Files — a real example made with this tool from sample files

An old and a new price list → every added, removed and changed cell.

How to use the Excel comparison tool — 4 steps

  1. 1

    Add the old file and the new file (Excel or CSV) and pick the sheet and header row for each.

  2. 2

    Choose a key column that identifies each row — an ID, SKU, email or invoice number. Add a second key column if needed, or compare by row position if the files have no ID.

  3. 3

    Tick the columns to compare and set the options: ignore spaces or case, how to treat blanks, and a numeric tolerance for prices or measurements.

  4. 4

    Press Compare files. Filter the results (added, removed, changed…) and download a colour-coded Excel report or CSV lists.

💡 Tip: Comparing price lists or stock reports? Set a numeric tolerance (for example 0.01) so rounding differences don’t show up as changes, and keep “Compare numbers by value” on so 1.50 and 1.5 count as equal.

Matched by key, not by position

Simple “compare” tools line rows up by position, so a single inserted row makes every row below it look different. When you choose a key column, each row in the new file is matched to the row with the same key in the old file, wherever it is. Rows whose key appears more than once are listed separately and not compared, so they can never be matched to the wrong row. Comparing by position is still available — and clearly labelled — for files without an ID.

What the report contains

  • Summary — counts of added, removed, changed and unchanged rows, and the options used.
  • Differences — one row per added, removed or changed record, with a Status column in words (not only colour) and a “What changed” column such as Price: “12.50” → “13.00”. Changed cells are highlighted.
  • Changed cells — a long list (key, column, old value, new value) that is easy to filter or paste elsewhere.
  • Added rows and Removed rows — the full rows, ready to copy.

Good to know

Values are compared as you see them; formulas are compared by their last calculated values. IDs keep their leading zeros, and long numbers are never rounded. Columns with different names in the two files can be paired by hand. Cell colours and formatting are not compared. Very large workbooks are limited by your device’s memory — a computer handles a few million cells.

Frequently asked questions

How do I compare two Excel files for differences?

Add the old and new files above, choose the ID column that identifies each row, and press Compare files. You’ll see added, removed and changed rows, with old and new values for every changed cell, and can download a colour-coded report.

Can I compare two sheets in the same workbook?

Yes. Add the same file twice and pick a different sheet for the old and the new side.

Does sorting the rows differently cause false differences?

Not when you compare by a key column — rows are matched by their ID, wherever they are. Comparing by row position is an option for files without an ID.

What if an ID appears more than once?

Those rows are flagged as “duplicate key” and listed, but not compared, so nothing is matched to the wrong row. Fix the duplicates or add a second key column.

Can it ignore small number differences?

Yes. Set a numeric tolerance — for example 0.01 — and differences within it are treated as equal. You can also ignore spaces and upper/lower case.

Are my files uploaded?

No. Both files are compared in your browser on your device.

Related tools

Free tools that pair well with this one.

🧰 Browse all 88 AIMerger tools →