How to compare two Excel files and find differences
Excel Compare — open the free tool →Price lists, stock sheets, payroll, budgets and exported reports change all the time. Spotting what changed between two versions usually means VLOOKUPs, conditional formatting or a lot of scrolling. Here are simpler ways.
Method 1: Excel Compare online
- Open Excel Compare.
- Select the original .xlsx or .xls file on the left and the updated file on the right.
- Wait while the cell values are extracted. Each sheet appears under its sheet name.
- Click Compare now to see changed rows, with the changed values highlighted.
- Download the report for your records.
The workbooks are read in your browser and not uploaded to a CompareOnline4U server, which matters for salary, customer and financial data.
The one step that makes or breaks the result: sorting
Rows are compared in order (an inserted or deleted row is lined up automatically). If one file is sorted by name and the other by date, almost every row will look "changed". Before comparing:
- Pick a key column that identifies each row (Product ID, Employee ID, Invoice number).
- Sort both files by that column in the same direction.
- Keep the same column order and sheet order in both files.
Method 2: A formula in Excel
If both sheets are in the same workbook with identical layouts, you can add a third sheet and use a formula like:
=IF(Sheet1!A1<>Sheet2!A1, "Changed", "")
Fill it across and down the same range. Cells that differ show "Changed". This works for fixed layouts, but it breaks when rows are added or removed, because everything below shifts.
Only need missing IDs? Compare the key columns as lists
If the question is simply "which invoice numbers are in this file but not in that one", copy the ID column from each file and paste them into List Compare. It ignores row order and shows the IDs only in the first file, only in the second, and in both. See how to compare two lists in Excel for formula methods too.
Method 3: Compare as CSV
If your data is a simple table, save both files as CSV and use CSV Compare. This is handy for exports from software that already produces CSV.
What gets compared
- Compared: cell values on every sheet.
- Formulas: compared as formula text (e.g.
=SUM(B2:B9)), not as the calculated result. - Not compared: cell colours and formatting, charts and comments.
Tips
- Remove empty rows at the top so headers line up.
- Be careful with dates and numbers stored as text. "01-04-2026" and "2026-04-01" look different to a comparison even if they mean the same date.
- Use Only changes on large sheets so you see just the differences.
Frequently asked questions
Can I compare two Excel files without formulas?
Yes. Excel Compare reads both workbooks and highlights changed rows and values, no formulas needed.
Are formulas and formatting compared?
Formulas are compared as formula text (for example =SUM(B2:B9)), so a changed formula shows up. Other cells are compared by value. Formatting, charts and comments are not compared.
What if my rows are in a different order?
Rows are compared in order. Inserted or deleted rows are lined up automatically, but if the two files are sorted differently many rows will look changed, so sort both sheets by the same ID column first. To check only which IDs exist in one file and not the other, paste the two ID columns into List Compare.