xlCompare: Excel Compare Tool

To start working with xlCompare (excel diff tool) you need to open your excel files in the application. Just drop them into excel compare window from the windows explorer.

Take a look into the Primary Keys

Primary Key is an important part of the every database. This is a basis of the database theory. So, we put your attention to this item. Do not miss this step.

Use the Merge button

Merge button on the Home tab on the excel file compare ribbon compares excel files on the left and on the right and merges all modifications into the FILE1.

Get the results immediately!

We've tried to make our excel diff tool as easy as possible. Just a few clicks and you see the results. All that you need after this step - is to press a Save button.

DOWNLOAD EXCEL DIFF TOOL

Merge Several Sheets in the Same Excel File

Open your files in the Excel Diff Tool xlCompare

There are a few ways to open excel files in the xlCompare - you can use Browse button, or Open File command on the File tab on the Ribbon. But the easiest way is to drop the file into the Windows Explorer.

(Optional Step) Setup Primary Keys

When you open excel file in xlCompare, the tool check worksheets for a database structure and suggests you primary keys. You can change this selection any time using the Right Click Menu commands. xlCompare has very handy interface for editing the primary keys.

Use the Merge Sheets Wizard

Merge Sheets in Excel File Wizard asks you worksheet that receives data for worksheets, whose contents should be merged into the master sheet. Wizard is very easy and requires only a few clicks from you.

Get your worksheets merged!

Excel File Compare Tool (xlCompare) gives you immediate results after you complete the Wizard. Do not spend your time for merging excel sheets manually.

TRY EXCEL FILE COMPARE TOOL

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:

Compare Excel Sheets for Differences

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:

Merge Excel Files into One

Companies that trust our software

We've got thousands satisfied customers

What do our customers say about xlCompare?

The best excel 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

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

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

Are you still looking for differences manually?

Boost your productivity with xlCompare!

xlCompare saves you a lot of time. In a few seconds, you'll get a comprehensive comparison report with minimum effort.

Quality

Our purpose - Give you a fast and robust Excel comparison utility. Our Excel Diff Tool was tested on 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 the Excel application and gives us the ability to implement any feature. This is not possible in the regular Excel-based solution.

Efficiency

xlCompare saves you time and money. It helps you to put your focus on the business tasks, while xlCompare is working on the spreadsheet comparison job for you.

Visual Representation of the Comparison Results

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

Detailed Information

The tooltip window on the changed cell shows detailed information about modifications. Get all difference details directly when browsing your worksheet.

Native View

Display original and modified value (or difference) in the same cell. This would be an optional feature which can greatly simplify your work with a comparison report.

Merge Icons

Select a range of cells you need and merge it into other worksheets in a single click. You can copy and move inserted rows between your worksheets.

Detailed and Complete Comparison Summary

The Difference Explorer Window displays all found changes. They are grouped by worksheets and rows\columns.

Complete List of Differences

The Difference Explorer gives a normal and easy way to browse all differences found between workbooks.

Filter Modifications

Keep on screen only the records you need - inserted, 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 seconds with a maximum accuracy. Excel Compare has a database comparison algorithms, which performs this task quickly and efficiently.

Inserted Rows\Columns

xlCompare detects new rows and columns in the worksheet and highlights them with background color. The colored pointers on the scrollbars help 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 can find, highlight and remove, all duplicate rows with minimum efforts. Duplicates can be found by key, by full row data, or by criteria.

Compare "Mixed" Data

A 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

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

Modified Code

xlCompare finds changes in the VBA Modules and displays them with color formatting.

Changed Forms and Controls

Finding modifications between Forms in an Excel Worksheet is the most complex task. It won't be in in other comparators. xlCompare not only displays for you all Forms and Controls in the hierarchical tree view form, but also compares 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 a third-party application with a set of command line options, as well as a 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 the 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 the Excel workbook - YOURS, THE BASE and THEIRS. It gives you comprehensive reports 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.

How to integrate xlCompare into SVN and GIT Environment

Highlight Conflicts

All differences are marked with colors exactly in the worksheet views. Conflicts will have a 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 a normal look for the modified worksheets.

Detailed Report

Put the cursor over the colored cell to get a detailed report about the changes made.

Let xlCompare work for you

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

Easy to Use

Compare and Merge Excel workbooks in a few clicks. You won’t need to waste time on learning the product.

Clear Interface

Here is a simple representation of the comparison results. xlCompare has number of unique options to represent differences in the best way.

Accurate Results

We are using the best algorithms in order to give you the most accurate comparison results.

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 the workbook with the same ancestor. This feature is a "must have" for an SVN\GIT Diff Viewer applications. This is the command line mode for integration with third-party tools, which requires an 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 the usual workbook comparing program. This tool has features creating productivity in various aspects.

Trace Calculations

A drill-down trace of the formula calculations in depth. Go through the formula dependents to find its input value. Check if 2 cells are dependent from one to another.

Evaluate Formulas

Divide the formula into elementary parts. Display them in the hierarchical tree form. It's the most suitable way for recursive analysation.

Where the Value Came From

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

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: 10.4

Build Date: 1/13/2022

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.

Version History

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%)

Need Our Help?

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

Send us a letter

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.

Open Youtube