A weekly price list
Key column: SKU. File A has SKU-100 at $9.99; File B has SKU-100 at $12.99.
SKU-100 appears under "changed", with "price" listed as the column that differs.
Excel / CSV Comparator
Compare two spreadsheets by a key column and see added, removed and changed rows.
Was this tool useful?
About this tool
Comparing two spreadsheets by eye — a weekly export against last week's, or two versions of a price list — falls apart past a few dozen rows. Matching rows by a key column (an ID, a SKU, an email) and diffing everything else is the only way to actually trust the result.
How to use it
- Upload both files — Excel or CSV, and pick a sheet if either workbook has more than one.
- Pick the key column that identifies a row across both files — it needs to exist in both, so only columns present in both appear in the list.
- Toggle whitespace trimming and case sensitivity depending on how strict the comparison should be.
- Review the added, removed and changed counts, then download the full report as CSV.
Examples
Common problems
- Every row shows as changed, even ones I know are identical.
- Turn on whitespace trimming and case-insensitive comparison — a trailing space or a capitalisation difference that's invisible when eyeballing a cell still counts as a difference by default.
- The key column dropdown is empty.
- Only column names present in both files can be a key — check for a typo'd header or an extra space in one of the two files' first row.