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.
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
Comments
Be the first to comment.