How to compare spreadsheets when rows have moved

Two spreadsheet exports can contain the same records in a different order. Comparing row 2 with row 2 can then report changes that did not happen. Match records by a stable identifier instead.

Choose the right identifier

A product SKU, employee number or transaction ID can work if it appears once per record in both files. A product name is usually a poor choice: names can change, and several records may share the same name. A SKU may also be repeated when a file contains additional rows for images or variants. Check your particular export.

Prepare both tables

Put column headings in the first row. Give each heading a unique name.
Check that the identifier column exists in both files and contains no empty cells.
Make sure each identifier occurs only once. If not, create a unique composite identifier in your spreadsheet first.
Keep formats consistent. The text 001 and 1 are different values.

Worked example: an updated export in a new order

Imagine that Monday’s export has these rows:

SKU,Price,Stock
A-101,35,8
B-202,12,5

Tuesday’s export lists them in a different order and includes a new product:

SKU,Price,Stock
B-202,12,5
C-303,9,2
A-101,39,8

Choose SKU as the unique key. The tool reports A-101 as changed (Price 35 → 39), C-303 as added and B-202 as unchanged. Reordering alone creates no change. If Monday also contained D-404, that ID would be marked removed because it is absent on Tuesday.

Avoid misleading comparisons

Do not use a non-unique column such as Price as the key. Two products can cost the same amount. Check for blank or repeated IDs before comparing. Review values that look numeric but are identifiers: 00101 and 101 are different strings, and importing a CSV through spreadsheet software can remove those leading zeros. You can preserve identifiers as text before running the comparison.

Read the change report

For example, an earlier file contains SKU-101 priced at 35.00 and a newer file contains SKU-101 priced at 39.00. The comparison records a changed price, regardless of where the product appears in either file. An ID appearing only in the newer file is added; an ID appearing only in the earlier file is removed.

The Tech Tycoon comparison tool compares displayed table values. It does not inspect cell colors, formatting or formula logic. If a formula has no saved result in an uploaded workbook, recalculate and save it in Excel first.