Practical guide

Compare Spreadsheets

Prepared by: Gsetsoft · Updated:

Find differences between your price list and a supplier update with this tool. Old and new files analyze in your browser. A shared key column and identical headers are required. Only visible values compare.

Comparison highlighting added and changed rows.
Comparison highlighting added and changed rows.

Step by step

  1. Save both lists as UTF-8 with matching delimiters.
  2. Upload old file first, new file second.
  3. Select a key column like Product Code.
  4. Run and inspect added and changed rows.
  5. Download the report for the team.

Example scenario

A 1200-product old list meets a 1250-product update. Keyed on Product Code, the tool reports 30 new, 15 removed, 80 price changes. The list goes to accounting.

Check your result

Confirm no duplicate keys and exact headers. Manually verify a sample product. Wrong row counts suggest encoding issues.

Frequently asked questions

What is a key column?

The unique field identifying each row.

Case differences?

May count as different headers; standardize.

Formulas or results?

Only displayed values compare.

Different delimiters?

Columns split wrongly; re-save consistently.

Open the tool: Compare spreadsheets →

Keep an original copy before processing your file. Examples are illustrative; results depend on your document.

Your privacy choice

Essential cookies keep tools working securely. With your permission, we collect approximate country and usage statistics to improve the site. Cookie Policy