Best Excel diff tool to compare and merge Excel files

How to compare Microsoft Excel files for differences using xlCompare tool and merge changes

xlCompare is your diff and merge tool for Excel (XLSX ans CVS) files

xlCompare is a leading Excel Diff Tool that compares two or three Excel files for differences. Excel Diff Tool boosts your effectiveness and productivity. Excel Diff Tool gives you detailed comparison report with all differences found in Excel files. With xlCompare complex and time-consuming work became simple! Using Excel Compare helps you to reach your business goals faster. In the modern world - this is important competitive advantage.

Compare cells and formulas in the Excel files

Compare Cells
Compare Formulas
Compare sheets by key column
Compare sheets cell-by-cell

Compare VBA projects and forms

Compare code in visual basic modules. More ...
Compare controls on forms in the vb project. More ...

Compare two or three Excel files at once

Compare excel sheets with common base version, integrate xlCompare into SVN\GIT environment. xlCompare is a software that does a diff function on the Excel files. More ...
excel diff function

What are the benefits of choosing xlCompare?

Save your time

You can compare excel sheets using conditional formatting, VBA macros and other methods. But every of these methods take your working time. If you select xlCompare as your Excel Diff Tool you need to spend only a few seconds. xlCompare does this job for you at a reasonable price.

Precise results

Our specialty is Excel worksheet comparison. If you give every job to professionals - you receive best results. xlCompare is a solution you need! Try it and you will be fully satisfied.

Increase productivity

Armed with xlCompare you move your professional efficiency to the highest level. Just focus on the important primary tasks of your business.

Error-free solution

Every year companies lose millions of dollars due to errors in their data. Are you sure you want to increase this statistic?

Our primary goal is to give you best and the most powerful Excel file comparison tool

xlCompare converts complex and time-consuming tasks into set of simple actions. It greatly simplifies your business processes.

What differs xlCompare from other excel diff tools?

Our purpose is to give you best excel diff tool to save your working time and boost your productivity to the highest level.


Simplicity reveals the beauty of xlCompare. Advantage of xlCompare is not only to effectively compare or merge Excel sheets or files, but to do this process as simple and convenient as possible.
xlCompare works in the following way:
  • Drop your files into xlCompare
  • Get the clear results
We've minimized number of settings and options you should use to get the results by using several AI algorithms.
You should not spend you time to select various comparison settings to get the results.
excel file comparison tool diff report
Fundamental tool
As a professional Excel/VBA developer, XLCompare has become a fundamental tool in my development process. It works on even the most code-heavy and complex of workbooks, and is something I just couldn't do without.
Peter Hamilton

Best Excel file comparison tool

xlCompare is fast and best performing Excel file comparison tool. Excel diff tool compares Excel files for difference. Download Excel diff tool (xlCompare) to get comprehensive diff report for Excel files. Formulas and macros are compared on the function level - this gives you best and accurate results when you compare Excel files.

Compare three Excel files

xlCompare is an ultimate Excel Diff tool to compare and merge all kinds of Excel files (XLS\XLSX\XLSM\CSV\TXT\...). Compare multiple Excel files for differences. Integrate Excel file compare tool into SVN and GIT tools and source code control systems. Command line mode allows to integrate xlCompare into any third-party application that requires Excel diff checker. Use xlCompare to resolve merge conflicts between different versions of the same Excel file (3-way compare and merge for Excel files).

Compare Excel files by key columns

xlCompare is Excel file compare tool, that finds differences in two Excel files. Excel compare tool is the best way to compare Excel files effectively. xlCompare gives you set of commands to define and edit Primary Key Columns on your sheets in the easy and native way. With this Excel Compare Tool you extract unique records from your database, filter updated and matching rows, and more ... Join few excel sheets into one in a few clicks. (more ...)

Excel diff tool with command line mode

Use xlCompare for SVN\GIT integration. If you are working in the multi-user environment and have SVN\GIT system installed - xlCompare is a perfect excel diff viewer and merge tool for XLS\XLSX\XLSM\XLA\XLAM files and CSV\TXT files. Easy integration allows to use it with most popular source code control systems.

Merge cells and entire rows in one click

xlCompare is more than just Excel file compare tool. It gives you commands to merge inserted rows and modified cells between sheets in one click. Easy to use merge commands copy all new rows and edited cells from one worksheet to another in just a second. Worksheet consolidation was never being so easy. Just in one click you can combine several Excel files into one.

Perfect Visual Representation

In the Extended View mode xlCompare shows original and modified value in one place. xlCompare shows you difference between two modified cells with trending icon, that indicates increase or decrease of the value. In the modified formulas we highlight edited characters. xlCompare puts your focus directly to the changed data.

Extremely fast performance

xlCompare is optimized to work with very large excel files. It opens XLSX files faster than Microsoft Excel, and compares Excel sheets with 1 million of records in a seconds. Set of algorithms, adopted for specific data structures, gives you accurate comparison results in a moment.

Rich set of options

xlCompare has a lot of options you can use to do your work much faster. Comparison accuracy, ignore specific characters, exclude hidden rows and columns, exclude calculated values, ... Application has long list of features you can find here: xlCompare Features
3-way comparison for excel files
Very nice software
Very nice your software, the 3 ways blowed my mind out, I did a 2h job in 10 minutes (I looked 5 sec at my screen without moving because I was so surprised).
Olivier Regout
xlCompare gives you ability to perform excel worksheet comparison quickly and flawlessly. Armed with this tool you can focus on the results without waiting for them. If you value your time, you will make the choice!

Number of spreadsheet tools you are getting for free with xlCompare

xlCompare - is more that usual Excel diff tool, that compares Excel files and gives you report with highlighted changes. Our Excel file comparison tool gives you set of extra commands for free. For example look into the article below to see how you can debug formulas in your Excel models. All commands that trace precedents and analyze calculations are available in the Evaluation Version of Excel file comparison tool and also works in the expired version of the Excel diff tool (xlCompare).
Excel gives you commands to evaluate formulas and see how it is calculated. But, try using Excel diff tool (xlCompare) for this and you will never give it up!
Debug Formulas

Trace Precedents in Excel File with xlCopmare

Trace Precedents in Excel worksheet
Number of free features constantly grows and we plan to increase it constantly in the future!

Are you looking for Best Excel Comparison Tool?

How to compare Excel file comparison tools on the market and choose the best one
If you search for Excel file comparison tool - Google gives you 5 or more tools you can choose to compare Excel files for differences. Which one is the best Excel file comparison tool?
You don't need to analyze spreadsheet comparators market yourself to find the top excel file compare products. Just investigate the list of xlCompare features. Excel diff tool xlCompare offers the most complete set of spreadsheet comparison and merging features to its Excel users.
If you are working with spreadsheets that have identical structure and relatively small size - Excel itself is the best in this business. You can compare such files using one of the instructions on this page, without using excel diff tool. But for complex spreadsheets, that have unique rows and columns, or if you are doing this regularly - you need an excel diff tool. And this is the best place where to find robust and simple in use utility - Download xlCompare.

What are the key differences between xlCompare and other Excel file comparison tools?

All Excel diff tools solve the same task - compare Excel files for differences and display results for the comparison. Results are higlighted with colors. From this point of view all Excel diff tools are identical. But there are details, that helps you to choose one tool over others.

Using side-by-side view to display worksheets

This feature is used by all Excel diff tools. This is the best and most suitable layout to present results in the compared Excel files. xlCompare gives it to you by default when you start it. While other tools need to configure Excel application to tile worksheets vertically on when they start the comparison.
Side-by-side view in the xlCompare window

How we report changed cells in the compared Excel sheets

Just look into the image below to see how xlCompare displays you information about changed cell on the worksheet.
Excel diff tool displays changed cells on the Excel worksheet
You see original and modified value, difference and tendency arrow that indicate increase or decrease of the cell value.

Align matching rows on the worksheets

Highly important feature. xlCompare inserts virtual rows into worksheet, where corresponding one contains unique rows. So, when you browse diff report matching rows are always one vs. one. This greately help you to analyze comparison results, when you've compared two Excel files for differences.
Excel diff tool aligns matching rows on the worksheet

Commands to merge changed cells between Excel files

Every changed cells and new row(column) has merge button. Just press this button and call value(formula) or entire row is copied into the corresponding Excel file. You don't need to play with copy and paste commands to move the worksheet data frome file to another.
Merge changes between two Excel files

Ignore columns on the worksheet

Imagine, you don't need to compare data in some columns. What to do? xlCompare gives you easy way to uncheck the columns you don't need. Easy and quick!
Ignore columns from being compared in Excel files

Compare VBA forms for differences

In this component xlCompare is unique tool. No other Excel files comparison tools compare forms and controls in the Visual Basic projects. You may say that most of the Excel files comes with data in the XLSX or CSV formats. But there are a lot of Excel developers around the world and we can't ignore their needs.
Compare VBA forms in the Excel files

Excel diff tool with command line mode

Integrate xlCompare tool into SVN or git software as an external Excel diff viewer. xlCompare has all you need to resolve merge conflicts, while most of the Excel based tools doesn't provide you command line mode.

Compare three Excel files

In some cases you need to compare three or more Excel files for diffs. What to do if your tool allows to compare only 2 Excel files(sheets)? This is not a problem for xlCompare. It compares 3 Excel files and synchronizes changes. You are getting report that points you to common and different records in your Excel files. Also it highlights conflicted cells and rows, if they were changed in all three Excel files.

Make a conclusion on choosing best Excel file compare tool

The most important benefit you get from xlCompare is simplicity. This tool transforms complex and routine actions into simple steps and gives you results without any efforts!

Complete Spreadsheet Comparison

On the Features page we've published a summary of the features collected from excel comparison tool reviews. xlCompare covers all of them.

Biggest Set Of Options and Commands

xlCompare has more options than every other tool on the market. This gives you maximum flexibility in checking your sheets for differences.

Best Performance

xlCompare is based on our Spreadsheet Core engine, that opens Excel workbooks faster than Excel application. By working with core objects and state-of-the-art algorithms we give you best performing tool on the market.

Continuous Development

Regular updates give you stability. This is important. We continuously improve the software and publish updates for xlCompare. Look into History of Changes to see the list of regular updates.
Volkswagen Logo
Siemens Logo
Zurich Insurance Logo
Xerox Logo
Oracle Logo
Electronic Arts Logo
「Spreadsheet Tools社と素晴らしいパートナー契約ができたことをうれしく思います。xlCompareは当社のドキュメントソリューションに貢献してくれるでしょう」 株式会社ヒューリンクス 常務執行役員 若林 登
[プレスリリース] ウクライナ Spreadsheet Tools 社との販売バートナーシップ契約締結について

Compare cell values and formulas in two Excel worksheets

xlCompare detects changes in cell value, formula, fill, font and other formatting options and report it to you by highlighting this cell by color
Changed Values
If you've changed cells value, or it was changed after recalculation - it will be highlighted by xlCompare.
Changed Formulas
If you've changed cells value, or it was changed after recalculation - it will be highlighted by xlCompare.
Changed Formatting
xlCompare detects changes in the border, background fill, text color and font options. All cell formatting options are compared.

Find Unique and Matching rows between the Excel worksheets

Rows and Columns are compared with corresponding ones from another worksheet. Inserted and Deleted items are marked by color and added to the comparison report.
Align Rows
Virtually Aligned Rows
Added and Deleted Rows(Columns) are virtually inserted into another workbook to make native representation of the comparison results. Every pair of the corresponding rows are on the same places.
Merge Unique Rows
With aligned rows you see where merged unique rows will be inserted. Select range of the rows you want to insert and move them in one click on the plus icon.
Bulk Merge
Merge all changes in single click. Get your workbooks synchronized in a seconds.

Combine Several Excel Sheets into One

Compare cells on 2 or more Excel sheets and combine them into single sheet with Merge and Bulk Merge commands.
Compare Database Tables
Merge Cells
Select range of cells you want to merge and use Merge command. All values on the corresponding sheet will be updated in one click.
Merge Unique Rows
Select rows or columns you would like to merge and press PLUS icon to add them to other worksheet. You get only records you need!
One Click Merge
Merge button combines spreadsheets in a without selecting differences one by one. One mouse click and few seconds - your sheets are combined into one.

Comprehensive Color-Coded Difference Report

xlCompare displays updated cell values and formulas on the worksheet. This is the most native representation of the changes.
Highlight changed cells and unique rows in Excel Compare
Display Difference
Display Difference option gives you ability to see updated value and difference.
Focus on Changes
Sometimes updated value is not so important as difference between values. You get exactly what you need.
Unique Feature
This feature is possible only in the xlCompare. It is not possible in the software based on the Excel application.

Save Color Coded Comparison Report

After you compare two files in excel, you get Comparison Report for your sheets and save it to the PDF format with extended formatting options.
Export To PDF
Save as PDF
Ideal for presentations. Save color formatted cells with their corresponding values or differences.
Save as XLSX
Save Comparison Summary for future use, or to send it to co-worker. You compare two XLSX files with xlCompare and save outlined difference report on disk.
Save as HTML
Use all power of the HTML language to create presentation for compared data.

How to identify changed cells in the Excel diff report

When Comparison Report is active - differences are synchronized with worksheet contents.
xlCompare:Scrollbars with Difference Map
Scrollbar Marks
Changed Cells and Unique Rows are reflected on the scrollbars with colors marks.
Worksheet Tabs
Count of differences on the every worksheet is added to sheet name as suffix.
Hide Equal Sheets
Equal and excluded from comparison sheets are hidden from the Comparison Report.

Highlight and Remove Duplicates in Excel Tables

Number of commands, you can use to Filter, Highlight and Remove Duplicate Records.
Highlight and Remove Duplicate Rows in Excel Compare
Highlight Duplicates
Highlight equal (duplicate) rows (keys) by color.
Filter Duplicates
Display only duplicate rows. Unique rows are hidden.

Filter matching rows on the Excel sheets

After you have comparison results, you can filter them to print\save or copy to other application.
Filter changed cells and inserted rows in Excel Compare
Only Unique Rows
Leave only unique rows on screen.
Only Equal Rows
Leave only rows without modification.
Changed and Equal Rows
Hide unique rows and display only changed and equal ones.

Merge multiple Excel files(sheets) into one

One click mass operations are essential part of the software, designed to quickly merge contents of the Excel files in the various ways.
If you are working with a big datasets:
  • Database lists
  • Price lists
  • Accounting statements
  • LOG files
  • CSV files
You needs in quick and powerful merge commands which allows to manipulate whole sheets.
xlCompare gives you Bulk Merge Operations - you can resolve all conflicts found by comparison in single click. This greately increases your productivity if you are working with large amount of data.
By choosing xlCompare as your tool to merge excel files, you can solve following tasks:
  • Merge Excel files into one
  • Merge Excel sheets in one file
  • Combine multiple Excel files into one file
  • Merge Excel sheets from command line
  • Merge Excel files in the batch mode
Bulk merge commands in Excel Compare

Filter worksheet data you want to compare with Excel diff tool

Reduce comparison noise by selecting cell and formatting options included into comparison. Define comparison strategy which is most suitable for the data you have
Options Comparison
Exclude Hidden Rows
Hide rows or columns and this data will be excluded from comparison.
Calculated Values
If you are not interested in the calculated cells - exclude them and compare only formulas.
Ignore Formatting
Very often cell formatting produce comparison noise. You can ignore it.

Compare Visual Basic Modules, Forms and Controls

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!
Compare VBA Projects in Excel Files
Modified Code
xlCompare finds changes in the VBA Modules and displays them with color formatting.
Changed Form Controls
If you've modified form control - it will be detected and displayed by xlCompare.
Merge Projects
Fast and Easy to use commands to merge changes found in the VBA Code and Form Controls. Resolve conflicted modifications just in a few clicks!
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 that does all you need to compare and merge Visual Basic code.
xlCompare is an ultimate spreadsheet compare utility for a VBA developers and programmers who work in the team environment.

Compare and Merge VBA Forms

Compare and Merge VB Forms and Controls in a visual, native form. Just in a few clicks you get all changes applied to specific form.
Compare Visual Basic Forms
Merge Forms
If you have new VBA Form in one book, xlCompare will move it to other file.
Merge Controls
Your co-worked added new control - one click and it is added to your version.
Merge Properties
You've changed control background color on control - xlCompare will merge it into common version.
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 hierarchical 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 is the most complete comparison utility for Visual Basic Projects

xlCompare compares code modules and form objects and controls. It detects:
  • New and Removed Code Modules
  • New and Removed Class Modules
  • New and Removed Form Objects
  • New and Removed Controls on the Forms
  • New and Removed properties on the Forms

Diff Viewer for Version Control Applications

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.
3-Way Comparison
Compare Files with Common Base Version
Use 3-Way comparison mode to compare changes made by you and your co-worker in the same version of workbook.
Resolve Merge Conflicts
One of the most complex version control tasks with Excel Workbooks - is to resolve conflicts between different versions of the same workbook. xlCompare compares 3 versions of Excel workbook - YOUR, BASE and THEIR and gives you comprehensive report of the changes made, with ability to merge changes and resolve conflicts.
External Difference Viewer for SVN\GIT Tools
We offer rich set of the command line options, which cover requirements of the SVN\GIT Applications.

Resolve conflicts between different versions of same workbook

When working on the shared workbook with your colleagues, you often get conflicting changes in Excel cells. Few seconds and you resolve them with xlCompare.
Resolve Conflicts
Visual Representation
All differences are marked by colors exactly in the workbook. Conflicts has red color to be more highlighted then other diffs.
Synchronized Rows
Inserted\Deleted rows are virtually inserted into same place in the corresponding workbook. This gives native look for the modified sheets.
In-place Tooltip Report
Put cursor over the colored cell to get detailed report about the changes made.

Typical users cases for Excel File comparison

Here you find a solution for various spreadsheet comparison tasks you may encounter
Case #1 (How to compare two Excel sheets for duplicates)
I need a excel diff tool that will compare two large excel sheets for differences (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.
The Solution:
From your description we see that you need to get the difference between two datasets. Difference is a records from one sheet which are not present on the another worksheet. xlCompare has a command developed for this operation, so you can get the results just in a few clicks.
We would like to note, that 300k-500k is not a big dataset for xlCompare. We are working with 1m+ sheets (more than one million of rows).
Please, do the following:
  • Drop bigger file into Left Panel (FILE1)
  • Drop smaller file into Right Panel (FILE2)
  • After this you see both sheets opened one versus one
  • 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.
  • Now you have color coded comparison report with highlighted unique rows and changed cells.
  • 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.
  • 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.
Now you can work with the output dataset. As you've stated in the description - you need a third worksheet with output records. So, please use the Save As command to save a copy of the output worksheet, without modifying your bigger file.
 Conclusion:  Just in 6 clicks and a few seconds you've got the results. As you see xlCompare is not just a spreadsheet comparator - it performs much more operations, than usual excel comparison tool.
Case #2
Our company has an Excel File with 20 sheets. All these sheets 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 data in two excel sheets and track all cells that was updated.
The Solution:
You can use Excel Compare to find differences (updated cells) in your excel files. In a few clicks you get a comparison report for your workbooks.
Difference Explorer shows list of changes found in your workbooks grouped by sheets and by address, so you can track all changes using this list. Go through all data record by record and check if all changes are correct. When you select record in the Diff Explorer Window xlCompare points you to actual worksheet cells that was changed.
You can mark all changed cells by color to analyze all modification later. Or to present changed input values and formulas to your colleague.
Export comparison summary in the XLSX format to send it to your co-worker so he can review your report and check the changes made.
 Conclusion:  Our Excel File Compare Tool gives you a powerful solution for the tasks you experience in your everyday work.
Case #3
I need to compare two excel workbooks and highlight differences. I have two similar excel sheets. However, there is one main difference between data in these two sheets.
I must have a version prior to being re-shaped somewhat and many data-fields do not have the same data-type. So, in a typical comparison using a formula, date-columns may be text-type at one sheet and date-type at the other.
Obviously, these data-elements although showing the same date are different because of the data-types.
The Solution:
xlCompare has an option Flexible Comparison. With this option enabled, Excel Compare converts text values into appropriate numeric or date value before comparing. This allows to significantly reduce comparison noise. Number of cells marked as updated is greately decreased.
Case #4
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.
The Solution:
Solution for this case and similar another one we've placed into article below. Read it to get detailed instruction on how to consolidate values in two Excel sheets with excel diff tool.
Case #5 (How to merge multiple Excel sheets into one)
I would like to compare two excel files, that has many sheets and merge them in the one base file. These are not shared workbook, but our workers have modified and saved it under different names.
The Solution:
This case has various solutions with xlCompare, two of them are described in the article below.

For whom this excel file compare tool is?

Data Analyst and Data Scientist

Working with analytics data? Try to compare and analyze rich sets of data stored in the Excel tables with xlCompare!


Compare your risk management models with xlCompare. Our tool is used in insurance companies over the world.

Software Developer

Compare merge application logs stored in the XLSX and CSV files. xlCompare is widely used in the Game development industry. SVN and GIT applications is a must have part of the software development. So, xlCompare is an ultimate excel diff viewer for any source code control system.

And every Excel user

Everyone who uses Excel needs to compare his files. If you are doing this regularly - let us do this job for you!

Increase your productivity with Excel Diff Tool xlCompare

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.

Spreadsheet Core Engine inside

Why xlCompare has a number of unique features, you can't find in other software?
xlCompare is based on the own Spreadsheet Core engine. So, we can offer you features which are not present in the software based on the Microsoft Excel Application.
xlcompare space on quora

Join xlCompare space on Quora!

In this space we are sharing information about xlCompare and discussing various use cases. Post your question in this space to share it with community.
We will be happy to see you in the list of our followers and contributors!

I have a question regarding this Excel Diff Tool

Please, describe your question or inquery in the form below. We will be happy to respond you!