Compare two tables
Compare two versions of an Excel or CSV file: what is new, what is missing, what has changed?
The tool could not be loaded. It needs JavaScript: please enable it or reload the page.
Old version
No file chosen yet.
New version
No file chosen yet.
CSV, TXT, Excel (XLSX, XLS), OpenDocument (ODS) or JSON.
Differences
Ideally a column with unique values such as a number. «Row by row» compares row 1 with row 1 and so on.
Frequently asked questions
What is the key column?
A column that identifies each row uniquely, such as a customer or article number. Rows are then matched correctly even if the order has changed.
Do the columns have to be in the same order?
No, with a header row the columns are matched by name. New columns appear at the end.
More tools in this category
- Convert spreadsheets Convert between CSV, Excel, ODS and JSON.
- Split a spreadsheet Split large CSV or Excel files.
- XML ↔ JSON Convert XML to JSON and back.
- Remove duplicates Delete duplicate rows in Excel or CSV.
- Average & median Mean, median, standard deviation, quartiles.
- YAML ↔ JSON Convert YAML to JSON and back.