📊 Excel Compare
How to use: Choose the original and the changed Excel or CSV file, match by cell address or by rows, then press Compare files. See every changed, added and removed cell and download the list as CSV.
Loading the tool…
About the Excel Compare
Two versions of a price list, a stock sheet or a salary file can differ in a handful of cells that are almost impossible to spot. The ToolSandook Excel Compare tool checks every cell for you.
Choose the original and the changed file (.xlsx, .xls or .csv). Sheets with the same name are compared cell by cell, and you get a list of every changed, added and removed cell with its address, such as B12. If rows were inserted or deleted, match by rows instead so the rest of the sheet does not show as changed. Download the list of differences as a CSV that opens in Excel.
How to use the Excel Compare
- Choose the original Excel or CSV file.
- Choose the changed file.
- Optionally type the columns to check in each file and the starting row.
- Pick Match by cell address or by rows.
- Press Compare files, then review or download the differences.
Features
- Works with .xlsx, .xls, .ods and .csv
- Cell-by-cell or row-by-row compare
- Sheets matched by name
- Choose which columns to check, e.g. C in one file and D in the other
- Download differences as CSV
Frequently asked questions
Can I compare only certain columns?
Yes. Type the columns to check in each file, for example C in the original and D in the changed file, or A,C:E. You can also choose the row to start from. Leave the boxes empty to check every column.
Does it compare formulas?
It compares the values as they appear in Excel. If a formula changed but gives the same result, it is not shown as a difference.
What if rows were inserted?
Choose Match by Rows. It lines up rows that match and shows only the rows that were added, removed or changed.
Can it compare sheets with different names?
Sheets are matched by name. If no names match and each file has one sheet, those two sheets are compared.
Are my files uploaded?
No. Both files are read in your browser and never leave your device.
Related tools
- Text Compare – Find differences between two texts, word by word.
- Word File Compare – Compare two Word (.docx) documents.
- XML Compare – Compare two XML files and check they're valid.
- GST Invoice Generator – Invoices with GST breakup.