Tool 04 · Data lab

Compare Two Excel Sheets Online

DIFF :: ADDED · REMOVED · CHANGED

Compare two Excel sheets or CSV files online, an old and a new version: rows added, rows removed, and every changed cell shown old → new. Free, and your files never leave your browser.

100% in your browser: your data never leaves your device

Step 01

Old version

100% in-browser
Step 02

New version

100% in-browser

How does it compare two spreadsheets?

It reads both versions, lines each row of the new one up with its partner in the old one by a column that identifies it, such as a SKU, an ID or an email, and then checks every column the two share. A row is added if its key is new, removed if its key has gone, and changed if any value is different. Here is a small price list, last month and this month:

  • C4 Tape was 2.25
  • A5:D5 P-104 is not in the new list: removed

=IF(COUNTIF(New!$A$2:$A$5, A5)=0, "Removed", "") →Removed

  • C2 Tape is now 2.40: changed
  • A4:D4 P-105 was not there last month: added
  • A3:A5 a different order, still matched by SKU

=IF(COUNTIF(Old!$A$2:$A$5, A2)=0, "Added", IF(XLOOKUP(A2, Old!$A$2:$A$5, Old!$C$2:$C$5)=C2, "Same", "Changed")) →Changed

The tool gives the same answer as those two formula columns: P-104 removed, P-105 added, and Tape changed from 2.25 to 2.40. In the report the changed cell reads 2.25 → 2.40, so you see the old and new value side by side.

Why line rows up by an ID, not by row number?

Comparing row 2 with row 2 only works if nothing was inserted, deleted or sorted. One new row near the top and every row below it looks different, even though nothing changed. Lining rows up by a key finds each product wherever it sits, which is why the new list above can be in a different order. If no single column is unique, line rows up by two together, such as first and last name.

How do you compare two Excel sheets with formulas?

Put each version on its own sheet and add a Status column beside the new one. COUNTIF checks whether the key exists on the old sheet at all, and XLOOKUP fetches the old value for IF to compare:

=IF(COUNTIF(Old!$A$2:$A$500,A2)=0,"Added",IF(XLOOKUP(A2,Old!$A$2:$A$500,Old!$C$2:$C$500)=C2,"Same","Changed"))
✎ Fill it down beside the new data. To find removed rows, run COUNTIF the other way round on the old sheet.

That checks one column at a time, so the tool above is quicker for wide tables: it checks every shared column at once and writes this formula for your own columns under the result. The COUNTIF lesson and the XLOOKUP lesson teach both halves, and how to compare two Excel sheets for differences covers cell-by-cell checks and Excel's own compare options.

Revision Q&A

(click a question) Lab module 04
Q1: Is this tool for comparing two spreadsheets free?

Yes, free with no sign-up. Paste or upload the old and new version of a table, and it lists every row added, removed or changed. Everything runs in your browser, so your files are never uploaded.

Q2: How does it know which rows belong together?

It lines rows up by a column that identifies each one, such as a product code, an ID or an email, and picks one for you. The rows can be in any order and the columns can be rearranged: columns are paired by their header.

Q3: What counts as a change?

Any cell in a column both versions share that holds a different value. Extra spaces and upper or lower case are ignored by default, and 1.2 and "1.20" count as the same number. Under More options you can make text comparisons strict or let numbers differ by a small amount, such as 0.01.

Q4: Can I compare two Excel files with different columns?

Yes. Columns with the same header are compared; a column only in the new version is listed as new, and one only in the old version as gone.

Q5: What is in the Excel report?

A Changes sheet with each changed cell written as old → new, an Added rows sheet, a Removed rows sheet and a full report with every row and its status.

Q6: How do I compare two sheets in Excel itself?

Add a status column beside the new data: COUNTIF finds rows missing from the old sheet, and XLOOKUP inside IF checks whether a value changed. The tool writes that formula for your own columns under the result.

Q7: What if I only need to compare two lists, not tables?

For single columns of names, emails or codes, ListDiff.com compares two lists and shows what is only in one, only in the other, or in both.

Know someone fighting with a spreadsheet? Send them this page.