Introduction to Excel File Comparison

Spreadsheets are widely involved into all kinds of business processes. Excel File (workbook) is very suitable form to store and interchange datasets. Table form is the most appropriate way to represent all types of lists. If you are actuary – you keep analytic data in Excel Tables. If you are financial analyst – excel spreadsheet is a good way to keep exported income statements, cash flows and other accounting documents. Spreadsheet is an ideal way to develop calculation models without learning programming languages.
This requires effective instruments to work with spreadsheet data stored in excel files. Errors in the spreadsheet formulas and in the data processing cost companies millions of dollars every year.
We give you a powerful tool to analyze and compare spreadsheets. It increases your productivity and saves time and resources.
Compare Database Tables

The following language packs are available:

  • English
  • German
  • Russian
  • Chinese (will be published soon)

What xlCompare can do for you

We’ve created xlCompare, to give you utility to compare and merge your spreadsheets quickly and effectively. Very often you need to compare two versions of Excel Files for differences. This is primary tasks for the xlCompare.
After presenting you list of the differences, we give you handy way to merge changes found in your workbooks. Our tool completely covers all spreadsheet comparison and merging tasks. We are constantly working on the new features and polishing existing algorithms.
xlCompare is not a just file comparator – this is powerful instrument in your hands!
Worksheet

Inside the Excel Compare

xlCompare is not an add-in for Microsoft Excel. We’ve implemented this product using Spreadsheet Core – our spreadsheet calculation engine, used in Spreadsheet Compiler. This allows us to implement any feature needs to process excel tables quickly and efficiently and represent comparison results in the native and clear form. This application is completely stand-alone and doesn’t require Microsoft Excel to be installed.
Behind the xlCompare window there are set of algorithms, which solve comparison tasks with maximum efficiency. Every algorithm has rich set of internal parameters you can adopt to your type of Excel File. We’ve created a preset combinations for various types of documents (Financials models, Accounting Statements, Price Lists, Calculators, Check Lists, Complex Models with Formulas and VBA Code) based on our experience.
Over 20 years in spreadsheet development allows us to provide a solution for every project relative to spreadsheet processing.

How we Compare and Merge Excel Files

Let’s see how the product works. At first, xlCompare is a software designed for comparison operations – Main Application Window is divided into two panels. Workbooks we are comparing are placed on the left and on the right sides one versus one. This is the most suitable layout for file comparison.
xlCompare groups worksheet by pairs and compare each pair one by one. At first we determine which rows and columns were inserted into your worksheet. In other words, we are looking for data which is missed on the left and on the right panels.
After separating missed data, we check all cells for modifications. We look for changes in cell values, cell formulas and formatting options. Every modification in the excel worksheet is found and reported by xlCompare.
You are getting color coded difference report on the worksheet view to see differences in-place. We highlight every modification with color. Just a brief look into excel table and you see inserted rows and edited cells. Put tooltip over modified cell and get detailed information about this difference. xlCompare shows you what if different in this cell – value, formula or formatting. If formula is any cell is modified – we point you directly to the changed part of the formula text.
Compare and Merge Excel Tables
In addition to the color-coded report on the worksheet view, you get structured list of differences, grouped by worksheets. Inside the worksheet group items are grouped by type – Inserted Rows and Columns are separated from the Edited Cells.
When you select a difference in this list, xlCompare selects changed object on the worksheet view. Selection on the Left and Right panels are synchronized. We bring you both changed cells at once.
In this Difference Explorer you can browse all differences found between compared worksheets.
Difference Explorer
Now, when we give you comparison results, we give you sent of commands you can apply to the comparison results.
Mark Differences with Colors on the worksheets and save your files. xlCompare will apply temporary color highlighting to the every changed cell and make it permanent. After closing comparison report modified cells and inserted rows will be highlighted with colors, like on the comparison report.
Create Difference Report for the results you have. This is summary of comparison process, exported to the Excel Table. In the new excel workbook we create outlined report with all differences found. You can save this report in the XLSX format or just copy text and send by e-mail to your co-worker.
Save Comparison Results into PDF. We allow to save worksheet view with highlighted data into PDF file. You can use this file to explain your colleague what was changed in the file, or to share comparison results with other people.
After getting comparison results xlCompare gives you commands to merge changes between excel files. For example, you’ve received list of records from other person and need to add missing records to your table. xlCompare will do this in a second. Records are highlighted with color in the comparison report. And you can copy then into other worksheet with single click.
If you’ve got a new table with updated values from your customer – xlCompare merge your copy and customer’s file and give you list of the merged cells.
You’ve got a file with data divided into several sheets. How to combine when into single list on one sheet? You can do this manually – spend a hour and copy rows block by block into first sheet. Merge command in excel compare will do this accurately in a few seconds. Just point xlCompare to the sheets you want to combine and where to place the results. One click and xlCompare joins your excel sheets into single one.
Sales Statistics

Conclusion

As you see – xlCompare has long list of commands and options. This is not just a simple file comparator. This is robust and feature rich utility. Use it to increase your productivity and to get read of the routine tasks.
Compare Workbooks

In the Action

Look into several examples for xlCompare on the real files. We’ve described how you can use this tool for the common tasks you may experience with excel files.

Companies that trust our software

Volkswagen Logo
Siemens Logo
Zurich Insurance Logo
Xerox Logo
Oracle Logo
Electronic Arts Logo

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

Pick the version that's suitable for your Windows version. A free trial is available to help you with the decision-making.

Current Version: 10.0.0

Build Date: 7/28/2021


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.

Supported Versions

Microsoft Windows

  • Windows 10
  • Windows 8.1
  • Windows 8
  • Windows 7

64-bit and 32-bit versions are supported

Microsoft Excel

xlCompare is based on the Spreadsheet Core engine.

It doesn't require Microsoft Excel to be installed.

Questions & Answers


Which version should I choose, the 64-bit or 32-bit?
If you have 64-bit Windows - install 64-bit version of the xlCompare. It will allow you 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. 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.
Are there any special requirements?
No, xlCompare is a completely independent software - it doesn't have any special requirements. You can install it on any Windows PC. Just download, install and use.
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.

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.