Skip to content
Sealpaste

Delete all recent work?

This removes the 0 items saved in this browser. Your settings stay.

Stop saving recent work?

New work won't be saved in this browser. The 0 items already saved can stay or go.

CSV Diff

Original CSV

Paste the original CSV, or

Changed CSV

Paste the changed CSV, or

Differences
Ready
Runs in your browser. Nothing you paste is uploaded unless you share it.

Compare two CSV files row by row: rows matched by a key column, columns by name, changed cells marked, added and removed rows listed

Paste two exports of the same table and see which rows were added, removed or changed, and which cells changed in them.

How to use it

  1. Paste the original CSV on the left and the changed one on the right, or open two .csv files.
  2. The key column is picked for you (an id first); choose another, or Row number to compare line by line.
  3. Rows shows each row that differs with its changed cells marked; Cells lists every changed value. Copy report gives them as text.

Example

A price change, a row added, a row removed

Input
sku,name,price
MUG-01,Mug,12.50
PEN-11,Pen,1.20

sku,name,price
MUG-01,Mug,13.00
BAG-04,Tote bag,30.00
Result
Changed  sku MUG-01  price: 12.50 → 13.00
Added  sku BAG-04  BAG-04, Tote bag, 30.00
Removed  sku PEN-11  PEN-11, Pen, 1.20

The report as Copy report gives it: rows matched by sku, the column that is filled in and unique on both sides.

How rows are matched

Two exports of a table rarely list rows in the same order, so rows are matched by a key: the first column that is filled in and unique in both files, with names like id, sku, code or email tried first. The status bar names the column it took, and Key lets you choose another.

With Row number, row 2 is compared with row 2 and so on: right for files that only change values in place. If the key you choose repeats a value, those rows are matched in order, the first with the first.

What counts as a change

  • Columns are matched by their header name, so a column that moved is no change; one only one file has is listed as added or removed.
  • Values are compared as text: 1.50 and 1.5 differ unless Numbers by value is on, and Mug and mug differ unless Ignore case is on.
  • Ignore spaces drops the spaces at either end of a value, which spreadsheets often add.
  • Quotes follow RFC 4180, so a value with a comma or a line break inside quotes is one value. Commas, semicolons and tabs are found on their own.

Questions

Can I compare two Excel sheets?
Save each sheet as CSV (File → Save As → CSV) and compare the two files here.
Why is every row changed?
The rows were most likely matched by position while one file is sorted differently. Choose a column that identifies a row, such as id, as the Key.
Are my files uploaded?
No. Everything runs in your browser, so your CSV stays on your device. Nothing you paste is uploaded unless you share a result, which is locked with your password first.

Related tools