Use xlCompare to compare Excel files

Excel workbooks and CSV files are widely used as various reports, templates, pricelists, ... If your daily tasks require comparing Excel workbooks, it is highly important to quickly get accurate comparison results and handle them.

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

xlCompare - Robust and Powerful Tool in Your Hands

Our product offers dozens of useful features and advantages. With them, it will be easy to accomplish all spreadsheet comparison and merging tasks you experience on the daily basis!

Changes in Cells

xlCompare looks into your worksheets for changed cells and gives you a colored report. It will have highlighted, changed cells with inserted\deleted rows.
 
Changes in Formulas

Check all formulas on the worksheets for modifications. xlCompare points you to the changed part of the formula. You won't have to worry about locating differences in the text manually!
Inserted Rows

xlCompare finds all records inserted into your Excel Table and marks them with color. You'll be able to identify them among other worksheet cells.
 
Comparison Summary

All changed cells and unique columns rows are marked with color on the worksheet. If this is not enough - use the Ignore Formatting option to disable all original cell formatting.
 
 
Save Report

Get a detailed and ready to analyze report, with highlighted changes, in a second. Save it on the disk or send it by e-mail to your colleague. You can make several types of reports for different purposes.
 
 
Difference List

You can browse all differences in one structured list. Analyze changes and merge cells, rows and columns between compared excel files directly from this list. Our difference Explorer gives you a clear answer as to what was actually modified in the workbook.
Rich Set of Options

Ignore Hidden Rows and Hidden Columns. Select data to be compared. Display the Cell Differences. Highlight cells with color when merging. Command line options. xlCompare has a lot of options that you can use to achieve the best comparison results.
Different Algorithms

Depending on the spreadsheet, you can compare - Price Lists, Accounting Statements, and Financial Models. xlCompare offers you the most suitable comparison algorithm. This gives more accurate comparison results.
 
Merge Files

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-in the database table with updated records in seconds.
 

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 to the 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.

Read this article to see how to quickly merge Excel files:

Companies that 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. 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.

We've got thousands satisfied customers

What do 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 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.

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 ...

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 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.

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!

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

Main Advantages of xlCompare

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!

Compare and Update

Compare your version of Excel file with version of your co-worker and merge changes.
Highlight Differences

Detect cell and structural differences. Show differences in the form of Color Coded Difference Report.
Combine Worksheets

Combine several excel worksheets into one in single click. Select worksheets to be combined.
SVN\GIT Integration

Integrate xlCompare as diff-viewer application into your SVN\GIT environment.
VBA Code and Forms

Compare and merge Visual Basic Code and Form Controls. Merge Control Properties.
Print Diff Report (PDF)

Save Color Formatted Comparison Report in the PDF format. Ideal solution to share it with other people.

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.

Download Excel Compare

Current Version: 10.0.0

Build Date: 7/28/2021


Version History

During 10+ 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 xlCompare

Standard
Personal Use
$59.99 $48.99
  • Compare and Merge Sheets
  • Compare and Merge VB Projects
  •  
  •  
  •  
  •  
  •  
  •  
  • Free Updates
  • 1 User
Order Now
Professional
Business Use
$109.99 $89.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
439.99 $349.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
* -20% SUMMER DISCOUNT is valid until September 1
* 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 with hotfixes by request.

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 a 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 a Permanent License. It's not like a regular subscription. You pay once and receive 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 does 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 on your account in the Customer Area, or you can 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 will need a license for the every PC.
Is technical support included?
Yes. Free updates and unlimited technical support is included with your license. If you have any questions - contact us to get a prompt response.
Do you work with resellers?
Yes. Please contact us to receive additional information.

Need Our Help?

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

Spreadsheet Tools on Youtube

We've started publishing videos on the Youtube service, to show how to use xlCompare to compare Excel files for differences.

Ask, your questions directly in the comments, to share common questions with other users.

Please, visit out channel to get additional information about the product.

F.A.Q. Options and Commands


What is Extended View?

This is an important feature, which displays cell value(formula) and the corresponding value in same cell. With this option turned ON (default selection), you won’t need to search for the corresponding value on the other panel. It greatly saves your time and increases the usability of the Comparison Report.

I need to see the Difference between changed values.

The Option Display Difference activates the feature you need in the Extended View mode. With this option enabled, you can see difference between value in the MINE cell and value in the THEIR cell. The Colored Arrow mark indicates an increase or decrease in the value.

Can I save the report I see in the Extended View?

Yes, sure. You can export this report in a 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 formulas, and the text of an array formula. However, if you don't need to compare formulas, you can exclude this in the options. xlCompare gives you a 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 differences, found between my worksheets?

All differences are listed in the Difference Explorer report. When you select difference in this list - xlCompare will 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 will not be changed.

Can I ignore hidden rows and columns?

Yes.xlCompare has an option to exclude hidden rows and columns from the 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 the Comparison Report to present it to colleagues?

There are two options. You can print the Comparison Report exactly as it looks with all formatting into the PDF format, or use the Export button, with the 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 an 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 it into e-mail or another application.



In short advantages of xlCompare are the following:

  • Compare large workbooks in a seconds. This significantly increases your productivity.
  • Permanent License. Pay once and update and use xlCompare forever. Free 24/7 technical support.
  • xlCompare detects "added", "deleted" and changed data. This is not usual cell-by-cell comparison. Compare "mixed" and unsorted lists of data and get correct results. Select different comparison algorithms for Database data and Excel worksheets with formulas.
  • Comparison results look exactly in the same way as in the Excel window. xlCompare is the only tool on the market which has such visual representation of the comparison results. Example of the comparison results you can find on the screenshot below.
  • Display difference between compared values or corresponding value directly in the cell.
  • Compare all contents of the workbooks or single sheets or VBA Modules.
  • Compare data with different structure.
  • xlCompare has a number of advanced features to mark differences in workbook, to export differences, to edit data in the comparison report window.
  • Create intersection of the compared worksheets.
  • Extract unique or equal records.
  • Set of Database commands to filter duplicated rows and keys.
  • Export or Print comparison report.
  • Merge cells one by one, or use bulk merge commands to update workbooks in a single click.
  • xlCompare has commands for drill-down tracing of the calculations. Use it to debug calculations and research errors in your formulas.
  • Use xlCompare from the Command Line to compare XLS, XLSX, XLSM, XLSB, CSV files.
  • Automate you tasks with Visual Basic macro.