How to Compare Two Excel Files and See Every Difference

If you searched "how to compare two Excel files," you probably have two versions of the same spreadsheet and need to find out what changed. Maybe someone updated prices and you need to know which ones. Maybe rows were added or deleted and you need to catch every edit before signing off. Maybe you just received an updated export and want to see exactly what is different from the last one.

This comes up constantly: a supplier sends an updated price list, finance revises the budget, a colleague edits a shared export. You need to know exactly what changed - not approximately, exactly.

Excel does not have a built-in "compare files" feature. The workarounds people use - like conditional formatting, VLOOKUP formulas, or scrolling through both files side by side - are slow, error-prone, and break down the moment you have more than a few dozen rows. This guide covers a faster way.

Why eyeballing differences does not work

• Changes are invisible. A single cell value changed from €24.99 to €27.99 looks identical when you are scanning hundreds of rows. You will miss it.
• You cannot see what was deleted. A row that existed in the original file but is missing from the updated one leaves no trace. You would have to check every single row to notice it is gone.
• Conditional formatting is tedious. You can set up rules to highlight differences, but this only works within one file. Comparing across two separate files requires VLOOKUP formulas, helper columns, and careful setup that breaks every time the structure changes.
• COUNTIF and VLOOKUP only tell you if a row exists. They do not tell you which specific cell changed or what the old value was. You find out something is different, but not what is different.
• It does not scale. Scanning 50 rows by eye is doable. Scanning 5,000 rows is not. And the risk of missing something grows with every row.

How to compare Excel files step by step

Open the Excel Change Tracker, drop in both files (the original and the updated version), and pick the key column that identifies each row. The tool matches rows across both files and shows you everything that changed.

What is a key column?

The key column is the column that uniquely identifies each row - like Product ID, Employee Number, or Invoice ID. The tool uses this column to match rows between the two files so it can detect which rows were changed, which were added, and which were removed. Both files just need to share this column - their other columns can differ in order or content.

Step by step

1. Drop both files into the Excel Change Tracker. Drop the original file on the left and the updated file on the right. It accepts .xlsx, .xls, and .csv files.
2. Pick a key column from the dropdown. The tool shows columns that exist in both files.
3. Click Compare. The results appear instantly in three categories: changed rows, added rows, and removed rows. You can switch between tabs to explore each category.
4. Download the report. Click "Download report" to get a structured .xlsx file with separate sheets for changed, added, and removed rows.

What the tool detects

The comparison produces three categories of differences:

Changed rows. Rows that exist in both files (same key value) but where one or more cell values are different. The report shows you the exact column, the old value, and the new value for every change. If a product's price went from €24.99 to €27.99, you see exactly that.

Added rows. Rows that exist in the updated file but not in the original. These are new entries that were added after the original version was created.

Removed rows. Rows that exist in the original file but not in the updated one. These are entries that were deleted between versions.

The tool also counts unchanged rows so you can see the full picture at a glance: how many rows stayed the same versus how many were modified.

When to compare Excel files

Budget revisions. Finance sends an updated budget and you need to see exactly which line items changed, which were added, and which were cut. Instead of scrolling through both files, run a comparison and get the answer in seconds.

Inventory audits. A warehouse submits an updated stock count. Compare it against the previous export to see which products had their quantities adjusted, which items were added to inventory, and which were removed.

Data import verification. You exported data from one system and imported it into another. Compare the source and destination files to verify that nothing was lost or altered during the transfer.

Reviewing edits before merging. A colleague updated a shared spreadsheet and you need to review their changes before accepting them. The comparison gives you a clear, cell-by-cell view of what was modified.

Price list updates. A supplier sends a new price list. Compare it against the current one to see which products had price changes and by how much, without scanning hundreds of rows manually.

How does this compare to other methods?

	Manual review	VLOOKUP / COUNTIF	Conditional formatting	Spreadsheet Compare (Office)	PicoTools
Time for 1,000 rows	Hours	20-40 min	15-30 min	5-10 min	Under a minute
Shows exact cell changes	No	No (only matches rows)	Partial	Yes	Yes
Detects added rows	Easy to miss	Yes (with formula)	No	Yes	Yes
Detects removed rows	Easy to miss	Yes (with formula)	No	Yes	Yes
Downloadable report	No	Manual setup	No	Yes	Yes
Works on Mac	Yes	Yes	Yes	No (Windows only)	Yes (any browser)
Skill needed	None	Formula knowledge	Intermediate	Excel Pro license	None
No software needed	No	No	No	No	Yes

Your files never leave your device

All processing happens locally in your browser. Your files are not uploaded, stored, or transmitted anywhere. This makes it safe to use with client data, financial records, employee information, or anything confidential.

---

Frequently asked questions

What types of changes does it detect?

Three types: rows that were changed (same key, different values), rows that were added (exist only in the updated file), and rows that were removed (exist only in the original file). For changed rows, the report shows the exact column, old value, and new value.

What is the key column?

The key column is the column that uniquely identifies each row, like Product ID, Employee Number, or Order ID. The tool uses it to match rows across both files. Without a key column, it would not know which row in file A corresponds to which row in file B.

What if my files have columns in different orders?

That is fine. The tool matches columns by name, not by position. Both files just need to share the key column.

Can I compare .xlsx and .csv files?

Yes. You can compare an .xlsx file against a .csv file. The tool reads both formats.

Is there a file size limit?

There is no strict limit. Since everything runs in your browser, performance depends on your device. Most users compare files with thousands of rows without issues.

Can I download the comparison results?

Yes. Click "Download report" after running the comparison. You get an .xlsx file with separate sheets for changed, added, and removed rows.

Does it work on a Mac?

Yes. The tool runs entirely in your browser, so it works on Mac, Windows, Linux, Chromebook, or any device with a modern browser. Microsoft's Spreadsheet Compare tool, which is the closest built-in alternative, is only available on Windows with an Office Pro license.

Is it safe to use with confidential data?

Your files never leave your device. Nothing is uploaded, stored, or visible to anyone. Processing happens entirely in your browser, and all data is gone when you close the tab.