xlCompare - Merge Tool
for Excel Workbooks
Primary goal of xlCompare is to compare and merge, resolve conflicts between Excel files and Visual Basic Projects.
How to merge 2 Excel workbooks:
1. Start xlCompare and use Merge 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.
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.
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
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 xlCompare
Pick the version suitable for your Windows. A free trial is available to help you with the decision-making.
Questions & Answers
Are there any limits in the software?
Evaluation version of xlCompare is full-featured. But it has following limitations:
- 30-days working period
- You are not able to save workbooks
- You are not able to copy cells from worksheet
- You can't save comparison report on disk
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.
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.
Do I need to register for the Trial?
No. You don't need to register your evaluation license. Just install it and use.
Order xlCompare
- License Type
- Delivery Type
- Future Updates
- Support included
- Future Payments
STANDARD LICENSE
$99.99
- PERMANENTnever expires
- DOWNLOAD LINKmsi file
Questions & Answers
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.
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, ...
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.
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.
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.
Is technical support included?
Yes. Free updates and unlimited technical support is included into your license. If you have any questions - contact us and you'll get prompt response in the nearest time.
Not Sure If xlCompare Can Work For You?
If you have any questions regarding xlCompare - contact us and we will try to help you.
Send us a letter