Thank you for downloading xlCompare - the most powerful and accurate Spreadsheet Comparison Application
Download xlCompare 2016
Download Size: 3.5 Mb
File Name: xlCompare.msi
- Download and save setup file.
- Run installation wizard.
- Follow the instructions.
- All versions of Windows, including Windows 7 32-bit, Windows 7 64-bit, Windows 8 32-bit, Windows 8 64-bit, Windows 10 32-bit, Windows 10 64-bit, Windows Server
- All versions of Excel. xlCompare 2016 is completely indepdent from Excel. So, there is no matter which Excel you have on your PC.
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:
- Added\Deleted Code Modules
- Added\Deleted Class Modules
- Added\Deleted Form Objects
- Added\Deleted Controls on the Forms
- Modified control properties on the Forms
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
gives you set of commands to:
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.
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:
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.
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:
Bulk Merge and Undo commands
If you are working with a big datasets:
- Database lists
- Price lists
- Accounting statements
- LOG files
- CSV files
You needs in quick and powerful merge commands which allows to manipulate whole worksheets.
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.
Compare and Merge Visual Basic forms
Only in xlCompare
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:
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:
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:
- Edit cell values \ formulas
- Change tont
- Set text color and background color
- Apply borders
- Apply text formatting: Number, Date, Time, Currency, Accounting, Percentage ...
- Align text in cell
- Merge cells
Save comparison report in the external file
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
Find where result of the formula came from:
Only in xlCompare
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.
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:
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:
- Hidden Rows
- Hidden Columns
- Constant Cells
- Calculated Values
- Text of the Formula
As an addition on the Options tab you can change Formatting Options:
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.
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 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
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.
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.
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
xlCompare 3.3.9 for 64-bit Excel