Compare Excel Files for differences

Find changes in:

  • Cell Value
  • Formula
  • Fill Color
  • Text Color
  • Font
  • Border
  • VBA Modules
  • VBA Form Controls
  • And more ...

Comprehensive comparison report in seconds

Merge several Excel files into one in single click

Put your focus into important business tasks, while xlCompare does the routine job for you

What xlCompare can do for you

There are dozens of useful features and advantages our product offers. With them, you will quickly do all spreadsheet comparison and merging tasks you experience on the daily basis!

Find Changed Cells

xlCompare looks into your worksheets for changed cells and gives you a colored report, with highlighted changed cells and inserted\deleted rows.
Find Unique Rows

Keep your table up to date by detecting unique and duplicated data on the worksheet. xlCompare finds all records inserted into your Excel Table.
Find Changed Formulas

Check all formulas on the worksheets for modifications. xlCompare points you to the changed part of the formula. Don't locate differences in text manually!
Color Coded Report

All changed cells and unique columns rows are marked with color on the worksheet. You will easily identify them among other worksheet cells. If this is not enough - use Ignore Formatting option to disable all original cell formatting.
Remove Duplicates

Get read of duplicated records in one click. Highlight duplicates with different background colors to put accent into these rows. Move and Copy set of duplicate rows by filtering them on the worksheet. Filter Duplicate Rows and Keys.
Different Algorithms

Depending on the spreadsheet you compare - Price List, Accounting Statement, Financial Model - xlCompare offers the most suitable comparison algorithm. This gives more accurate comparison results.
Merge Changes

Easy-to-use Merge Commands move cells from one worksheet into another in the native and visual form. Update cells one by one or by using bulk merge commands. Fill database table with updated records in seconds.
Difference List

Browse all differences in one structured list. Analyze changes and merge cells, rows and columns between compared excel files directly from this list. Difference Explorer gives you clear answer - what actually was modified in the workbook.
Rich Set of Options

Ignore Hidden Rows and Hidden Columns. Select data to be compared. Display Cell Difference. Highlight cells with color when merging. Command line options. xlCompare has many options you can use to achieve the best comparison results.

This article shows how you can use xlCompare to compare two Excel files.

We've compared two price lists in the XLSX format to introduce you primary xlCompare features and options.

Spend a few seconds to see how xlCompare works:

Next example: merge several Excel sheets into one.

This is one of the common tasks for Excel Users.

There are 3 lists with auto parts, saved in a form of Excel spreadsheet (XLSX). In this article we've merged them into single list.

Look into this article to see how to quickly merge Excel files:

Companies who trust our software

Volkswagen Logo
Siemens Logo
Zurich Insurance Logo
Xerox Logo
Oracle Logo
Electronic Arts Logo

Why Use xlCompare?

Primary goal of xlCompare - comparison and merge operations with Excel worksheets and Visual Basic projects. Find out what we can do for you.

Compare Database Tables
Fast and Efficient
Compare Excel worksheets within seconds with a maximum accuracy. Get accurate and easy to understand comparison report.
Easy to Use
This Excel diff tool is extremely easy to use. We've made it as simple as possible. Do not spend your time on learning the product. Just install and use!
Clear Results
Perfect visual representation of the comparison results. xlCompare represents differences, found between compared excel files, in the native way.

10000+ satisfied customers

What our customers say about xlCompare?

The best comparison software!

Proc: Extremely 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

Still looking for differences manually?

Boost your productivity with xlCompare!

xlCompare saves you a lot of time. In a few seconds you get comprehensive comparison report with a minimum efforts.

Sales Statistics
Quality
Our purpose - give you fast and robust Excel comparison utility. Our Excel Diff Tool was tested on the millions of Excel worksheets around the world in different industries – from Game Development to Medicine.
Power
Based on the Spreadsheet Core engine our tool works faster than Excel application and gives ability to implement any feature, which is not possible in Excel-based solution.
Efficiency
xlCompare saves you time and money. Put your focus on the business tasks, while xlCompare is doing spreadsheet comparison job for you.

Visual Representation of the Comparison Results

Color coded report points you to modifications, found by xlCompare between your Excel worksheets. You see exactly, what was changed, and where the unique rows and columns are.

Detailed Information
Tooltip window on the changed cell shows detailed information about modification. Get all difference details directly when browsing your worksheet.
Native View
Display original and modified value (or difference) in the same cell. Optional feature which greatly simplifies your work with comparison report.
Merge Icons
Select range of cells you need and merge it into other worksheet in a single click. Copy and Move unique rows between your worksheets.
Worksheet

Detailed and Complete Comparison Summary

Difference Explorer Window displays all found changes, grouped by worksheets and rows\columns.

Difference Explorer
Complete List of Differences
Difference Explorer gives you native and easy way to browse all differences found between workbooks.
Filter Modifications
Keep on screen only records you need - unique, changed or equal. Use this filter to extract updated cells from the worksheet.
Merge and Bulk Merge
Merge cells one-by-one or merge all changes in one click. Move data between your worksheets in one click.

Compare and Update Excel 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 rows and columns in the worksheet and highlights them with background color. Colored pointers on the scrollbars helps you to locate updated and inserted data in your Excel file.
Check for Duplicates
Keep your database up to date. Find and remove duplicates and redundant records. With xlCompare you will find, highlight and remove duplicate rows with minimum efforts. Duplicates can be found by key or by full row data or by criteria.
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, ignore hidden rows and columns and more ...

Compare Visual Basic Code and Forms

Complete comparison of the Visual Basic Projects. xlCompare does all comparison and merge operations needed for VBA developers.

Compare VBA Projects
Modified Code
xlCompare finds changes in the VBA Modules and displays them with color formatting.
Changed Forms and Controls
Find modifications between Forms in the Excel Worksheet is the most complex task. And it is not present in other comparators. xlCompare not only display you all Forms and Controls in the hierarchical tree view form, but also compare them and displays even minor changes between VBA Controls.
Merge Commands
Merge VBA Code and Form Controls in single click. Just select code lines and click on the check icon! In a few seconds you will resolve all merge conflicts in your VBA code.

xlCompare as a part of Version Control Applications

xlCompare is a Diff Viewer and Merge Tool for Source Control Systems. Integrate it into third-party application with set of command line options and 2 and 3-Way Worksheet Comparison feature.

Compare Files with Common Ancestor
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
Highlight Conflicts
All differences are marked with colors exactly in the worksheet views. Conflicts has red color to attract your attention, among 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.

Let xlCompare work for you

With this tool you will do all workbook comparison operations quickly and efficiently. Save your time and be more productive by using xlCompare.

Easy to Use
Compare and Merge Excel workbooks in a few clicks. Do not spend your time on learning the product.
Clear Interface
Native and simple representation of the comparison results. xlCompare has number of unique options to represent differences in the best way.
Accurate Results
We are using best algorithms in order to give you the most accurate comparison results.
Compare Workbooks
Free Updates
Updating is the key of reliability, and that's why our clients get free xlCompare updates on the regular basis.
2 and 3-Way Comparison
Compare and merge 2 versions of workbook with same ancestor. This feature is a "must have" for a SVN\GIT Diff Viewer applications. Command line mode for integration with third-party tools, which require Excel File Diff Viewer.
Compare VBA Forms and Code
Compare Visual Basic Modules, Forms and Controls. Check every line of code in your modules and every control property on forms. Detect and report all changes between two visual basic projects.

Analyze and Debug Calculations in Depth

xlCompare is more than usual 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 in depth. Go through formula dependents to find its input value. Check if 2 cells are dependent one from another.
Evaluate Formulas
Divide formula into elementary parts and display them in the hierarchical tree form - the most suitable way for recursive analyze.
Where the Value Came From
Review list of calculation errors (#N\A, #VALUE, #DIV\0) and find out where the error came from. Expand all formula calculations and get source of the unexpected result.

F.A.Q. Options and Commands


What is Extended View?

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.

I need to see Difference between changed values.

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.

Can I save report I see in the Extended View?

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.

Does xlCompare find differences in formulas?

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 worksheet data
  • Only constant cells
  • Only calculated cells
  • Only text of formula
  • Only value of formula
  • Combination of the options above

How to identify found differences?

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.

Can I ignore hidden rows and columns?

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.

How to save Comparison Report to present it to colleagues?

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.

Export PDF Report

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.

PDF Report

Other option – Summary Report button in the Difference Explorer.

Summary Report

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:

  • XLSX
  • HTML
  • Text

Or just copy it to clipboard and paste into e-mail or other application.

Download xlCompare

Pick the version suitable for your Windows. A free trial is available to help you with the decision-making.

Current Version: 9.3.5

Build Date: 4/14/2021


Version History

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.

Supported Versions

Microsoft Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7

64-bit and 32-bit versions are supported

Microsoft Excel

xlCompare is based on the Spreadsheet Core engine.

It doesn't require Microsoft Excel to be installed.

Questions & Answers


Which version to choose - 64-bit or 32-bit?
If you have 64-bit Windows - install 64-bit version of the xlCompare. It allows to open larger workbooks and use full power of your 64-bit processor.
How does the 30-day trial work?
Once you decide to use xlCompare, you can run a 30-day free trial first. Including all the product features, it will help you decide which features are of the greatest value to you. Once the 30 day period is over, you will be asked to make your choice.
Are there any special requirements?
No, xlCompare is a completely independent software - it doesn't have any special requirements. You can install it on the any Windows PC. Just download, install and use.
Do you offer discounts for students?
We offer student and non-profit discounts. Just open a private discussion with us, verify your status and we will provide you with a 25% discount on the regular price. We may ask you to confirm your status with documentation, so please get ready to verify that.

Need Our Help?

If you have any questions regarding xlCompare, please contact us and we will give you a prompt response.

Order xlCompare

Standard
Personal Use
$99.99 $69.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  •  
  •  
  •  
  •  
  •  
  •  
  • Free Updates
  • 1 User
Order Now
Professional
Business Use
$149.99 $99.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  • Command Line Mode
  • SVN\GIT Integration
  • Bulk Merge Commands
  • VBA Automation
  • Trace and Debug Calculations
  • License Never Expires
  • Free Updates
  • 1 User
Order Now
Professional, 5
Business Use
$449.99 $299.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  • Command Line Mode
  • SVN\GIT Integration
  • Bulk Merge Commands
  • VBA Automation
  • Trace and Debug Calculations
  • License Never Expires
  • Free Updates
  • 5 Users
Order Now
* -30% discount is valid until April 30
* Standard license is for personal use only. You can't use it for your business
* All pricing packages include FREE Technical Support and new features and hotfixes by request.
VISA logo
MasterCard logo
PayPal logo
AMEX logo

Questions & Answers


Which payment methods are supported?
Orders are processed by our e-commerce partner, MyCommerce (Share*It) (part of the Digital River), through a secure SSL connection. It supports rich set of payment methods: All major Credit Cards, PayPal, Bank/Wire Transfer, ...
Is this a one-time payment?
Yes, there will be no future payments. xlCompare is sold as Permanent License, not like a subscription. You pay once and get a lifetime license.
Do you have volume discounts?
Yes. If you are ordering 3 and more licenses, please contact us for a Coupon Code. We'll provide you a discount.
Do you collect my Credit Card information?
No. Spreadsheet Tools and Share-It do not collect your Credit Card data.
Should I order a license for my new PC?
No. If you've got new PC - you can transfer your license to this new computer. You can do it yourself in your account in the Customer Area, or send us an e-mail and we'll do it for you.
How many activations do I have?
One xlCompare license allows you to use the software on one PC. If you plan to use xlCompare on more then 1 computer - you need a license for the every PC.
Is technical support included?
Yes. Free updates and unlimited technical support is included into your license. If you have any questions - contact us to get a prompt response.
Do you work with resellers?
Yes, sure. Please contact us for getting additional information.