Workbook Compare by HigherData

HigherData

Workbook Compare 2.0 by HigherData

New release!

The most flexible Excel workbook data comparison tool available

An indespensible tool for Excel users and developers

Workbook Compare compares data between Excel workbooks and reports differences in a detailed Excel report. The tool automatically map worksheets and columns, or you may override them for incredible flexibility. Control your comparison at a granular level including a variety of options.

Workbook and worksheet setup

Try the tool by downloading the 15 day trial version:
Download Workbook Compare 2.0
Compatible with Excel 2000, 2002, 2003, 2007 for Windows.

To purchase a license and get a license key emailed to you immediately:
Purchase Workbook Compare 2.0 license
The license key unlocks the trial version, giving you permanent access to the tool.

Workbook Compare lets you:

Compare spreadsheet changes to the prior version and validate that the only differences are those you expect.
Compare a worksheet to any other. Compare a column to any other.
Compare the entire workbook or selected worksheets. Compare all or selected columns. Compare the same or different workbooks.
Compare formulas or values. Or ignore formulas to see data changes only.
Ignore rounding differences.
Create Unique Keys and treat worksheets like database tables.
Save projects for future comparisons.
Highlight differences to make them easier to spot, with ability to undo.
Focus on your spreadsheet improvements and development, not on the hassles of testing.

Workbook Compare:

Saves you time and gives you confidence over the quality of your work.
Is easy to use.
Automatically maps "out of order" columns and finds the start of data tables.
Supports case-sensitive text comparison.
Produces an Excel report of differences. Sort and analyze the report easily.
Displays all differences or just a few.
Includes Table Compare for quick table comparisons.
Lets you compare worksheets within the same workbook or even if worksheets have different names.

Screenshots:

The menu

Workbook and worksheet setup

Column mapping

Options

The difference report - several report layouts are available

Optional feature: Highlight differences to make them easy to spot in your workbooks (with ability to undo)

Projects

Table Compare - A "tool within a tool" for table comparisons

FAQ

Does the order of columns matter?

No, they are automatically mapped as long as the header values are the same and "Auto-map columns of matching headers" is enabled.

How do I compare worksheets with different names?

In the main setup dialog select any sheet from the dropdown. By default, the setup process automatically maps worksheets of similar names. However these are overrideable.

What if my worksheets are sorted differently?

Columns can be set as unique keys, treating the worksheets like database tables.

How do I compare worksheets in the same workbook?

Select the same workbook in both dropdowns of the setup and map whatever worksheets you want to compare.

Is my data modified in any way?

No. Workbook Compare does not modify your data or workbook structure ever. It does not insert columns or rows, does not sort, etc. Workbook Compare has an extremely light footprint. However, the tool does offer you an ability to highlight differences (with undo ability) to make them easy to spot in your workbooks.