xlCompare is an Add-In for Microsoft Excel. It compares 2 Excel workbooks using own smart comparison algorithm, which detects added and deleted data in spreadsheet. Comparison results are shown in the visual user-friendly form, so you can see and merge changed values of both workbooks at one place exactly as they look in Excel worksheet.

xlCompare has set of features which perform complete comparison of the workbooks - worksheets, names and VBA modules are compared.

Main features:

• Compare workbooks\worksheets\ranges
• Compare and merge Names in the workbooks
• Compare and merge VBA projects
• Merge values of compared worksheets
• Quick Merge toolbar to quickly and visually resolve differences.
• Sort data before comparison
• Place merged values on the blank worksheet
• Sizes of compared sheets\ranges are not limited. You can compare ranges, which have different size.
• xlCompare detects added and deleted rows and columns in table
• Differences are shown in user-friendly form (see screenshot below).
• Differences can be exported to separate spreadsheet or text file
• xlCompare functions are available in the VBA macro
• Modify comparison options. More...

xlCompare has set of features to merge values in 2 workbooks. You can move easily move rows or columns from one workbook to other, synchronize values between workbooks. You can find more information about merging workbooks in this topic How to merge workbooks. Also, we suggest you to review topic Quickly move data from one worksheet to another. It describes which features you can use to quickly move data between compared sheets.

We suggest you to review How to ... topic to find answers to the most common questions. Also, in this topic you find some tips on using xlCompare's features.

Also, another important feature Table/Database Comparison. xlCompare has options used to compare data ranges with heading, which identifies column or row. If your data looks like this one:

These options give more accurate comparison results.

Trial version is limited only with 15-days working period. This is a full-featured version which works identically to registered version.

To remove this limit, please purchase a license.