Download Excel Compare

On this page you can download FREE full-featured version of xlCompare

Thank you for downloading xlCompare - the most powerful and accurate Spreadsheet Comparison Application

Download xlCompare 2016

Version: 5.2

Download Size: 3.5 Mb

File Name: xlCompare.msi

Installation instructions:

  • Download and save setup file.
  • Run installation wizard.
  • Follow the instructions.

xlCompare Requirements:

So, there are no special requirement for this software.

Setup package published above is suitable for all versions of Windows and Excel.

Compare Excel Workbooks

xlCompare is an ultimate tool for excel spreadsheet comparison. Only with xlCompare you can quickly compare large amount of data and get accurate comparison results. It processes cell values, formulas, array formulas, defined names, cell formatting options, ... You are getting comprehensive color-coded comparison report for your data.

Compare Visual Basic Projects

Compare VBA Projects is a realy complex task. This is not a usual text file comparison. xlCompare gives you a powerful tool which can do all you need for Visual Basic code comparison and merging. This tool is a must-have utility for a VBA developers and programmers who work in the team environment.

xlCompare is the most complete comparison utility for Visual Basic Projects

xlCompare processed not only Code Modules in the VB Project, but the Form objects also. It detects:

You can not only detect the differences, but merge all of them also. If you're co-worker has added new module into his development version, you can merge it into main codebase in single click!

10+ Time Saving functions

xlCompare gives you set of commands to:

Difference Map

Only in xlCompare

xlCompare reflects all differences found on the sheet/module to the scrollbars (vertical and horizontal). This feature greately simplifies navigation. Colormark on the scrollbar points you to the part of worksheet(module) with difference.

xlCompare:Scrollbars with Difference Map

Reflect count of differences on the sheet tab and ribbon

Only in xlCompare

xlCompare divides workbook to the views - Sheets, Names, VBA Objects, Modules, Forms. Number of differences found when you compare 2 workbooks is added to the ribbon button and to the name of the sheet (module) on the tab:

xlCompare:Count of differences in the vba modules

Also, button on the ribbon is highlighted with bold font and overlay image.

Extended View mode

Only in xlCompare

This feature displays updated cell values on the worksheet. This is the most native representation of the changes.

xlCompare:Extended View

Display Difference option gives you ability to see updated value and difference. Sometimes updated value is not so important as difference between values. This option displays the information you need on the worksheet. Just browse worksheet and see the differences.

This feature is possible only in the xlCompare. It is not possible in the software based on the Excel application.

Highlight only results you need

Only in xlCompare

xlCompare gives you ability to filter the data you see or to extract it from workbook by removing rest of the records.

Just a single click and you have only records you need on the screen:

Filtered Records

Highlight results you need and ignore rest of the records

Bulk Merge and Undo commands

If you are working with a big datasets: You needs in quick and powerful merge commands which allows to manipulate whole worksheets.
xlCompare gives you Bulk Merge Operations - you can resolve all conflicts found by comparison in single click. This greately increases your productivity if you are working with large amount of data.

Bulk merge command

Compare and Merge Visual Basic forms

Only in xlCompare

Vba Form Differences

xlCompare gives you powerful feature - compare and merge VB Forms in a visual, native form. Just in a few clicks you get all changes made for a specific form.

xlCompare has Visual Basic Form editor. It displays all controls on the Form including hidden ones:

Vba Form Editor

This gives ability to display contents of the Form in it's native way. You see form exactly as it looks in Excel application. All form controls are combined into hierarchcal tree structure - you can see it in the top-left pane of the editor. Properties of the selected control (Name, Font, Colors, Tab Index, Size and Position, ...) are below tree conrol in the list.

Edit your workbooks directly in the xlCompare application:

Formatting options

You don't need to open your workbook in Excel if you need to make a quick change to any formula or format specific cell.

xlCompare has all spreadsheet editing features you need:

Formatting options

Save comparison report in the external file

xlCompare allows you to save comparison report on disk in the HTML or Text formats. You can use this report for future use. HTML format allows to use all power of the HTML language to create presentation for compared data. More information on this feature you find in Save comparison report on disk topic.

Find where result of the formula came from:

Only in xlCompare

Evaluate Formula

Evaluate Formula command allows you to go in-depth in the formula calculation. Just can expand any part of the formula and trace it until you reach input values (constant cells). With this feature you can quickly find why your formula produces unexpected results. This feature is much more useful than usual Trace Precedents command in Excel.

Note: Red arrow icon on this screenshot means return value of the OFFSET function. You can not only see what was returned by OFFSET, but also immediately trace this value.

OFFSET, INDIRECT and some other functions returns reference which depends on its arguments. They create so called indirect dependencies. Logic of your spreadsheet became unclear and complex. You can debug it by looking into formulas. In this case you need a power tools like xlCompare or Dependency Auditor.

Filter data you want to compare:

Ribbon: Filter Tab

On the Filter tab you can select which data is included into comparison. This option allows you to define comparison strategy which is most suitable for the data you have:

As an addition on the Options tab you can change Formatting Options:

Ribbon: Options Tab

Exclude ERROR values:

Ignore cells which contain ERROR value. You can use this feature to make results more clear and to reduce noise you are getting.

Hide Equal Worksheets\Modules:

You can hide sheets\modules which are identical to focus on the changes only.

Version control features

Every part of the Cell Formatting can be included or excluded from the comparison.

Command Line mode makes xlCompare powerful tool for version control. Not all Excel Comparison applications are suitable for version conrol. You can integrate xlCompare into modern version control \ source control applications as an external file viewer. You will be able to compare and merge Excel workbooks and add-ins in the XLS \ XLA \ XLSX \ XLSM \ XLAM file formats.

The setup package, you can download above, is completely free. When you install it on your PC it starts working as evaluation version.

Evaluation version of the xlCompare is limited only by working period and functionality. You can use it for free 30 days. Also, you can compare only first 100 rows and can't save workbooks in the Trial Mode. If you need to use Excel Compare Tool after this period - you should purchase a license. More information about pricing and ordering options you can find on the Order Now page.

If you have already activated your Excel Compare and want to upgrade it to the newer version, you also should install this setup. Newer version of Excel Compare uses registration information from your previous version. You should not re-register the software.

To remove limitation you must activate the software. Instructions, on how to pay registration fee and activate the xlCompare are available on the Buy Online page.

Visit History of Changes page to find detailed information about each update. We publish updates very recently, so we suggest you to visit our website from time to time and download updated versions of the xlCompare.

We hope that you will enjoy our Excel Comparison Software. If you have any questions, please contact us on the Contact Spreadsheet Tools Page.

xlCompare - Comparison Results

Why xlCompare has a number of unique featured you can't find in other software?

xlCompare is based on the own Spreadsheet Engine we can offer you features which are not present in the software based on the Microsoft Excel Application.

Download Excel Compare 2016 - xlCompare.msi

If you would like to use xlCompare commands directly from Excel application, please use previous version implemented as COM Add-in for Excel:

xlCompare 3.3.9 for 32-bit Excel

Download

xlCompare 3.3.9 for 64-bit Excel

Download