Zovo Spreadsheet Compare

Compare two versions of a spreadsheet and get the full list of differences as a file, not just a few examples. Attach the old and the new CSV or Excel file (a product list, inventory export, employee roster, budget, product catalog or CRM export) and Zovo Spreadsheet Compare lists the rows that were added, the rows that were removed, and the rows that changed, cell by cell: the old value, the new value, the change and the percent change for numbers.

Rows are matched by a key column, such as SKU, Employee ID or email. Zovo Spreadsheet Compare finds the key automatically (unique and stable in both files) and tells you why it chose it; you can name your own key, including two columns together such as Store + Product code. When a file has no key, rows are matched by their content. Rows can be in any order.

It handles the things that make spreadsheet comparisons noisy: columns that were moved, renamed, added or removed; extra spaces; numbers written as 1,200.00 in one file and 1200 in the other; European formats such as 1.234,56; dates stored as text in one file and as Excel dates in the other; total and subtotal rows (left out of the comparison and listed); repeated header rows; blank rows; and a renumbered key (one change, not a removal plus an addition). You can ignore columns, ignore upper/lower case, and set a tolerance for rounding.

Downloads: an Excel workbook with a Summary sheet, a Changed sheet with old and new values side by side, a Cell changes sheet with one row per changed cell, Added and Removed sheets, and the new version annotated with each row's status, plus a CSV of all changes. A second tool summarizes the changes by column: how many values went up or down, the total and average change, and the largest increases and decreases.

Limitations: CSV, TSV and Excel .xlsx files (save older .xls files as .xlsx); one sheet per file per comparison; up to 50,000 rows per file. Formulas are compared by their saved values. Files are read once, and downloads expire after about an hour.