Compare Excel files.
Compare Excel files when two workbooks or CSV exports need a clean difference report.
- Comparison rows
- 19
- CSV columns
- 19
- Products increased
- 19
Start with the file you already have.
Upload or paste the source, then check the workbook before export.
Upload or paste the source. The cleanup rule is loaded.
Sample monthly CSV files to product change report
Two public monthly electronics sales CSV files are compared into a product-level report with old/new units, revenue deltas, price flags, and change status.
Two public monthly sales CSVs become a 19-row product change report.
Two public electronics sales CSV files from January and March 2019 were compared into one product-level change report. The output keeps old_file, new_file, old and new order-row counts, units, revenue, price fields, price_changed, change_status, and review_note while excluding repeated header rows and blank rows.
CSV preview from the January vs March product comparison
These rows come from the January vs March product-level comparison CSV. The output keeps old units, new units, unit deltas, old revenue, new revenue, revenue delta, price change flags, change status, and review notes separate before export.
| product | old_units | new_units | unit_delta | old_revenue | new_revenue | revenue_delta | price_changed |
|---|---|---|---|---|---|---|---|
| Macbook Pro Laptop | 235 | 380 | 145 | 399,500.00 | 646,000.00 | 246,500.00 | no |
| ThinkPad Laptop | 217 | 344 | 127 | 216,997.83 | 343,996.56 | 126,998.73 | no |
| iPhone | 379 | 538 | 159 | 265,300.00 | 376,600.00 | 111,300.00 | no |
| Google Phone | 318 | 463 | 145 | 190,800.00 | 277,800.00 | 87,000.00 | no |
| 34in Ultrawide Monitor | 314 | 524 | 210 | 119,316.86 | 199,114.76 | 79,797.90 | no |
Old file vs new file
The report compares the same public monthly sales dataset at product level instead of doing a noisy cell-by-cell diff.
Unit movement
Each product keeps old and new order-row counts, units, and deltas so movement is visible without scanning raw orders.
Revenue movement
Revenue is calculated from visible quantity and price values, then shown as old, new, and delta fields.
Review flags
Price and status fields make it clear whether a product increased, decreased, stayed unchanged, was added, or was removed.
Raw file comparison
A cell-by-cell comparison of monthly exports creates noise because row counts, row order, repeated headers, and raw transactions change.
- thousands of raw rows
- repeated headers in source files
- hard to see product movement
Reviewable change report
The product-level report removes repeated headers, aggregates units and revenue, and shows old values beside new values.
- one row per product
- old and new values side by side
- revenue_delta and change_status
What an Excel comparison should return.
A useful comparison needs a match key, cleanup rules, and a readable difference report, not two files opened side by side.
Tell the comparison what should be matched
Use product, SKU, order number, invoice number, customer, email, date, or another stable field as the comparison grain between files.
Separate increased, decreased, added, and removed rows
Create rows for increased, decreased, unchanged, added, or removed records, and keep summary counts for the fields that changed.
Show old and new values together
Keep old values and new values side by side so units, revenue, price, quantity, status, customer, or date changes can be reviewed before action.
Use it when two workbooks need a clear difference report.
Excel comparison works when both files have a stable match key and the changed fields can be shown side by side.
Best comparison inputs
- Two related Excel or CSV files with a shared key column.
- Price lists, order exports, invoice lists, inventory files, or customer lists.
- Monthly exports where changed values, totals, or product movement need a review trail.
- Recurring old-vs-new comparisons.
Check comparison results when
- There is no stable way to identify matching rows.
- Headers are unclear and the match logic is not provided.
- Rows are duplicated and need a manual business decision.
- The comparison depends on data that is not in either file.
Start with a comparison layout that shows the change.
For recurring comparisons, save the key columns and changed fields after one correct difference report.
Difference report layout
Use a difference-report layout that shows what changed and why it matters.
Saved comparison workflow
Reuse the same match keys, cleanup rules, and diff columns when the next file pair arrives.
- 01Match rows using stable business keys.
- 02Remove repeated headers and blank rows before comparing.
- 03Split added, removed, increased, decreased, and changed rows into outputs that are easy to check.
- 04Show old and new values side by side.
From two files to old values, new values, and deltas.
Added, removed, changed
Create clear rows or sheets for the records that need attention.
Old vs new values
Put changed fields side by side so reviewers can see exactly what moved.
Reusable comparison rules
Save match keys and diff columns for recurring files.
Choose the next page by how this job repeats.
Start with this converter for one file. Move to templates or workflows when the final layout or repeat process becomes clear.
Merge Excel files
Use this when the task is to combine rows from several files into one source-tracked table.
Merge filesCombine multiple Excel files
Use this when many similar files need to be stacked into one normalized sheet before comparing or analyzing.
Combine filesText to CSV
Use this when the old and new data was pasted from notes, OCR text, or CSV-like text rather than uploaded files.
Convert textMore ways to turn documents into Excel.
If this is not the file on your desk today, start with a nearby workflow and adjust the columns before running it.
Merge Excel files
For combining Excel or CSV files into one workbook, one sheet, or separate tabs.
MergeMerge multiple Excel files into one sheet
For stacking many workbooks into one normalized sheet with source tracking.
MergeCombine multiple Excel files
For combining similar Excel or CSV exports while mapping headers into one schema.
CombineExcel formula generator
For creating formulas, checks, totals, lookups, and workbook calculations from plain English.
GenerateText to CSV converter
For pasted emails, OCR text, supplier notes, lists, and semi-structured business text.
ConvertJSON to Excel
Turn nested JSON, API exports, and pasted JSON text into an Excel workbook. Choose the row grain, fields, and sheets you need before generating the file.
StartQuestions before you upload?
Can I compare two Excel files for differences?+
Yes. Upload both files and describe the columns that identify matching rows. The output can show added, removed, and changed rows.
Can it compare CSV files too?+
Yes. You can compare XLSX and CSV files and export an Excel difference report.
What if the headers are different?+
Describe which fields should match. Messy2Sheet can map similar headers and include notes where the match is uncertain.
Can it compare prices or quantities?+
Yes. Ask for old value, new value, change amount, percent change, and review notes for the columns that matter.
Can I save a comparison workflow?+
Yes. Save the setup after one good comparison and reuse the same match keys and diff columns next time.
Try it on one real file.
Upload the document, keep or edit the template instructions, and check the workbook before you download it.