Excel comparison guide

Compare two Excel files without reviewing every cell by hand.

Choose an earlier workbook and a newer workbook. WorkbookLens identifies the values, formula text, sheets, and table records that changed, while the workbook data stays on your device.

Compare two files now See an example

The result, not the noise

See the evidence in reviewable form.

A useful Excel comparison should answer four questions: where the change happened, what was there before, what is there now, and what kind of change it is. WorkbookLens presents those answers directly and can save the result as a self-contained HTML report.

For tables with stable identifiers, keyed comparison can match the same product, order, or account even after rows are sorted or inserted. That prevents harmless row movement from hiding the changes that deserve attention.

Example comparisonbudget-review.html

3meaningful changes found

LocationEarlierNewerResult

Products!D12€42.00€45.00Value changed

Forecast!F8=SUM(F2:F7)=SUM(F2:F8)Formula changed

Products · SKU-118—New recordRow added

Three steps

A direct path from two versions to one answer.

Select the versions

Use the earlier workbook as the baseline and the revised workbook as the comparison. The browser reads both locally.

Choose how rows match

Compare ordinary sheets by cell position, or enter a key such as Orders:A for an ID-based table.

Review and retain

Inspect the differences in the page, then download HTML for people or JSON for another system.

Common questions

What a workbook comparison means in practice.

Does choosing an Excel file upload it?

No. The browser grants this page temporary access to the files you select and performs the comparison in a local worker. Workbook names, paths, values, formulas, and reports are not sent to the server.

Can it compare formulas as well as values?

Yes. WorkbookLens can report stored formula text separately from stored or displayed values, which helps distinguish a changed calculation from a changed input.

Can I automate the same check?

Yes. The downloadable CLI accepts workbook and report paths, works without a browser, and returns predictable exit codes for scripts and build pipelines.