xlCompare - Diff and Merge Tool for Excel Workbooks

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.

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

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

Why Use xlCompare?

Primary goal of xlCompare - comparison and merge operations. Find out what we can do for you.

Compare Database Tables
Color-Coded Diff Report
Perfect visual representation of the comparison results. Represent differences in the native way.
Changed Cells
Find all changes and display original and modified value in one place.
Unique Rows and Columns
xlCompare finds and displays unique rows and columns in the compared worksheets.

Still looking for differences manually?

Boost your productivity with xlCompare!

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.

Detailed Diff Report and Merge Commands

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.

Detailed Information
Tooltip window on the changed cell shows detailed information about modification.
Extended View
Display original and modified value (or difference) in the same cell.
Merge Icons
Select range of cells you need and merge it into other worksheet in a single click.
Worksheet

Comprehensive Comparison Summary

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.

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.

Combine Several Worksheets into One

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!

Merge Worksheets
Merge Tables
Merge cells between several worksheets in a single click.
Merge Selection
Merge cells in a manual mode - select what you want to copy to another worksheet.
Utilities for Data Processing
Convert Text To Numbers, Trim Strings, etc. xlCompare has a number of useful commands you can use before merging Excel tables.

Compare and Update Tables

Process large Excel tables within a seconds with a maximum accuracy. Excel Compare has database comparison algorithms, which performs this task quickly and efficiently.

Compare Database Tables
Inserted Rows\Columns
xlCompare detects new records and highlights them with color. Just look into color marks on the scroll bars to locate new data in your table.
Check for Duplicates
Keep your database up to date. Find and remove duplicates and redundant records.
Compare "Mixed" Data
Rich set of options gives you a way to significantly reduce comparison noise. Compare strings with numbers, ignore characters, apply comparison accuracy and more ...

Compare Visual Basic Code, Forms and Controls

Complete comparison of the Visual Basic Projects. Compare changes in the Code Modules and Form Controls. A must have tool 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!

xlCompare as a part of Version Control Applications

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.

Compare Files with Common Ansector
3-Way comparison - compare changes made by you and your co-worker in the same version of workbook.
Resolve Conflicts
One of the most important version control tasks is to resolve conflicts between different versions of the same file. xlCompare compares 3 versions of Excel workbook - YOUR, BASE and THEIR and gives you comprehensive report of the changes made, with ability to merge conflicts.
Diff Viewer for SVN\GIT Tools
xlCompare supports rich set of the command line options, to be integrated into the SVN\GIT environment as Diff Viewer and Merge Tool.
3-Way Comparison

Resolve conflicts between changes

When working in the multi-user environment conflicted changes are often happen. Few seconds and you resolve them with xlCompare.

Resolve Conflicts
Visual Representation
All differences are marked with colors exactly in the workbook. Conflicts has red color to be more highlighted then other diffs.
Aligned Rows
Inserted\Deleted rows are virtually inserted into same place in the corresponding workbook. This gives native look for the modified worksheets.
Detailed Report
Put cursor over the colored cell to get detailed report about the changes made.

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.

How xlCompare works

Visit this page to find detailed explanation for xlCompare on the real examples. See how we solve various tasks with xlCompare.

How it Works

Download Excel File Compare

On the DOWNLOAD page you can select version of xlCompare for your PC and download the setup package.

DOWNLOAD NOW

Current Version: 11.01

Build Date: June 21, 2023


Version History

During 15+ years our team has been 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.


Order Excel File Compare

Visit this page to get pricing information, license options and instructions on how to activate xlCompare on your computer.

ORDER NOW (-20%)