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.
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.
Ready.
CSV diff report appears here.
Data handling: Files and pasted data are processed 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
Limits to review
- 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.
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
Tool advantages
- Runs in this page; the file or pasted data is not sent to a new app.
- Keeps the preview, report, and download in the same screen.
- Gives you a report you can use as a cleanup list.
Step-by-step usage guide
- 1Paste both CSV tables.
- 2Enter the key column name.
- 3Review added, removed, and changed rows.
Common errors and fixes
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.
When to use CSV Diff by Key
- You are checking files before an upload, import, share, or delivery.
- You want to confirm the result before sending it to another system.
- You need a copied result, downloaded file, or report that can be reviewed outside the page.
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.