Get comprehensive color-coded comparison report for Excel files in a seconds
We compare and consolidate all types of excel files:
xlCompare gives you the best comparison report for your excel files by using side-by-side layout.
15 years on the market!
With a team consists of industry experts we developed a powerful and reliable tool to bring your productivity to the highest level.
Extremely fast on the large Excel files
100Mb files with 1 million of rows are compared in several seconds.
Diff and Merge Tool for Version Control
Integrate xlCompare into any SVN or GIT system using command line mode as an external diff and merge tools for XLS, XLSX, XLSM, XLA, XLAM, CSV and TXT(text) files.
Available in the following languages:
There are dozens of useful features and advantages Excel Compare Tool offers. Armed with them you will quickly do all spreadsheet comparison and merging tasks you experience on the daily basis!
Look how xlCompare works on the real examples. The page below contains examples of the most common tasks solved with Excel Compare Utility.
Compare two Price Lists for differences and highlight changes. Format changed cells with color.
Merge several Excel worksheets into one. Combine lists with auto parts stored in the Excel worksheets into single sheet with xlCompare.
Create outlined Difference Report for modified Excel Workbook and save it as Excel File. E-mail this file colleague.
xlCompare detects changes in cell value, formula, fill, font and other formatting options and report it to you by highlighting this cell with color
Rows and Columns are compared with corresponding ones from another worksheet. Inserted and Deleted items are marked with color and added to the comparison report.
Compare cells on 2 or more Excel worksheets and combine them into single sheet with Merge and Bulk Merge commands.
xlCompare displays updated cell values and formulas on the worksheet. This is the most native representation of the changes.
Get Comparison Report for your worksheets and save it to the PDF format with extended formatting options.
When Comparison Report is active - differences are synchronized with worksheet contents.
Number of commands, you can use to Filter, Highlight and Remove Duplicate Records.
After you have comparison results, you can filter them to print\save or copy to other application.
One click mass operations are essential part of the software, designed to save time and increase productivity.
Reduce comparison noise by selecting cell and formatting options included into comparison
Define comparison strategy which is most suitable for the data you have
Detailed comparison of the contents of VB Projects in your workbooks. Compare changes in the Class and Code Modules and Form Controls.
A must have tool for VBA developers!
From the fist looks VBA projects are text files, and can be compared like them. Yes, sure you can use this method. But we are using function level comparison method. Changes are detected on the function level. This gives better and accurate results. xlCompare gives you a powerful tool which can do all you need for Visual Basic code comparison and merging.
xlCompare is an ultimate spreadsheet comparator utility for a VBA developers and programmers who work in the team environment.
Compare and Merge VB Forms and Controls in a visual, native form. Just in a few clicks you get all changes applyed to specific form.
xlCompare has own Visual Basic Form editor.
You see all controls on the Form including hidden ones.
This gives ability to display contents of the Form in it's native way. You see form exactly as it looks in Excel application. All form controls are combined into hierarchcal tree structure - you can see it in the top-left pane of the editor. Properties of the selected control (Name, Font, Colors, Tab Index, Size and Position, ...) are below tree control in the list.
xlCompare processes not only Code Modules in the VB Project, but the Form objects also. It detects:
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.
When working in the multi-user environment conflicted changes are often happen. Few seconds and you resolve them with xlCompare.
Here you find a solution for various spreadsheet comparison tasks you may encounter
I need a excel diff tool that will compare two large excel sheets (about 330k records vs 370k records) and put results into other worksheet. It should contain only rows in the larger file that are not in the smaller file, based on the selected field.
1 Drop bigger file into Left Panel (FILE1)
2 Drop smaller file into Right Panel (FILE2)
After this you see both worksheets opened one versus one
3 Press Compare button on the Home tab.
It shows you the Comparison Wizard. If your excel workbooks contain several sheets - make sure that sheets are selected by pairs properly. In this wizard you can modify the selection. But usually you can just complete the Wizard immediately without any additional actions.
4 Now you have color coded comparison report with highlighted unique rows and changed cells.
5 Use the Bulk Merge command below the report. This command opens Merge Wizard where you need to select desired operation you would like to perform with your datasets.
6 Choose Create Difference of Two Tables on the Left Sheet. Thats All! After you run this command in a few seconds you get records from the bigger sheet on the left.
Our company has an Excel File with 20 worksheets. All these worksheets are linked with formulas and references for for calculations and for data. In some sheets we are using external references to get data from other excel file. So, this main book depends from other excel workbooks. Workbook has many formulas, defined names and references. Sometimes we save all workbooks and update the source files to do the calculations for the current period.
How to tracks all modifications in excel files and compare if source file data was updated properly in the final workbook. We want to compare the data and track all cells that was updated.
I have one main folder containing the data of every month that goes by. The number of files I have will continually grow overtime. I would like to have all of these merged into a table in one main file.
I would like to compare two excel files, that has many worksheets and merge them in the one base file. These are not shared workbook, but our workers have modified and saved it under different names.
Here we discuss online excel file comparators
Look into this article if you are working with tables saved in a form of text (TXT) files
You've found several excel comparators on the web - which one is the best of them.
There are some reviews on the web, which compares excel file comparison utilities and their functions. In the page below we describe typical reviews and give you our opinion about this ratings.
Get more information about comparison process. How we compare excel files for differences, which types of excel files are processed and which operations xlCompare performs to deliver you best comparison results.
How to consolidate and update excel files and what do you need for this. Read about this process in detail.
Compare 2 excel columns for differences and get the outlined report with explanation for the every found difference. More information is in the article below.
See how xlCompare works on the real examples. Visit this page to find detailed explanation of solving various tasks with xlCompare.
We've created a short video to show you how to open excel files and compare worksheets for differences. In addition in this video we discuss Primary Keys and how to setup them on the worksheet columns and rows.
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.
Increase your productivity with Excel Compare
If you are working with Price List, Accounting Statement or complex Financials Model, xlCompare has options and algorithms for the every type of data. Update and Merge tables in a seconds using 1 click commands. Filter new or changed records, remove or highlight redundant records - xlCompare has all functions you need.
Create outlined Difference Report with this Excel File Compare Tool. Export report as PDF and send it to co-worker.
Combine contents of the several Excel sheets into one worksheet in a few clicks with maximum accuracy.
For Excel Developer we offer formula comparison and debugging commands. You will quickly find differences between 2 versions of your workbook and trace and debug calculations in your spreadsheet. Formula Auditing Tool will save you a lot of working time, spent for drilling into dependencies in your workbook.
Integrate xlCompare into your SVN\GIT environment using command line mode.
Conclusion: xlCompare has all you need to work much faster!