Quickly find differences between two columns in Excel or Google Sheets. No formulas, no VLOOKUP needed.
Match by the first column, even when rows change order. Each example has one added, one removed, one changed and one unchanged record.
| Customer ID | Name | Status | |
|---|---|---|---|
| C001 | Alex Morgan | alex@example.com | Active |
| C002 | Sam Lee | sam@example.com | Trial |
| C003 | Jordan Kim | jordan@example.com | Active |
| Customer ID | Name | Status | |
|---|---|---|---|
| C004 | Taylor Reed | taylor@example.com | Trial |
| C002 | Sam Lee | sam@example.com | Active |
| C001 | Alex Morgan | alex@example.com | Active |
Expected: 1 added · 1 removed · 1 changed · 1 unchanged
Fictional data. Loading an example replaces the current inputs. Select Compare rows below to run it.
01
Upload two CSV or Excel files. Match records using an ID or a combination of key columns.
02
Separate new, removed and changed records. Check before-and-after values and duplicate-key warnings.
03
Download the CSV or Excel report. Keep your matching rules for the next comparison.
A comparison finds differences; it does not decide which source is correct. Resolve duplicate IDs and review matching rules before acting on a report.
Open the Excel or Google Sheets file containing the columns you want to compare.
Select the first column, copy it (Ctrl+C), then paste it into List A. Repeat for the second column into List B.
Click Compare. Download results as CSV to paste back into your spreadsheet.