TABLES & DATA

CSV Reconciliation

Paste two versions of a table and see what was added, removed and changed, as you type. Rows are matched by an ID column, so moved rows do not count as edits.

Compare by keyAdded & removed rowsChanged fields
added
removed
changed
unchanged

Using CSV Reconciliation

Paste two versions of a table and see what was added, removed and changed as you type.

  1. Paste the old table in Before and the new one in After, or open files. The first line must be column names.
  2. Enter the column that identifies each row, such as id. Use several if one is not unique.
  3. Read the differences, then copy or download the change report.

Example

In the sample, Jo is added, Lin is removed and Ada changes from active to paused. Sam moves to another row but counts as unchanged.

Questions & answers

Does changing row order count as an edit?

No. Records are paired by the selected key columns regardless of order.

Can I use more than one key?

Yes. Enter column names separated by commas. Their values form a composite string key. Column names containing commas cannot be selected as keys here.

What happens with duplicate IDs?

The comparison stops. Choose additional key columns or fix duplicate and blank keys first.

Are leading-zero IDs kept?

Yes. Values are strings; 001 and 1 are different unless you change the source data.

Can the columns be reordered?

Yes. Columns are paired by exact header name. Added or removed columns are reported on paired records.

Is the exported CSV the merged dataset?

No. It is a change report. Added and removed records are JSON arrays in source header order; the JSON report also contains those headers. Formula-like CSV cells receive a leading apostrophe for spreadsheet safety.

Is my input uploaded for processing?

No. Everything runs in your browser and nothing you type is sent to a server for processing.

Help improve this tool

Report a problem or suggest an improvement

Describe the issue without pasting private tool input. Feedback goes to our admin inbox.

Find another tool · Read practical guides