TaskReadyTools
Menu

CSV Diff by Key

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

Maintained by TaskReadyTools· Testing and correction method

Use this tool

Prepare the input and run the tool

Paste the old CSV, new CSV, and shared key column. Result: Copy the added, removed, and changed row report.

All tools
AssumptionsThe key column must be stable and unique enough for a meaningful comparison.

Ready.

CSV diff report appears here.
Data handling: This page processes only pasted text and form inputs in this browser session.

Readiness details

What to check before using the result

Sample input

Old and new CSV tables that share a stable ID, SKU, email, or order column.

Output preview

A change report separating added rows, removed rows, and rows with changed field values.

Expected checks

  • Added rows
  • Removed rows
  • Changed values by key
  • Duplicate or missing key values

Artifacts you can produce

  • CSV difference report

What this tool does not do

  • The key column must be stable and unique enough for a meaningful comparison.

Practical notes

  • Use the same key column in both files.
  • Review changed rows before syncing a new export over an old one.

References and workflow

Open related workflow

Tool guide

How to use CSV Diff by Key

Use this when two exports are supposed to match but may have changed. Choose the shared ID column and review row-level differences.

What this tool does

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

Input
Paste the old CSV, new CSV, and shared key column
Output
Copy the added, removed, and changed row report

Step-by-step usage guide

  1. 1Paste both CSV tables.
  2. 2Enter the key column name.
  3. 3Review added, removed, and changed rows.

Common errors and fixes

Rows are reported as added and removed instead of changed

The key column may have casing, spacing, or formatting differences between the two CSV files.

Normalize the key column in both exports, then rerun the diff with the exact same key header.

Changed rows include noisy fields

Timestamps, export IDs, or formatting-only fields can create low-value diffs.

Remove noisy columns with the CSV column cleaner before comparing the business fields.

Duplicate keys make the diff unreliable

A key column must identify one row in each CSV.

Fix duplicate IDs, SKUs, or emails before using that column as the comparison key.

FAQ

What is the key column?

It is the shared ID column used to match rows across both CSV tables.

Does this upload my CSV?

The comparison runs in this browser page.