What Compare Excel Files helps you do

Comparing two workbook versions by eye misses small changes. This tool reads one worksheet from each file, matches rows by a key column, and lists added, removed, and changed cells with before and after values. It is built for pricing, inventory and migration reviews where a single changed cell can matter.

Both workbooks are read and compared in your browser. Nothing is uploaded to Haivix.

How it works

Each workbook is parsed and the chosen worksheet is converted into headers and rows. Columns are matched by header name, so their order does not matter. Key mode indexes each row by the selected key and matches across files; row-order mode pairs rows by position. Changed cells are recorded with their original and new values.

How to use Compare Excel Files

Drop the before and after workbooks and choose a worksheet from each.
Pick the key column and whether to ignore case or trim whitespace.
Compare the sheets, review the difference table, and download a CSV report.
If the key is duplicated or empty, clean the source sheet and run it again.

When to use it

Review what changed between two versions of a pricing or inventory workbook.
Check a vendor update before replacing an existing sheet.
Confirm that a migration produced the expected rows and values.
Compare a filtered workbook against the full source.
Check that a manual edit changed only the intended cells.
Review a translated sheet against the original values.

When not to use it

Do not compare different worksheets and expect a meaningful diff.
Do not use key mode when the key is not unique and non-empty.
Do not expect formatting, charts or comments to be compared.
Do not compare sheets with different header names and expect the columns to line up.

Example

A 4,000-row stock workbook is compared with last week's version by SKU. The report shows 12 changed quantities, 3 removed lines and 2 new lines. The warehouse team filters the changed cells, confirms the counts, and archives the old workbook.

What you can do with Compare Excel Files

Compare one worksheet from two workbooks.
Match rows by a key column or by row order.
Ignore case and trim whitespace for the comparison.
List added, removed and changed rows.
Show before and after values for each changed cell.
Download the differences as a CSV report.

Example: review a price workbook

Load the old and new workbooks and choose the same worksheet name from each. A differently named sheet is a common reason the comparison looks empty.

Pick the SKU column as the key and trim whitespace so a stray space does not look like a price change.

Review the changed cells in the table, then download the CSV report and approve the changes before replacing the old file.

What to know before you start

One worksheet from each workbook is compared at a time.
Key mode requires a unique, non-empty key column; row-order mode compares rows by position.
Formulas are compared as cached values; formatting and charts are ignored.
Merged cells are read as their top-left value.
The comparison is limited by browser memory and the workbook size cap.

Common mistakes

Choosing worksheets with different names or layouts.
Using a key column with duplicate SKUs.
Ignoring trailing spaces and reading every row as changed.
Comparing row order after sorting one workbook and not the other.
Assuming a formula change is reported; only cached values are compared.
Comparing two workbooks with different column schemas and expecting a clean diff.

Troubleshooting

If the comparison is empty, check that both files contain the chosen worksheet and that the key column is present in both.

If nearly every row changed, check whitespace, case and date formats before trusting the report.

If a column is missing, compare the header rows; a renamed column is treated as a different column.

If the workbook will not load, it may be encrypted, damaged or beyond the file-size cap.

If the report is too large to read, filter the changed rows in a spreadsheet by the change type.

If the workbook has hidden or filtered rows, the comparison still reads them. Unhide or clear the filter when the review should cover only the visible data, and state that scope in the report so nobody assumes otherwise.

If the two workbooks use different date or number formats, normalize them first; a cell can differ as text even when the underlying date is the same. Check a few flagged cells manually before circulating the report.

Compare Excel Files