Compare and Merge Excel Sheets and Visual Basic Projects

Our primary goal is to provide fast and robust comparison and merge services for Excel workbooks

Get your job done in seconds accurately and effectively

Bring your productivity to the highest level

Companies that trust our software
Volkswagen Logo
Siemens Logo
Zurich Insurance Logo
Xerox Logo
Oracle Logo
Electronic Arts Logo

Boost your productivity with xlCompare!

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.

Sales Statistics
Quality
Our purpose - give you fast and robust Excel comparison software. Our Excel Diff Tool was tested on the millons of Excel workbooks around the world.
Power
Based on the Spreadsheet Core engine our tool works faster then Excel application and gives ability to implement any feature, which it not possible in Excel-based solution.
Efficiency
xlCompare saves you time and money. Put your focus on the business tasks, while we are doing routine job.

We've got thousands satisfied customers

... fundamental tool ...

Summary: As a professional Excel/VBA developer, XLCompare has become a fundamental tool in my development process. It works on even the most code-heavy and complex of workbooks, and is something I just couldn't do without.
Peter Hamilton
... The only tool I've found ...

Summary: XLCompare has been able to handle our files very well. XLCompare was the only tool I have found able to handle these files at all. And with your company's very fast responses and fixes to the problems that I have identified along the way, we have been very happy with XLCompare and it capabilities.
Robert B.
The best excel comparison software!

Proc: Very useful tool for database data comparison. Perfect visual representation of the comparison report.
Cons: Export difference report to more formats.
Summary: I need to compare database reports from my co-workers every day and this tool saves a lot of my time. It compares 2 large workbooks in several seconds. Comparison report is perfect. Data can be easily merged and saved directly in the report. Very useful tool.
Ralph Langley
Great product!

Proc: We use Excel extensively for our financial models, and this product greatly speeds up our productivity! Large workbooks are easily compared and merged. Drag-n-drop feature for merging workbooks is fantastic. I suggest it to everyone.
Cons: I like all features in this product.
Summary: We are going to have more people in the development on our Excel model, so merging is very helpful. xlCompare seems to be the best option, only it could handle our model files.
John Robert

Visual Representation of the Comparison Results

All changed cells, unique rows and columns are marked with color. This highlighting points you to the changes found in workbook.

Worksheet
Changed Cells
Display original and modified value (or difference) in the same cell. Perfect visual representation of the modified cell values.
Unique Rows
Every unique row or column is detected by xlCompare and marked with color. Click on the Merge Icon and row will be inserted into the corresponding table.
Detailed Information
Tooltip window on the changed cell shows detailed information about modification.

Comprehensive Comparison Summary

Browse list of changes, grouped by worksheets in the Difference Explorer Window. Merge and filter Excel tables using xlCompare commands.

Difference Explorer
Complete list of Differences
Difference Explorer gives you native and easy way to browse all differences found between workbooks.
Filter Changed Cells
Keep on screen only records you need - unique, changed or equal
Merge and Bulk Merge
Merge cells one-by-one or merge all changes in one click.

Native Alignment for Unique Records

xlCompare delivers comparison results in aligned form, where compared cells are put on the same places on the both sheets.

Align Rows
Virtualy Aligned Rows
Added and Deleted Rows(Columns) are virtually inserted into another workbook to make native representation of the comparison results. Every pair of the corresponding rows are on the same places.
Merge Unique Rows
With aligned rows you see where merged unique rows will be inserted. Select range of the rows you want to insert and move them in one click on the plus icon.
Synchronous Selection
When you select range in the left worksheet, corresponding range is selected on the right side.

Compare Excel Tables

Database data is compared by Primary Key. xlCompare gives you a handy way to define Primary Keys and select algorithms used for comparison.

Compare Database Tables
Different Algorithms
Depending on the data you have in the worksheet xlCompare offers you algorithm you can use. You can change it in the Comparison Wizard and try all strategies.
Select Worksheets
Select Pairs of the worksheet you want to compare. Process only the data you need.
Select VB Forms and Modules
If you are working with VB Project in the your workbook - exclude worksheets, if you need to focus on the modifications in the VBA Code.

Database Processing Commands

Set of commands to filter, highlight and remove duplicated records.

Compare Databases
Remove Duplicates
xlCompare has set of Database Processing commands. Removing duplicate records is one of them.
Highlight Duplicates
Highlight duplicate rows on the worksheet with colors.
Remove Hidden Data
Hide the data you don't need on the worksheet and remove it with single click.

Compare Visual Basic Code and Forms

Complete comparison of the Visual Basic Projects. All options and commands needed for VBA developers.

Compare VBA Projects
Modified Code
xlCompare finds changes in the VBA Modules and displays them with color formatting.
Changed Form Controls
If you've modified form control - it will be detected and displayed by xlCompare.
Merge Commands
Merge VBA Code and Form Controls in single click. Just select code lines and click on the check icon!

Data Processing Utilities and Tools

Very often you need to pre-process your data before comparison. Convert text string imported from text file into numbers, etc. With xlCompare you will make this in a seconds.

Right Click Menu
Convert Text To Numbers
Convert numbers stored as text to numerical data. Numbers stored "as numbers" are more accurately compared and processed.
Trim Strings
String data is often comes with extra spaces. Remove it to have clear data.
Mark Column as Primary Key
Easy to use Primary Key management commands. Select Column and mark it as key in single click using Right Click Menu command.
Sort Worksheet Rows
Sort rows on your worksheet. Sometimes for perfect visual representation of the comparison results, you need to sort rows before they will be processed.

Analyze and Debug Calculations in Depth

xlCompare is not only workbook comparator. This tool has features which makes you more productive in various aspects.

Trace Dependents
Trace Calculations
Drill-down trace of the formula calculations.
Evaluate Formulas
Divide formula into elementary parts and display them in the hierarchical tree form - the most sutable way for recursive analyzys.
Where the Value Came From
Review list of errors and find our where the error came from.