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
Paste both files
The original on the left, the changed one below it.
Add a key column if you have one
A key such as id lets it show which rows changed.
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)
| Result | id | name | city |
|---|---|---|---|
| only in first | 1 | Ada | London |
| only in first | 3 | Grace | New York |
| only in second | 3 | Grace | Arlington |
| only in second | 4 | Alan | London |
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.