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.

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.

Other tools