DataToolsLab
CSV Tools

CSV Diff

Compare two CSV files by key column and see added/removed/changed rows.

Loading tool…

What is CSV Diff?

Compares two CSV files by matching rows on a key column, classifying each row as added, removed, changed, or unchanged with cell-level change detail.

How it works

Both CSVs are parsed and indexed by the key column. Rows present in only one file are added/removed. Rows in both with differing cells are marked as changed.

  1. Paste both files. Paste the original CSV (left) and the modified CSV (right).
  2. Set key column. Enter the column name used to match rows between files.
  3. Read diff. Each differing row is shown with added/removed/changed classification.

Examples

Version comparison

Compare two versions of a CSV with id as the key column. See which rows were added, removed, or had value changes.

Common mistakes

Missing key values

Rows with empty key values are matched by their position rather than content.

Alternatives

JSON Diff

For comparing JSON documents instead of CSV.

Frequently asked questions

What if I don't have a key column?

You must specify a key column. Most CSVs have at least one unique identifier.

Online