The tool finds differences between old and new versions of a spreadsheet. The result is a colorful XLSX report where rows are highlighted in different colors: added, removed, and those where values in individual cells have changed. The comparison is performed based on a unique key column that you specify.
When this is useful
A purchasing manager received an updated price list from a supplier and wants to instantly see which items disappeared and which appeared for the first time. In another scenario, an IT specialist compares two versions of a customer database export to track all contact information changes over the past week.
Step-by-step instructions
- Upload the file with old data to the left field and the file with new data to the right field.
- From the dropdown list, select the column that serves as the unique row identifier, such as SKU or ID.
- Start the comparison process and, when ready, download the colorful report in XLSX format.
How to verify the result
Open the received report and pay attention to the legend at the top of the sheet explaining the color codes. Make sure that rows with changed data are highlighted, not just marked as deleted and re-added. Verify that the number of unique keys in the report matches expectations.
Important limitations
The key column must contain only unique values within each file, otherwise the comparison will abort with an error. Hidden columns and formatting are not analyzed; only the textual content of visible cells is compared. The tool does not show which specific value was changed inside a single cell, but only records the fact of the change.