How to compare two Excel sheets for differences and missing data
Compare two Excel sheets cell by cell or row by row. Formulas to find missing rows and changed values, conditional formatting, and a no-formula option.
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
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:
=IF(COUNTIF(New!$A$2:$A$5, A5)=0, "Removed", "") →Removed
=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.
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.
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")) 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.
Compare two Excel sheets cell by cell or row by row. Formulas to find missing rows and changed values, conditional formatting, and a no-formula option.
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.
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.
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.
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.
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.
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.
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.