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!
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!
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:
Primary goal of xlCompare - comparison and merge operations. Find out what we can do for you.
What do our customers say about xlCompare?
Still looking for differences manually?
xlCompare saves you a lot of time. In a few seconds you are getting complete comparison report with a minimum efforts.
Process large Excel tables within a seconds with a maximum accuracy. Excel Compare has database comparison algorithms, which performs this task quickly and efficiently.
Difference Explorer Window displays all found changes, grouped by worksheets and rows\columns.
Complete comparison of the Visual Basic Projects. All options and commands needed for VBA developers.
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.
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!
xlCompare is not only workbook comparator. This tool has features which makes you more productive in various aspects.
Current Version: 10.0.0
Build Date: 7/28/2021
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.
If you have any questions regarding xlCompare, please contact us and we will give you a prompt response.
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.
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.
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.
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.
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 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.
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.
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.
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.
Other option – Summary Report button in the Difference Explorer.
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:
Or just copy it to clipboard and paste it into e-mail or another application.