Data cleaning / FREE

Dataset Comparison

Compare two datasets by business keys and find added, removed, and changed records.

Make it work with your data.
Local processing · up to 2 MB / 50,000 rows
Local processing · up to 2 MB / 50,000 rows

Use Ctrl / Command to select multiple columns.

HOW TO USE IT

Dataset Comparison

Load the before and after files, read their columns, and select a unique key or composite key. Run the comparison and export the change report.

What to know

Both datasets must have unique, nonblank selected keys. Duplicate keys are rejected rather than paired arbitrarily. Missing columns are identified separately. Added and removed records are exported as JSON arrays in the report’s before/after fields; changed records have one row per changed column. Reports are limited to 50,000 differences.

← Explore all tools