CSV Difference Checker
Free online CSV diff tool. Compare two CSV datasets to find added rows, removed rows, and cell-level changes. No upload required.
Loading tool...
What is CSV Difference Checker?
The CSV Difference Checker is a browser-based tool that compares two comma-separated datasets and produces a clear breakdown of what changed between them — rows that were added, rows that were removed, and individual cells whose values were modified.
Key Benefits
- Instantly spot data drift between exports, versions, or branches
- Audit cell-level edits without eyeballing two spreadsheets side by side
- Match rows by primary key so reordering does not count as a change
- Export a structured text report for tickets, PRs, or compliance logs
- Keep sensitive data private — everything runs locally in the browser
Common Use Cases
- •Verifying a database export before and after a migration
- •Comparing product catalogs or price lists across versions
- •Reviewing manual edits made to a CSV in Excel or Google Sheets
- •Reconciling two data feeds from different teams or systems
- •Generating a change log for version-controlled CSV assets
How to Use the CSV Difference Checker
- Paste your two CSV datasets: Enter the original CSV in the left box (CSV A) and the new CSV in the right box (CSV B). Both must be comma-separated.
- Configure comparison options: Check "First row is header" if your data has column names, choose a mode (key column or row-by-row), and pick the key column index if matching by key.
- Read the summary and detail tables: The four summary tiles show counts of unchanged, added, removed, and changed rows. Scroll down to see color-coded tables for each category.
- Export the diff report: Click Copy to put a text summary on your clipboard, or Download to save it as a .txt file for sharing or record-keeping.
Key Features
- RFC 4180-compliant CSV parser that correctly handles quoted fields and escaped quotes
- Two diff modes: match rows by a key column (primary key) or compare position-by-position
- Cell-level change detection showing exactly which values moved from old to new
- Color-coded summary tiles for added (green), removed (red), and changed (amber) rows
- Toggles for header detection, whitespace normalization, and case sensitivity
- Export the full diff report as copyable text or a downloadable .txt file
Frequently Asked Questions
What CSV formats does the parser support?
It follows RFC 4180: comma-separated values, double-quote escaping (two quotes inside a quoted field become one), newlines inside quoted fields, and optional headers. It also tolerates stray carriage returns (
).
What is the difference between key-column mode and row-by-row mode?
Key-column mode matches rows by a chosen column (e.g. an ID) so order does not matter — a row can move position and still be unchanged. Row-by-row mode compares line N of CSV A with line N of CSV B, which is useful when order is meaningful, like timeline logs.
How does the tool handle duplicate keys?
When two rows share the same key value, the last occurrence wins for comparison. This is a simple deduplication behavior; if your data has genuine duplicate keys, consider row-by-row mode instead.
Is my CSV data uploaded to a server?
No. All parsing and comparison happens entirely in your browser using JavaScript. Nothing is sent over the network, so you can safely diff sensitive data like customer lists or financial exports.