Has someone edited your spreadsheet and you need to know exactly what changed? Whether you're auditing a price list, reviewing a data export, or reconciling two versions of a customer database, comparing spreadsheets row by row is a surprisingly tricky task.
Common Ways People Compare Spreadsheets (and Their Drawbacks)
- Side-by-side manual review — error-prone and painfully slow beyond 50 rows
- Excel conditional formatting with IF formulas — hard to set up, doesn't show what specifically changed
- Excel Inquire add-in — Windows-only, not available in Excel for Mac or Microsoft 365 web
- Copy-paste into a diff tool — loses formatting, treats everything as plain text
What a Proper Spreadsheet Diff Should Show You
A good comparison tool should categorise every row into one of four states:
| Status | Meaning | Colour |
|---|---|---|
| Added | Row exists in the new file but not the old | Green |
| Removed | Row existed in the old file but is gone | Red |
| Modified | Row exists in both but at least one cell value changed | Amber/Yellow |
| Unchanged | Row is identical in both files | Grey/White |
Modified rows are the most important to investigate. The tool should highlight exactly which columns changed within those rows, not just flag the whole row as different.
How to Compare Files Step by Step
- Open the Compare tool and upload your Old File (the original version) on the left
- Upload your New File (the updated version) on the right
- Choose your key column — this identifies which rows are the 'same' record across both files (e.g. Product ID, Employee Number)
- Select your match mode: Exact (fast, strict) or Fuzzy (handles minor formatting differences)
- Click Compare — a colour-coded diff table appears instantly
- Use the filter tabs to view only Added, Removed, Modified, or Unchanged rows
- Download the full diff as CSV to share or audit further
Tips for Better Results
- Make sure both files have the same column headers — the tool uses column names to match values across versions
- Choose a key column that uniquely identifies each row — if duplicate keys exist, results may be unpredictable
- If comparing exports from two different systems, normalise dates and number formats first to avoid false 'Modified' flags
- Use fuzzy matching when your key column may have trailing spaces or mixed capitalisation
The Compare tool handles files entirely in your browser. No data is sent to any server — useful when comparing confidential HR records, financial data, or customer information.
Upload two spreadsheet versions and get a colour-coded diff in seconds — completely free, no account needed.
Try the Compare Tool Free