CSV · Compare before you import
Compare two CSV files by key column
Before you re-import an edited table, compare it with the original row by row. See which cells were wiped, which columns went missing and which rows changed.
- You need
- Two CSV or TSV tables (original and updated), up to 2 MB each, with 1 or 2 unique key columns
- You get
- Counts of changed rows and cells, warnings for wiped cells and missing columns, optional column totals, and a CSV listing every change
- Where files go
- Processed in this browser only. Nothing is uploaded; closing the page clears it.
1
Add original and updated tables
Original table (Before)
Drop original CSV here
.csv, .tsv or .txt · up to 2 MB
Updated table (After)
Drop updated CSV here
.csv, .tsv or .txt · up to 2 MB
Up to 2 MB, 20,000 records and 200 columns per table. No autosave. Original files are never overwritten.
2
Choose matching columns and compare
Add both tables above to load shared column headers.
3
Column totals
Output: UTF-8 with BOM, comma separators, CRLF line endings and quoted cells. Columns: change_type, key, column, before_value, after_value. A two-column key is written as a JSON array in the order selected.
What this comparison does and does not do
Checks and reports
- Matches rows strictly by the 1 or 2 key columns you select (trimmed exact match).
- Flags cells wiped from non-empty to blank, plus columns dropped from or added to the updated table.
- Optionally adds up one number column in both tables without rounding errors, and warns if every value in it changed sign.
- Exports a UTF-8 with BOM diff CSV after an explicit choice if formula-like cells appear.
Does not
- Guess which rows match when a key is blank or duplicated. The check stops and lists the record numbers.
- Treat currency symbols, thousands separators, scientific notation or text as 0. Cells it cannot read as numbers are counted separately.
- Repair broken quotes or inconsistent column counts in either input table.
- Validate Shopify, ERP, payroll or accounting business rules or guarantee import acceptance.