<Diff
Stack/>

CSV File Compare Online

Compare two CSV files with a column-aware diff: match rows by key column and see added, removed, and changed rows. Free and 100% in your browser.

Match CSV rows by ID instead of row position

Compare CSV exports using a unique key column such as a product ID. The summary separates added, removed, and modified rows and identifies the columns whose values changed, even when row order differs.

How to Compare Two CSV Files

  1. 01.Load your files

    Upload two comma-separated files with header rows and choose a unique key column from the original file.

  2. 02.Find differences

    Select Find Differences to compare both versions. Use Try an example to load the sample below and open its diff.

  3. 03.Review the result

    Review added, removed, and modified rows in the key-column summary, then check the text diff.

CSV comparison example

Original
id,product,price,stock
101,Keyboard,49.99,120
102,Mouse,19.99,300
103,Monitor,189.00,45
104,Webcam,59.00,80
Modified
id,product,price,stock
101,Keyboard,54.99,95
102,Mouse,19.99,300
104,Webcam,59.00,0
105,Headset,89.00,60

Using id as the key, product 103 is removed and 105 is added. Product 101 changes price and stock, product 104 changes stock, and product 102 stays unchanged.

CSV Diff Tips

Pick the right key column

The column-aware diff matches rows by a key column (like an ID). Choose a column whose values are unique per row — matching on a non-unique column pairs the wrong rows.

Row order stops mattering with a key

With key matching, a re-sorted export shows zero changes unless values actually changed — something a plain line diff cannot do.

Watch delimiter and quoting differences

Exports from different tools may quote fields differently or use semicolons. Normalize to comma-separated, consistently quoted CSV for accurate comparison.

Before you compare

Both files need the same column names and a unique key per row. Duplicate keys or malformed CSV prevent row matching; the plain-text diff is still available. Semicolon-separated files should be converted to comma-separated CSV first.

Each side supports up to 250,000 characters or 5,000 lines. Each uploaded text file can be up to 256 KB. Compared contents stay in your browser. No account is required.

Working with another format? Try SQL Difference Checker or File Comparison Tool.

Frequently Asked Questions

Clear answers to your comparison queries.