Command Palette

Search for a command to run...

CS

CSV Diff Checker

Compare two CSV files and see which rows were added, removed, or changed, down to the exact cell. Match rows by a key column or by position. Runs client-side.

What is the CSV Diff Checker?

A CSV diff checker compares two CSV files and reports which rows were added, which were removed, and which changed, down to the individual cell. Instead of a line-by-line text diff that goes red the moment a single column shifts, it parses both files into rows and columns and compares them as structured data. You paste the old file on the left, the new file on the right, and get four buckets back: added, removed, changed, and unchanged.

The important choice is how rows are paired across the two files. Match by a key column, such as an id or email, and each row is compared to the row that shares its key regardless of where it moved in the file, so re-sorting the export does not create thousands of false changes. Match by position instead, and row one is compared to row one. Key matching is the right mode for database and spreadsheet exports, where the same record can appear on a different line each time you pull the data; positional matching suits fixed-order files like a numbered log.

Everything runs in your browser using an RFC 4180 parser that understands quoted fields, escaped quotes, and commas inside values. The files never leave your device, are never uploaded, and are never logged, which matters because the CSVs people diff are usually customer lists, transaction exports, or inventory tables. Nothing is stored, so the tool keeps working with your network disconnected.

Key-column matching is what makes a CSV diff useful rather than positional, since a row inserted near the top shifts everything below it and a positional comparison reports the whole file as changed. It depends on the key being unique, which is why duplicate keys are flagged rather than silently matched to whichever row came first.

The built-in sample makes a quick check of the CSV diff checker. Both files have the columns id, name, email and plan. With Key: id selected, Compare reports 1 added row (id 5, Erin Park), 1 removed (id 4, Dan Ivanov), 2 changed and 1 unchanged. Expand the changed rows and id 1 shows plan: "pro" -> "team" while id 3 shows only the email cell moving from [email protected] to [email protected]. Bob, on id 2, is counted as unchanged even though nothing about his row is listed.

How to use the CSV Diff Checker?

  1. Paste both CSV files

    Put the original CSV in the first field and the changed CSV in the second. Load the sample if you want to see how added, removed, and changed rows are reported.

  2. Confirm the delimiter and header

    The delimiter is auto-detected as comma, semicolon, tab, or pipe. Leave "first row is a header" on if your files start with column names.

  3. Choose how rows are matched

    Pick a key column, such as id or email, to compare records wherever they moved, or select Position to compare row by row. Tick Ignore case if capitalisation in cell values should not count as a change; key values are still matched exactly.

  4. Compare and export the report

    Press Compare. Open the Added, Removed, or Changed tab to inspect the rows, expand a changed row to see the exact cells that differ, then copy or download the full report.

Key Features

  • Cell-level change detection

    A changed row does not just flag as different. It lists exactly which columns changed and shows the old value beside the new one, so you can see that only the plan field moved from free to pro.

  • Key-column matching

    Pair rows by an id, email, or SKU so a record is compared to its counterpart no matter where it sits in either file. Re-sorted exports diff cleanly instead of reporting every row as changed.

  • RFC 4180 parsing

    The parser handles quoted fields, escaped double quotes, embedded commas, and newlines inside cells, so real spreadsheet exports compare correctly rather than splitting on the wrong character.

  • Duplicate-key and header warnings

    If a key value appears twice, or the two files have different headers, the tool warns you rather than silently producing a misleading diff.

Frequently Asked Questions

Paste the original CSV into the first field and the changed CSV into the second, then press Compare. The tool splits the result into added, removed, and changed rows, and each changed row shows exactly which cells differ. You can match rows by a key column or by their position.

Comments

0 comments

0/2000 characters

No comments yet. Be the first to share your thoughts!

csv diffcsv diff checkercompare csv filescsv comparediff two csv filescsv comparison toolcompare spreadsheetscsv change reportfind changed rows csvcsv row diff