Compare two Excel sheets and list what changed
Every new, removed and repriced item in one workbook, with old and new prices.
A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 2 min 49 s in real time.
The short answer.
Match the rows by an ID column, not by position: if the supplier re-sorted the list, a row-by-row compare flags almost everything. In Excel, add an XLOOKUP that fetches each item's old price by its code, then filter for missing and changed values, and repeat the other way round to catch removed items. Stella (stella.sh) compares both files by item code and builds a new spreadsheet of what changed.
Stella does this on Windows, Mac and Linux.
What happened.
All 19 differences found in about 2 minutes 50 seconds: 9 price changes, 4 new items, 3 removed, two changed descriptions and one changed pack size. Checked afterwards against an answer key written before the run: nothing missed, no unchanged item listed as changed, the old and new price on every price-change row, and both price lists unchanged.
The two price lists (240 items each) are fictitious, made for this run, and the October one was re-sorted on purpose. The work is sped up 10×.
How Stella does it.
- Finds both price lists in Downloads and matches items by their SKU code, so the October list being re-sorted by description doesn't matter
- Builds a new workbook that opens on a Summary tab, with separate tabs for price changes, new items, removed items and other changes
- Shows the March price, October price, change in pounds and change in percent on every repriced row
- Picks out what's worth asking the supplier about: a pack size that doubled at the same price, and two new items with the same name at different prices
- Treats renamed items that kept their code as the same product, and says so
The prompt.
Our supplier sent a new price list. Compare it with the March one (both are in Downloads) and make me a spreadsheet of what changed: new items, removed items and price changes.
This is the exact prompt from the recording. If your files are somewhere else, say where.
Do it yourself.
Put both lists in one workbook
Open both files and copy the old list into the new workbook as a second sheet (right-click its tab, Move or Copy, tick Create a copy). Name the sheets March and October so the formulas below read clearly.
Look up each item's old price
On the October sheet, in a new column E, enter
=XLOOKUP(A2, March!A:A, March!D:D, "new"), where column A holds the item code and D the price, and fill it down. Items that weren't in March show “new”. In column F,=IF(E2="new", "new", IF(D2<>E2, "changed", ""))labels each row.Do it the other way round for removed items
On the March sheet, the same XLOOKUP pointed at October's codes returns your fallback text, say “removed”, for anything dropped from the new list. Filter both sheets on these columns and copy the results to a new sheet.
Or use Spreadsheet Compare (Windows)
With Microsoft 365 Apps for enterprise or Office Professional Plus, open Spreadsheet Compare from the Start menu and choose Compare Files. It compares cell by cell, so sort both files by item code first or every row after the first difference shows as changed.
Highlight instead of list
To see differences in place, select the October prices, choose Conditional Formatting, New Rule, Use a formula, and enter
=D2<>XLOOKUP(A2, March!A:A, March!D:D, D2)with a fill colour. It only works when both sheets share an ID column.
Where it stops.
- Stella matched on the SKU column. If your files have no unique ID, it has to match on names or several columns together; ask it to say which columns it used.
- It compared values, not formatting, formulas or comments. Ask separately if a colour or a formula change matters to you.
- Recorded on Linux with no Excel installed. The result is an ordinary .xlsx with several tabs, which opens in Excel, Numbers or Google Sheets.
- The rows of both lists go to the AI model you use in Stella while it compares them. For commercially sensitive price lists, choose your model accordingly.
Questions.
Why does comparing two sheets show everything as different?
The rows aren't in the same order, so row 5 in one file is a different item from row 5 in the other. Compare by an ID column with XLOOKUP, or sort both by that ID first.
Is there a built-in way to compare two Excel files?
Spreadsheet Compare comes only with Microsoft 365 Apps for enterprise and Office Professional Plus on Windows. Home and Business plans and Excel for Mac don't include it, so the XLOOKUP route is the usual one.
Does XLOOKUP work in my version of Excel?
It's in Microsoft 365 and Excel 2021 or later on Windows and Mac, and in Google Sheets. In older Excel use =VLOOKUP(A2, March!A:D, 4, FALSE), which shows #N/A for new items.
Can it combine the files instead?
To stack many files into one sheet, see combine Excel files into one sheet. To turn each row into a letter, see mail merge from Excel to Word.
Is Stella free for this?
Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.
Can I control what Stella changes on my computer?
Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.
- Microsoft: Compare two versions of a workbook by using Spreadsheet Compare
- Microsoft: XLOOKUP function
- Exceldemy: Compare two Excel sheets and highlight differences
Checked against these sources on 13 November 2026.