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
Paste the original CSV on the left and the changed one on the right, or open two .csv files. The key column is picked for you (an id first); choose another, or Row number to compare line by line. 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
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
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
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.