CSV Diff — Compare Two CSVs by Key
Compare 2 CSVs by key column. Detects added/removed/changed rows (which cell changed, from what to what). Supports , ; tab | delimiters.
Compare 2 CSVs by key column. Detects added/removed/changed rows (which cell changed, from what to what). Supports delimiters , ; tab |.
When to use CSV Diff
- Track product catalogs: dump this week's price list vs last week's — see which prices changed.
- Database migrations: export old + new tables → check missing rows and schema changes.
- Audit data imports: before/after importing a CSV into the DB — verify row counts.
- HR / payroll: this month's roster vs last month's — who joined, who left, who got a raise.
- Finance reconciliation: compare transaction logs from 2 sources (bank + accounting).
How it works
The tool matches rows between A and B by a key column (first column by default). Then:
- Added: rows in B but not in A.
- Removed: rows in A but not in B.
- Changed: same key in both but cell values differ.
- Unchanged: same key, every cell matches.
For changed rows, the tool highlights which cells changed (red strikethrough for the old value, green for the new).
Tips
- Pick the right key column: ID, SKU, email — anything unique. Avoid names (can collide).
- Composite keys: the tool only supports a single column. For composite keys, pre-build a combined column (e.g.
user_id-date). - Excel data: export to CSV with "," delimiter (US/VN) or ";" (EU).
- Privacy: runs 100% in your browser. Sensitive data stays local.
Who this is for
Backend devs, API integrators, anyone debugging JSON/YAML/CSV payloads or working with structured data.
FAQ
Is my sensitive data safe?
Yes. JSON/YAML/CSV you paste is NOT uploaded to any server. All processing happens locally in your browser.
Is there a size limit?
Browser RAM dependent. Files under 10MB run smoothly. Larger files may freeze the tab.
Related tools
See all tools →JWT Decoder
Decode JWT tokens — header, payload, claims with readable timestamps.
NEWJSON Formatter
Format / minify / validate JSON. Sort keys A-Z, custom indent, Ctrl+Enter shortcut.
NEWUUID / Hash / Base64 / URL
Bundle: UUID v4, SHA-256/512 hash, Base64 (URL-safe), URL encode.
NEWJSONPath Tester
Test JSONPath queries against JSON samples. Pick data from API responses, debug structured output. Recursive descent + filters.