A revised spreadsheet arrived, but you cannot tell what changed

Built!

Compare two spreadsheets by key column to find edits, additions, deletions, and moved rows. Choose which changes to keep and create a final workbook.

Current workflow

Most people open the old and new versions side by side on screen and compare cell by cell by eye. In a 1,000-row table, spotting the handful of changed cells that way is practically impossible, and if the row order has been shuffled, just lining up the same rows is a job in itself. Excel's conditional formatting or sheet-compare features can help, but finding and learning those features is its own chore. Comparing with formulas like XLOOKUP has a quiet risk: when the key is duplicated, it silently takes the first matching value, so a wrong comparison can pass unnoticed.

Solution

Compare Excel Files

How to use

1. Upload the file from before the edit and the file after it. 2. Choose the key column that pairs up the rows (order number, product code, employee ID — any value that's unique per row). You can also combine two columns as a multi-key. 3. Review the edits, additions, deletions and moved rows, and choose which to keep. Changed cells show the before and after values together. Check the full preview, then download the final workbook and the change list. 4. Rows that need a human look (duplicate or empty keys) are collected separately.

Example

- Input: a 30-row product table (product code, name, unit price, stock quantity) before and after editing - Result: a table showing only 4 changed stock-quantity cells (for example, P-1002 25→30), 2 added rows, and 1 deleted row, with just a count for the 25 unchanged rows — rows are matched by product code even if their order changed.

Open tool
View details
Limits
- Duplicate or empty keys are not auto-matched; they're separated out as "needs review." Clean up the keys in the original files and compare again. - If a column was renamed between the two files (for example, "Qty" → "Order Qty"), it won't be recognized as the same column.
Cost type
Free

Changes that only affect formatting — a cell's color or bold text — with the value untouched won't be caught, because this compares values only. Columns that mix numbers and text can also mislead: 100 and "100" may be read as different values depending on how they're stored, so give the results a second look. And if the keys themselves are messy in both files — the same product code on several rows, or key cells left blank here and there — the keys have to be cleaned up before comparing. This tool doesn't do that cleanup for you.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in