← All use cases
Example rows with sample data
Compare price lists in Google Sheets
A supplier or a colleague sends an updated price list. Find every difference in minutes.
How it works here
Paste the old price list into one tab and the new one into another. Pick the product code as the key column and SheetCompare shows each product that was added, removed or had a different price.
Good key column: SKU or product code.
| Status | Key | What changed | Old value | New value |
|---|---|---|---|---|
| changed | SKU-2210 | Price | 12.00 | 13.50 |
| added | SKU-2299 | New row | — | Cable organizer · 7.90 |
| removed | SKU-2105 | Row is gone | Desk clamp · 21.00 | — |
Tips
- Use the same column headers in both tabs. Only columns present in both are compared.
- Each product code must appear once per tab. Duplicates stop the run and list the rows to fix.
Want to try it on sample data first? Download the sample files.