Compare Two CSV Files
Compare two CSV or Excel files by a key column and see added, removed and changed rows. Free, runs in your browser.
How to use the Compare Two CSV Files
Compare two datasets and see what was added, removed or changed.
- Load dataset A and B
- Pick or type the key column
- Review and download the differences
Tips
- A key column (like id) matches the same record in both files. Click Use first column as key, pick columns, or type their names.
- If you choose no key, the first two columns of the files are used as the key.
- Numbers match by value, so 36 and 36.0 are treated as equal.
- Use “Ignore case” or “Ignore spaces” to skip trivial differences.
Example
Input: before.csv + after.csv, key = id
Output: Added 3 · Removed 2 · Changed 5
Frequently asked questions
How do I compare two CSV files?
Load both files, choose a key column such as id, and review the added, removed and changed rows.
What if there is no id column?
Choose any columns, or leave it empty and the first two columns are used as the key.
Can the files be different formats?
Yes. A can be a CSV and B an Excel file. Columns are matched by name. JSON and Parquet files are not supported here, so convert them to CSV first.
Guides