Use xlCompare to compare and merge Excel worksheets and Visual Basic Forms and Modules.
xlCompare will boost your productivity to the highest level.
Stop spending your time for a routine jobs and put your focus to the primary tasks.
There are dozens of useful features and advantages Excel Compare Tool offers. Armed with them you will quickly do all spreadsheet comparison and merging tasks you experience on the daily basis!
Look how xlCompare works on the real examples. The page below contains examples of the most common tasks solved with Excel Compare Utility.
Compare two Price Lists for differences and highlight changes. Format changed cells with color.
Merge several Excel worksheets into one. Combine lists with auto parts stored in the Excel worksheets into single sheet with xlCompare.
Create outlined Difference Report for modified Excel Workbook and save it as Excel File. E-mail this file colleague.
What our customers say about xlCompare?
Primary goal of xlCompare - comparison and merge operations. Find out what we can do for you.
Still looking for differences manually?
xlCompare saves you a lot of time. In a few seconds you are getting complete comparison report with a minimum efforts.
xlCompare detects every modification on the worksheet - changed cell value or formula, inserted row or column. All modifications are reported it in the color coded form on the worksheet.
Review all differences in one place - Difference Explorer window. Do not review all sheets, searching for changes - just go to this window to browse list of modifications.
If you've got data in a form of several Excel worksheets, which should be combined into single sheet - xlCompare will do this work in a seconds and few clicks only. Let it work for you!
Process large Excel tables within a seconds with a maximum accuracy. Excel Compare has database comparison algorithms, which performs this task quickly and efficiently.
Complete comparison of the Visual Basic Projects. Compare changes in the Code Modules and Form Controls. A must have tool for VBA developers!
2 and 3-Way Comparison options with set of command line options allows to integrate xlCompare into Source Control System as Diff Viewer and Merge Tool.
When working in the multi-user environment conflicted changes are often happen. Few seconds and you resolve them with xlCompare.
xlCompare is not only workbook comparator. This tool has features which makes you more productive in various aspects.
How xlCompare works
Pick the version suitable for your Windows. A free trial is available to help you with the decision-making.
Current Version: 9.3.11
Build Date: 4/27/2021
During 10+ years our team is working to provide you a robust and quality software. It boosts your productivity and saves you time and money. Just look into our list of changes on the page below to imagine amount of work done on the product.
64-bit and 32-bit versions are supported
xlCompare is based on the Spreadsheet Core engine.
It doesn't require Microsoft Excel to be installed.
If you have any questions regarding xlCompare, please contact us and we will give you a prompt response.
This is an important feature, which displays cell value(formula) and corresponding value in same cell. With this option turned ON (default selection) you should not search for the corresponding value on the other panel. It greatly saves your time and increase usability of the Comparison Report.
Option Display Difference activates feature you need in the Extended View mode. With this option enabled, you see difference between value in MINE cell and value in the THEIR cell. Colored Arrow mark indicates increase or decrease in the value.
Yes, sure. You can export this report into PDF format for future use. For example, you can print it or send to your co-worker.
Yes. xlCompare finds differences in the text of formula and text of array formula. However, if you don't need to compare formulas, you can exclude this in the options. xlCompare gives you rich set of options to control what you are searching for. You can compare:
All differences are listed in the Difference Explorer report. When you select difference in this list - xlCompare activate it in the Worksheet\VBA Panel.
All unique rows and changed cells are marked with color - background, text color and border. Formatting in the equal cells is not changed.
Yes.xlCompare has an option to exclude hidden rows and columns from comparison. If your worksheet has data, you want to exclude, - hide it and run the comparison. This is one of the methods to reduce comparison noise.
There are two options. You can print Comparison Report exactly as it looks with all formatting into the PDF format. Use Export button, with PDF icon, in the Difference Explorer.
It opens Print Preview window, where you can preview your report, change printing options – put all columns on one page, align printout, etc. and save it on disk.
This report perfectly presents all differences, found between Excel Worksheets.
Other option – Summary Report button in the Difference Explorer.
This command generates outlined report, which contains all items you have in the Difference Explorer. It doesn’t display modifications in-place, like a previous PDF report, but it gives you a complete summary of the comparison done.
Choose one of the following formats to save this report:
Or just copy it to clipboard and paste into e-mail or other application.