Free · No sign-up · Runs in your browser

CSV Compare by Key

Compare CSV exports by record ID and report added, removed and changed rows regardless of row or column order.

STEP 1

Start with your input

Edit the example or replace it with your own text.

STEP 2

Choose your options

These settings are optional. Keep the defaults to get started.

How to use CSV Compare by Key

  1. Paste the example or your own input.
  2. Choose the options that match your task.
  3. Run the tool, review the result, then copy or download it.

When to use CSV Compare by Key

Line diffs become noisy when exported rows move around. Compare the records by a stable ID instead to find additions, removals and changed cell values. Paste the older export first and the newer export second. Columns are matched by their exact header names, so reordering either rows or columns alone does not create a change.

How to interpret the result

Both tables must have the same set of headers and unique non-empty values in the selected key column. Values are compared as exact strings: whitespace, leading zeros and different number spellings are meaningful differences. Each changed record lists the old and new values for affected columns. Added and removed records include their complete rows. Schema changes require a separate review and are rejected here rather than hidden inside a value comparison.

Example input

id,name,plan
1,Ada,free
2,Grace,pro

What should I check before using the output?

Both tables must have the same set of headers and unique non-empty values in the selected key column.

Is input uploaded?

Processing takes place in your browser. This tool does not send your input or selected files to a conversion API.

Related tools and guides

Browse all developer tools