SheetCompareHow to Compare Two CSV Files
Spot every added, removed, and changed row between two CSV exports, without converting or writing formulas.
Comparing two CSV files by eye is hopeless past a few dozen rows, and the usual workarounds, sorting both files, eyeballing them side by side, or building a VLOOKUP, all break down when rows are reordered or columns shift. What you actually want is a row-by-row diff that matches records by a key and highlights only what changed.
The reliable approach is to align the two files on a column that uniquely identifies each row (an ID, an email, an order number), then compare the rest cell by cell. Done right, a reordered file shows zero changes and a single edited value shows exactly one.
- 1
Open both CSV files
Drop your old CSV in the left zone and the new CSV in the right. Both are parsed in your browser; nothing is uploaded.
- 2
Confirm the header and key column
The header row is detected automatically. Pick the column that uniquely identifies each row so records are matched by value, not position, which makes row order irrelevant.
- 3
Read the diff
Added rows are green, removed rows are red, and changed cells are highlighted with the old value shown. Filter to show only changes to focus on what moved.
- 4
Export the result
Download the comparison as an Excel file with the highlighting preserved, so you can share exactly what changed.
Frequently asked questions
Do the two CSVs need the same column order?▾
No. Columns are matched by header name, so a reordered file compares correctly. Only the header names need to line up.
What if the files have no header row?▾
Add a simple header row (col1,col2,...) to both files first. A comparison needs named columns to match on.
Why are identical-looking rows shown as different?▾
Usually whitespace, case, or number formatting. Turn on trim whitespace, ignore case, and treat formatted and raw numbers as equal to remove those false positives.
How large can the CSVs be?▾
A free account compares files up to 1,000 rows; Pro handles up to 250,000. Everything runs in your browser, so very large files also depend on your device's memory.