Workflow · Clean · Opening soon
Compare two Excel sheets for differences
Compare two Excel sheets and find what changed. Use exported Excel files to show added, removed, and changed rows.
Someone typed
“compare last month's price list to this month's and show added, removed and changed rows”
The agent read it as
Compare Last month's price list to This month's price list and show added, removed and changed rows.
What the agent built
4 steps, each one an ordinary Mammoth step you can open and change.
File
Last month's price list
CSV export · 20 rows
File
This month's price list
CSV export · 20 rows
Step
Make current SKU key
Step 1
Step
Make previous SKU key
Step 2
Join
Bring in current prices
18 of 20 paired
Step
Show price list changes
Step 4
Result
Price list changes
7 rows · 7 flagged
Schedule
Runs when you say
Proposed
- FileLast month's price listCSV export · 20 rows
- FileThis month's price listCSV export · 20 rows
- StepMake previous SKU keyStep 2
- StepMake current SKU keyStep 1
- JoinBring in current prices18 of 20 paired
- StepShow price list changesStep 4
- ResultPrice list changes7 rows · 7 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 7 rows came out, and the join paired 18 of 20 rows.
- Download Last month's price list sample (20 rows)Excel: open the workbook, select the 'Price List' sheet, File > Save As > CSV
- Download This month's price list sample (20 rows)Excel: open the workbook, select the 'Price List' sheet, File > Save As > CSV
What you get back
The result of that run, the rows to look at first.
Price list changesSample data7 rows
3 changed2 added2 removed
| SKU | Status | Previous product name | Current product name | Previous unit price | Current unit price | Price difference |
|---|---|---|---|---|---|---|
| P1021 | Added | · | Umber Desk Mat | · | 15.25 | · |
| P1022 | Added | · | Vista Gel Pen Pack | · | 10.80 | · |
| P1004 | Removed | Delta Water Bottle | · | 14 | · | · |
| P1009 | Removed | Ion Wireless Mouse | · | 27 | · | · |
| P1006 | Changed | Fjord Chair Mat | Fjord Chair Mat | 19.50 | 21 | 1.50 |
| P1012 | Changed | Lumen Desk Clock | Lumen Desk Clock | 21 | 19.50 | -1.50 |
| P1018 | Changed | Ripple Travel Tumbler | Ripple Travel Tumbler | 18.25 | 19 | 0.75 |
How do you compare two Excel sheets for differences?
Export last month’s price list and this month’s price list from Excel, then run the comparison workflow on both files. It matches rows by SKU, then shows added, removed, and changed rows. You can use it to review price list changes before you update your records.
How it works
How to use the Price list changes workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Price list changes: questions
Which export should you use from Excel?
Use an exported spreadsheet file that includes the rows you want to compare. For this workflow, each file should have the same kind of data, such as a price list for last month and this month.
What happens to rows that do not match?
Rows with no match in the other file are shown as added or removed. Rows that match on the key but have different values are shown as changed.
How do you change the comparison rules?
Change the words that define the steps, such as which column is the key and which fields to compare. If your matching rule changes, rerun the workflow with the new instructions.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Remove duplicate rows, catch invoices paid twice, match messy names to a master list, standardise spellings and turn wide tables long.
- Pivot table from raw dataTurn a raw sales export into a pivot table of revenue by region and month.See the workflow Built by the agent
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Remove blank rowsRemove rows that are empty or only contain spaces from an Excel export, while keeping the rest of the sheet unchanged.See the workflow Built by the agent
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent
- Duplicate invoice checkPairs of bills that look paid twice: same supplier, same amount, close dates or the same numberSee the workflow Template