Compare two Excel or CSV files
Compare two Excel or CSV files and see changed cells, new rows and removed rows. Match by a key column or by row position, and download a report. Free, and your files never leave your browser.
When to use it
When you get an updated spreadsheet, you often need to know what changed: which rows are new, which were removed, and which cells have different values. Checking by eye is slow and easy to get wrong.
Add the old file and the new file, pick a key column such as an ID or email so rows are matched correctly even if the order changed, and see every difference. You can download the full report as an Excel file.
How it works
- Drop the original file in the first box and the new file in the second.
- Choose a key column, like an ID, to match rows. Or match by row position.
- Read the changed cells and the added and removed rows, then download the report.
Questions
How does it match rows?
By the key column you choose, such as an ID or an email address. Rows with the same key are compared cell by cell. This works even when the two files list the rows in a different order. You can also match by row position instead.
What counts as a difference?
A cell is different if its value is different. You can choose to ignore extra spaces and upper or lower case. Rows whose key is in only one file are listed as new or removed.
What if the files have different columns?
Only the columns with the same name in both files are compared. Columns that appear in only one file are listed so you can see what was left out.
Does it compare formulas?
It compares the values the cells show, not the formulas behind them. Dates are compared as year-month-day text.
Are my files uploaded anywhere?
No. Both files are read inside your browser tab and nothing is sent to a server.
Did this help?
Tell me what worked, what broke, or what tool you want next. I read every message.
Send feedback