Boost your productivity with xlCompare

Perform various operations with data on your worksheets in a seconds. xlCompare has a number of functions from Comparing, Merging and Updating records to Debuging Calculations in your workbook.

xlCompare - Extended View

Why xlCompare?

Set of unique functions, present in our product, makes it most feature-rich Excel Workbook Comparison software.

Look into the History of Changes and Features List. Every day our engineers work on the progam code, add new features and make the software more faster and reliable!

xlCompare is able to solve all spreadsheet comparison tasks you encouter on the daily basis. Every user of Microsoft Excel will find useful functions in our product.

xlCompare - Compare Cash Flows

Compare, Update and Merge Databases

Merging of 2 tables never was so easy and quick!

Find added and deleted rows and columns, find updated cells. Filter and highlight duplicate and redundant records. Our product has very long list of the commands you can use.

xlCompare - Compare Databases

Compare and Merge Formulas

If you are working on the complex Financial Model, or workbook with large number of calculations - xlCompare is an ideal solution for you. Find what was changed between versions of your software and research calculations and errors.

xlCompare - Compare Formulas

Compare and Merge Visual Basic Projects

If you are VBA developer, you will be surprised, that xlCompare processes not only Code Modules, but Forms and Controls also.

xlCompare - Compare Visual Basic Code

Resolve conflists in One Click!

All Merge Commands are intuitive and easy to use. Update rows one-by-one in the manual mode or using Bulk Commands. For all common operations, xlCompare has one click commands.

xlCompare - Bulk Merge Command

Version Control for your Spreadsheets

Integrate xlCompare into version control software by using Command Line mode. Use it to view and resolve conflicts between versions of your workbooks.

xlCompare - Analyze Comparison Results

Manage xlCompare by VBA macros

Write Visual Basic macro to prepare your data for comparison or to manage xlCompare and automate your daily tasks.

xlCompare - Run Visual Basic Macros

There is nothing impossible for xlCompare!

xlCompare is powered by our own Spreadsheet Core engine. We can implement ANY feature, which is not present or not possible in Excel. For example, discover the history of any value using Formula Evaluation Tool:

Evaluate Formula

Database Management commands

Filter values on the worksheet

Database Filter
  • Filter by Key - leave only records with this value of primary key and hide all other ones.
  • Filter by Value - filter selected column for the selected value.
  • Filter Errors - leave only rows with error values, like #N\A, #DIV0, #NAME, etc.

Find and remove Duplicates

Database Duplicates
  • Filter Duplicate Keys - Display only rows with duplicate Primary Keys.
  • Hide Duplicated Keys - Hide all rows with duplicated keys (records are not deleted).
  • Filter Duplicate Rows - Leave only duplicate lines.
  • Hide Duplicate Rows - Hide duplicate lines and leave unique ones.

Manage Filtered Records

Database Hidden Rows
  • Cancel Filter - display all hidden rows.
  • Hide by Keys - hide all rows with selected primary key.
  • Hide\Unhide Rows - hide or unhide rows manually on this worksheet.
  • Invert Rows - invert "hidden" property for every row.

Sort Records

Database Sort Records
  • Sort records on the worksheet.
  • Manage Primary Keys in all opened workbooks.

Compare Files from Command Line

Run Visual Basic script from the command line.

This powerful feature allows to perform any action in the command line mode, that could be programmed. It is suitable for complex cases, for example: when you need to compare several files at one run. Only a small set of the possible actions is described below:
  • Load and analyse worksheet data
  • Preprocess worksheet data before comparison (for example combine several values into one cell)
  • Modify cells, Recalculate your workbook
  • Compare worksheets
  • Get Comparison Report
  • Analyse Report or save it on disk, send by e-mail, etc.
  • Produce single Comparison Report for folder or set of folders

Usual command line mode.

Pass your workbooks to xlCompare and get results in the form of worksheet or text file. This is quick and easy way is good for version control utilities. For example, for intergration with SVN.

Version: 8.4.0
Size: 5.5 Mb
Published: May 04, 2020