Data Comparison (CSV and Excel Diff)

Compare two CSV, Excel, JSON, Parquet or Avro files by a key column. See inserts, updates and deletes (CDC), cell by cell. Free, in your browser.

Quick answer: Compare two datasets and see what was added, removed or changed.

Related: Compare Two CSV Files · Compare Two Excel Files · Compare Two Parquet Files · Compare Two JSON Files · CSV Guides and Free CSV Tools

How to use the Data Comparison (CSV and Excel Diff)

Compare two datasets and see what was added, removed or changed.

Data Comparison shows exactly what changed between two versions of a file. Pick a key column, or use the first column or the first two columns, and it lists rows that were added, removed or changed, down to the cell. Use it to check an export against last month, to review a data migration, or to find which values a script changed. CSV, Excel, JSON, Parquet and Avro are supported, and the two files can be different formats.

  1. Load dataset A and B
  2. Pick or type the key column
  3. Review and download the differences

Tips

Example

Input: before.csv + after.csv, key = id

Output: Added 3 · Removed 2 · Changed 5

Browse by topic

Who uses Data Utility

Frequently asked questions · Data format benchmark

Frequently asked questions

Can I use it for change data capture (CDC)?

For files, yes. Load yesterday's snapshot and today's, choose the key, and the added rows are the inserts, the changed rows are the updates and the removed rows are the deletes. It is a snapshot comparison, not log-based CDC: it does not read database logs or stream changes live.

How do I find new, updated and deleted rows between two files?

Load both files, choose a key column such as id, and read the three lists: added (new), changed (updated, with the old and new value of each cell) and removed (deleted).

Which file formats can I compare?

CSV, TSV, Excel (.xlsx), JSON, Parquet and Avro, in any combination. For example, compare a Parquet file with the CSV it was made from. Nested JSON and Avro fields are flattened into columns such as address.city.

Will 10 in a CSV match 10 in a Parquet file?

Yes. Values are compared by meaning, not by how they are written: 10 equals 10.0, true equals "true", and a date equals the same date in any format. A value only counts as changed if it really differs.

Can Data Comparison do change data capture (CDC)?

It does the snapshot version of CDC for files. Compare the earlier and the latest export by key: added rows are inserts, changed rows are updates and removed rows are deletes. It does not read database logs or run in real time.

How does Data Comparison find differences?

It matches rows by a key column, or by the first two columns, and shows which rows were added, removed or changed, down to the cell. It works with CSV and Excel files.

Related pages

Topic guides

Guides