CSV Compare

Compare two CSV files and see the rows only in one, only in the other, and, with a key column, the rows whose values changed.

Processed on your device. Files are not uploaded

How to compare two CSV files

  1. Paste both files

    The original on the left, the changed one below it.

  2. Add a key column if you have one

    A key such as id lets it show which rows changed.

  3. Read the differences

    Rows are listed as only in one file, or changed.

Worked example

This is what CSV Compare gives for its own sample values. Open the tool above and change anything to try your own.

First CSV (original)

id,name,city
1,Ada,London
2,Linus,Helsinki
3,Grace,New York

Second CSV (changed)

id,name,city
2,Linus,Helsinki
3,Grace,Arlington
4,Alan,London
Delimiter
Detect automatically
Key column (optional)
Resultidnamecity
only in first1AdaLondon
only in first3GraceNew York
only in second3GraceArlington
only in second4AlanLondon

About CSV Compare

Find out what is different between two CSV exports. Without a key it compares whole rows. With a key column it matches rows by that key and shows the values that changed.

FAQs

Do the columns need to be in the same order?

No. With a key, columns are matched by name.

What if there is no key?

Whole rows are compared, so a changed row shows as removed from one file and added to the other.

Can I compare plain text?

Use Text Compare.

Related tools