Compare

CSV Compare

Spot what changed between an original and an updated export. Pick the column (or columns) that identify a record, such as ID, and get a clear list of new, deleted and edited rows with old and new values side by side. Everything is processed in your browser; your data is not uploaded.

Back

1. Original and updated data

Local only

Processed in your browser; your files and data are not uploaded or stored. Formulas, macros and scripts in your data are never run.

2. Comparison

Live preview

Matching keys are never guessed: choose key columns, or explicitly choose row-position comparison and accept its limitation.

CSV downloads use safe export by default: cells starting with =, +, -, @, a tab or a carriage return get a leading apostrophe so spreadsheet apps treat them as text.

Data is processed in your browser's memory. Limits: 20 MB per file, 200,000 rows, 1,000 columns and 3,000,000 cells.

About this tool

About CSV Compare

CSV Compare finds the differences between an original and an updated CSV or TSV table. Rows are matched by key columns you choose — or by row position if you explicitly ask — and the result lists added, removed, changed and unchanged rows, with the original and updated value of every changed cell.

Comparing two exports by eye misses changes, and generic text diffs get confused when rows move. Matching on keys finds the same record wherever it is in each file. The tool never guesses keys, warns about duplicate keys, and explains the limits of row-position comparison.

How to use

Step by step

  1. Add the original table and the updated table (upload or paste).
  2. Choose key columns that identify each record, or choose row position.
  3. Set case sensitivity and whether surrounding spaces are ignored.
  4. Review the counts and the lists of changed cells, added rows and removed rows.
  5. Download the CSV report or the text summary.
Key features

What it offers

  • Key-column matching with one or more columns
  • Explicit row-position mode with a clear warning
  • Added, removed, changed and unchanged counts
  • Changed cells with key, column, original and updated value
  • Duplicate-key detection
  • CSV report and plain-text summary exports
Best practices

Tips for best results

  • Use a stable ID column as the key whenever one exists.
  • Ignore case and spaces only when they are not meaningful.
  • Check columns reported as present in only one file.
  • Keep the CSV report alongside the files you compared.
Benefits

Why people use it

Accurate matching

Records are matched by key, not by position.

Clear changes

See old and new values for every changed cell.

Private

Both tables stay in your browser.

FAQ

Common questions

Columns whose values identify a record in both files, such as an ID or an email address. Rows with the same key are compared cell by cell. You can combine several columns, for example Order and Line. The tool never picks keys for you.
Choose "Row position" to compare row 1 with row 1, row 2 with row 2 and so on. This only works if both files list the same records in the same order — one inserted or deleted row makes every later row look changed, and the page warns you about this.
Added rows have a key that appears only in the updated file; removed rows have a key only in the original. Changed rows exist in both but differ in at least one compared column. Unchanged rows are identical in every compared column.
The comparison stops and lists the duplicate keys, because a row could not be matched reliably. Add another key column so each record is unique.
They are listed in a note and are not compared, so they do not make every row look changed.
The CSV report has one line per change: change_type (changed, added or removed), the key, the column, the original value and the updated value. The text summary gives the counts, the settings used and the changed cells.
Yes. Untick case-sensitive comparison to treat "Pune" and "pune" as equal, and tick "Ignore surrounding spaces" to ignore leading and trailing spaces. These options apply to both keys and values.
No. Both tables are compared in your browser and nothing is stored.
Private by design

This runs entirely in your browser

No file or text you enter here is uploaded. Encoding and decoding happen on your device using native browser APIs — close the tab and nothing remains on a server.

Install Toolisco Add it to your device for offline, one-tap access.