CompareOnline4U.

Home › Guides

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

  1. Open Excel Compare.
  2. Select the original .xlsx or .xls file on the left and the updated file on the right.
  3. Wait while the cell values are extracted. Each sheet appears under its sheet name.
  4. Click Compare now to see changed rows, with the changed values highlighted.
  5. 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:

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

Tips

Excel Compare — open the free tool →

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.

More guides

How to compare two CSV files row by rowFind added, removed and changed rows between two CSV exports. Free method with tips on sorting, delimiters and columns for accurate results.How to compare two lists in Excel and find missing itemsFind items in List A that are not in List B with COUNTIF, MATCH or FILTER in Excel, or paste both lists into a free online list compare tool.How to compare two Word documents and find every changeGot a revised Word file without tracked changes? Learn 3 ways to compare two .docx documents, including a free online method that keeps files private.दो Word फाइल में अंतर कैसे पता करेंकिसी ने Word फाइल में बदलाव करके वापस भेजी है? जानिए दो .docx फाइल को फ्री में कैसे compare करें और हर बदला हुआ शब्द कैसे देखें।

← All comparison tools