Compare Supplier Price Lists in Excel Without Missing a Cost Change

Quick answer: compare items, then compare costs

Match the old and new files by supplier SKU, not row position. Pull list price, multiplier, pack quantity, and unit of measure into the same review row. Calculate net cost on the same unit basis, then approve or hold each change. A cell difference alone cannot tell you whether the supplier changed the item or its pack.

If the matching step is uncertain, use the supplier SKU matching guide. For a changed box quantity, work through the pack-size calculation before deciding whether cost rose.

The distributor version of this job

A new supplier file lands in your inbox: a few thousand rows of SKUs, descriptions, list prices and pack sizes. Your catalog already has last quarter's version of the same truth. The job is to find exactly what moved between the two files and decide what your price sheet should do about it.

Three kinds of moves hide in a typical plumbing or HVAC update. A straight price increase, like a copper tube rising from $14.10 to $18.62. A multiplier move, where the list price stays at $9.20 but the discount multiplier shifts from .42 to .46. And a pack change, where a coupling moves from a box of 10 to a box of 25 and the box price tells the opposite story from the unit cost. The examples here use fictional products and prices.

Generic advice assumes two tidy sheets with the same rows in the same order. Supplier files are rarely that polite. Rows get inserted, SKUs get reordered, descriptions get reworded. Every method below lives or dies on how it handles that mess.

If the file is missing a reliable SKU, pack, or unit column, start with the free supplier price list template to see what information the review needs.

Method 1: match SKUs with XLOOKUP

The most common distributor workflow costs nothing and lives entirely in Excel. Load the old catalog and the new supplier list into one workbook, add a helper column, and pull each new price next to its old match with XLOOKUP on the supplier SKU. Filter out the misses, review the rest, and you have a change list. The full careful version, formula included, is walked through in when XLOOKUP is enough and when it is not.

This works well for clean lists with stable identifiers and no pack or unit movement. It breaks in three familiar ways. Pasting values into a filtered view writes into hidden rows that should never have changed, silently overwriting prices for products outside the update. Reworded descriptions and padded SKUs with lost leading zeros never match, so real changes hide inside the #N/A pile. And a price next to a price says nothing about whether the unit basis changed underneath it.

Method 2: free diff tools

Browser-based Excel comparison tools line up two workbooks and highlight every changed cell, added row and deleted row. They are fast, free, and honest about what they do. For two versions of the same tidy workbook, they are often enough.

Basic cell-diff tools often fall short for supplier updates. A row-by-row comparison can flag everything below an inserted item, while a cell comparison does not know whether two rows refer to the same SKU or use the same pack and unit. Check those relationships before treating a highlighted cell as a cost change.

Where both methods break

The expensive mistakes all look innocent in a spreadsheet. A unit of measure flips from each to a box of 10, and a $62.40 line compares itself against a $6.90 line: a 9x phantom increase hiding a per-each decrease. A list price holds steady while its multiplier moves, so a column that only watches list price reports no change at all. None of these announce themselves. Each one needs a reviewer who sees the unit basis before approving.

A reviewed workflow that finishes the job

A finished review has four properties. Every supplier row is matched to your catalog by identifier, with uncertain matches flagged instead of guessed. Every change is normalized to cost per each so pack and unit moves cannot disguise themselves. Every flagged line carries an approve, correct or reject decision from a person. And the export contains only what was approved, in a layout your team can use.

• Match: supplier SKUs resolve against your catalog, and confirmed mappings are saved for the next file.
• Check: price, multiplier, pack and unit changes surface per line with margin context.
• Approve: no line exports without a decision, and any change revokes stale approvals.
• Export: download the reviewed update as CSV or Excel, or send it to Google Sheets.

The fastest way to feel the difference is the free RowTune sample update: four fictional changes including a price increase, a pack change, an uncertain match and a decimal correction, with no account needed. When you are ready, a $19 single-file pass runs one real spreadsheet through the same review. See also how the workflow fits together. Comparing tools rather than methods is covered in RowTune vs Arovon. Before importing approved changes, use the supplier price list import checklist to check dates, exceptions, and the receiving template. If an increase letter prompted the file, use the increase notice review to check its scope against the rows.

Frequently asked questions