xlCompare - Merge Tool for Excel Workbooks

xlCompare is a powerful app designed to compare and merge Excel worksheets and Visual Basic Projects.

Compare Excel Worksheets

How to merge 2 Excel workbooks:

1. Start xlCompare and use Merge command

Excel Compare Merge Files Command

When you don't have opened workbooks in xlCompare, this form is a result of pressing the Merge button.

2. Select workbooks you want to merge

There are several ways, how to open workbooks in xlCompare.

  • Drop files from Windows Explorer into xlCompare window
  • Select one of the recent files in the drop down list
  • Open new file using [...] button

3. Press Merge Button on this form

That's all you need to do. xlCompare displays you merged workbooks.

Excel Compare Ready to Merge Excel Files

Your workbook is ready!

Changes from the left sheet were moved to the right one.

How Merge Command Works:

xlCompare merges ALL changes from MINE workbook, into the BASE one. In other words: ALL changes made in the LEFT worksheet is copied into the RIGHT worksheet.

Changes made in the BASE file (right worksheet) are NOT copied into the MINE file (left worksheet).

You can switch workbooks if you want to apply changes to other file.

xlCompare mark changes when mergins files

Mark merged cells with color

Use option Mark Changes When Merging to apply color formatting to every changed cell and unique row.

What if I have more complex data?

This procedure is the most common way - when all options are determined by xlCompare.

However, you can use full set of xlCompare comparison options to merge your Excel files.

Merge Excel Worksheets with custom settings

1. Start xlCompare and open your Excel files

In this case you SHOULD NOT press the Merge button.

Just drop your files into the xlCompare window, and make sure that MINE and BASE workbooks are selected correctly. Switch workbooks, if they are on the wrong locations.

2. Prepare your data for processing

On this step you can:

  • Setup Primary Keys, if you have database tables
  • Verify that xlCompare determines primary key correctly
  • Hide data you want to skip

xlCompare select excel worksheets for merge

3. Press Compare button

Now you need to select worksheets and VBA modules to be compared and merged/

4. Review comparison results

After pressing Compare button on the dialog, described above, you get comparison results.

Now you see which cells will be merged from MINE workbook into the BASE one.

5. Press the Merge button on the Main Window

This will start merging operation.

All changed and unique cells will be moved from left workbook into the right one.

Conclusion

xlCompare is able to perform all types of merge operations you encounter on the daily basis. This tool allows to merge workbooks in single click and to select and preprocess data before merging.

In any case this operation is quite simple and requires only a few second.

Download Excel Compare

Download and install the latest up-to-date version of xlCompare. The download is a full-featured version.

Current Version: 10.2.0

Build Date: 10/12/2021

Start using Excel Compare now!

Excel File Compare Home Tab on Ribbon

Filter Mathching Rows
Display only rows present in both excel files and exclude new (removed) rows
Filter Different Rows
Hide rows that have corresponding row on the other sheet. Display only different records on both sheets.
Update sheet with cells from other sheet (Merge)
Insert all different rows into other excel worksheet and update all modified cell values. In one click you can move million of rows!
Get Matching rows
Extract and save rows that has a corresponding row in other excel file.
Get Different rows
Save on the third worksheet rows that doesn't have a matching row on the correspondding sheet.
Mark Differences with Color
Permanently mark all changes you've found with background and text color to highlight them for future analyzis.
Get the Diff Report in PDF format
Create outlined report in the XLSX, HTML or PDF format. Save color formatting in the PDF file.

Display modified cells in the excel file compare tool

Extended View
Display original value and modified value in the same cell. Change this to display difference between values in the options.
Trending Arrows
Green and Red arrow icons indicate that value in this cell was increased or decreased. In addition to usual color formatting this gives you visual indication about tendency in the numerical values.

If you are still thinking if xlCompare is worth to try - please review long features list on the page below.

Questions & Answers

Can I use xlCompare to consolidate Excel Files?
Yes. xlCompare is not only Excel File Diff Viewer application. Utility has number of commands and options to combine several Excel worksheets into single one. Ability to update and merge Excel files is one of the primary features of the product. Use the Merge command on the Home tab on the Ribbon to update records in your Excel table with records from another one.
Which version should I choose, the 64-bit or 32-bit?
If you have 64-bit Windows - install 64-bit version of the xlCompare. With 64-bit version you can 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. This 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.
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.

Version History

During 10+ years, our team has been working to provide for 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 the amount of work done on the product.

32-bit Version

The most of the modern computers have 64-bit processors, which give you significantly more calculation power and other benefits. But if you have an old PC with 32-bit processor, please download xlCompare 32-bit using the link below.

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% AUTUMN OFFER is valid until December 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.