Spreadsheet compare
Load two versions of a spreadsheet and see exactly which rows were added, removed or changed.
About Spreadsheet Compare
Choose the original file and the changed file. Rows are paired by the value in a column you pick, such as an ID or an email address, or by their position if the sheets have no key. The page lists every added row, every removed row and every changed cell with the old and new value side by side. You can ignore case and extra spaces, switch sheets in a workbook, and download the list of differences as a CSV file. Nothing is uploaded.
- Checking what a colleague changed in a shared price list.
- Finding rows that dropped out of a monthly export.
- Confirming that a data migration kept every value.
- Comparing two versions of a customer list by email address.
How to use Spreadsheet Compare
Step 1
Choose the original file, then the changed file.
Step 2
Pick the column that identifies each row, or match by row number.
Step 3
Read the differences, filter them, and download the CSV report if you need it.
Good to know
- The key column should hold unique values. If a value repeats, the copies are paired in order and the page warns you.
- Cells are compared as text, so the number 10 and the text 10 count as equal. Formulas are compared by their saved result, not the formula itself.
- Files up to 40 MB are accepted. Only the first 2,000 differences are drawn on the page, and the CSV report holds all of them.
Common questions
Which file types can I compare?
Excel files (.xlsx, .xls, .ods) and CSV or TSV files. You can compare an Excel file with a CSV file.
What if the columns are different?
Columns present in only one file are listed, and rows are compared on the columns both files share.
Is my data uploaded?
No. Both files are read in your browser.