Compare Excel files for differences
Find all differences in Excel (files) worksheets, highlight changes and merge cells
Compare Excel Files (worksheets)
- cell values
- cell and array formulas
- defined names and tables
- fill\font\text color
- VBA Modules
- VBA Form Controls
- CSV files
Merge Excel files (worksheets)
- merge two Excel files into one
- merge two Excel sheets
- combine all sheets into one
- merge folders
Available in the Microsoft Store©
xl comparator tool in the action
15+ years on the market!
xlCompare is a time-proven xl comparator solution, used on the thousands of computers around the world. We proud every our customer!
How xlCompare can help you to compare Excel files for differences
There are dozens of useful features and advantages our xl comparator offers.
With them, you will quickly do all spreadsheet comparison and merging tasks you experience on the daily basis!
Find Changed Cells
xlCompare looks into your worksheets for changed cells and gives you a colored report, with highlighted changed cells and inserted\deleted rows.Find Unique Rows
Keep your table up to date by detecting unique and duplicated data on the worksheet. xl comparator finds all records inserted into your Excel Table.Find Changed Formulas
Check all formulas on the worksheets for modifications. xlCompare points you to the changed part of the formula. Don't locate differences in text manually!Color Coded Report
All changed cells and unique columns rows are marked with color on the worksheet. You will easily identify them among other worksheet cells. If this is not enough - use Ignore Formatting option to disable all original cell formatting.Remove Duplicates
Get read of duplicated records in one click. Highlight duplicates with different background colors to put accent into these rows. Move and Copy set of duplicate rows by filtering them on the worksheet. Filter Duplicate Rows and Keys.Different Algorithms
Depending on the spreadsheet you compare - Price List, Accounting Statement, Financial Model - xlCompare offers the most suitable comparison algorithm. This gives more accurate comparison results.Merge Changes
Easy-to-use Merge Commands move cells from one worksheet into another in the native and visual form. Update cells one by one or by using bulk merge commands. Fill database table with updated records in seconds.Difference List
Browse all differences in one structured list. Analyze changes and merge cells, rows and columns between compared excel files directly from this list. Difference Explorer gives you clear answer - what actually was modified in the workbook.Rich Set of Options
Ignore Hidden Rows and Hidden Columns. Select data to be compared. Display Cell Difference. Highlight cells with color when merging. Command line options. xlCompare has many options you can use to achieve the best comparison results.How you can use xlCompare to compare two Excel files?
We've compared two price lists in the XLSX format to introduce you primary xlCompare features and options.
Spend a few seconds to see how xlCompare works
Companies that trust our software
With Excel Compare you move your productivity to the highest level. This tool makes excel file comparison easy and quick.
If you value your time, you will make the choice!
xlCompare Product News
08/24/22
Trace Precedents in Excel worksheets using xlCompare. Alternative way to get list of precedents in your Excel model.
08/07/22
How to evaluate formula values in Excel files using xlCompare. Additional feature you can use for free to debug your models. Perfect replacement for standard Evaluate Formula tool in Excel.
08/04/22
Spreadsheet Tools established partnership with HULINKS Inc. to
distribute xlCompare (Excel Diffツール) on the Japanese market.
「Spreadsheet Tools社と素晴らしいパートナー契約ができたことをうれしく思います。xlCompareは当社のドキュメントソリューションに貢献してくれるでしょう」
株式会社ヒューリンクス 常務執行役員 若林 登
[プレスリリース] ウクライナ Spreadsheet Tools 社との販売バートナーシップ契約締結について
www.hulinks.co.jp/info/202208_pr_xlcompare
07/31/22
Major update 10.7 was released!
We suggest you to upgrade your xlCompare to the most recent version. This update is free for all registered customers.
07/30/22
Let's talk about Excel Diff Tools.
Why do you need xlCompare?
xlCompare saves your working time, spend to comparing Excel files. Time is valuable resource in the modern business processes.
Fast and efficient tool to compare Excel files
Compare large Excel files within seconds with a maximum accuracy. Get accurate and easy to understand comparison report.Merge multiple excel sheets into one
Consolidate contents of multiple excel files(sheets) into one, excluding existing rows. Optionally highlight inserted rows with color.Compare worksheets by key columns
Get the best comparison results with primary key columns and rows (table heading) defined on the worksheet
Compare three XLSX\XLSM\CSV files
Use xlCompare as a xlsx diff checker, that offers 3-way comparison and merge option for excel files. Compare 3 Excel files for differences.
Check your worksheet for unique and updated rows
Your colleague inserted some rows into common worksheet. No problems. xlCompare will point you to rows that were inserted or deleted!
Fast and efficient xl comparator
xlCompare gives you incredible performance on the large excel files. Having 2 worksheets with millions of rows? xlCompare compares them and gives you best diff report in several seconds.
Compare two Excel files from command line
All commands that are present in the xl comparator are available from the command line. You can compare and merge Excel files in a batch mode.
Find duplicates in Excel files
Remove duplicate rows, remove leading and trailing spaces, split and join columns, convert text to numbers, ... xl comparator gives you 10+ commands to simplify your work with Excel files
Highlight differences on the Excel worksheets with xl comparator
We compare and consolidate all types of excel files:
- Accounting and Cashflow Statements
- Business Templates
- Data Analysis Spreadsheets and Financials Models
- Budget, Loan and other Calculators
- Invoices and Price lists
- To Do lists and Checklists
- Application Logs, CSV and Text Files (Tab, Comma, Space and custom delimited)
- and more ...
Available in the following languages:
Diff Viewer for Version Control Applications
Configure xlCompare in any SVN or GIT system using command line mode as an
integrated diff viewer tool for Excel documents, CSV and TXT(text) files.
Compare three Excel files for differences.
10000+ satisfied customers
What our customers say about xlCompare?
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, XY Spreadsheet Solutions
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
The only tool I've found
XLCompare has been able to handle our files very well. XLCompare was the only tool I have found able to handle these files at all. And with your company's very fast responses and fixes to the problems that I have identified along the way, we have been very happy with XLCompare and it capabilities.
Robert B.
The best excel comparison software!
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
Are you still looking for differences in Excel files manually?
Boost your productivity with Excel Compare!
xlCompare saves you a lot of time. In a few seconds, you'll get a comprehensive comparison report with minimum effort.
Quality
Our purpose - Give you a fast and robust Excel comparison utility. Our Excel Diff Tool was tested on millions of Excel worksheets around the world in different industries, from Game Development to Medicine.
Power
Based on the Spreadsheet Core engine, our tool works faster than the Excel application and gives us the ability to implement any feature. This is not possible in the regular Excel-based solution.
Efficiency
xlCompare saves you time and money. It helps you to put your focus on the business tasks, while our xl comparator is doing spreadsheet comparison job for you.
Visual Representation of the Comparison Results
A color coded report points you to modifications found by xlCompare between your Excel worksheets. You see exactly what was changed and where the inserted rows and columns are.
Detailed Information
The tooltip window on the changed cell shows detailed information about modifications. Get all difference details directly when browsing your worksheet.
Native View
Display original and modified value (or difference) in the same cell. This would be an optional feature which can greatly simplify your work with a comparison report.
Merge Icons
Select a range of cells you need and merge it into other worksheets in a single click. You can copy and move inserted rows between your worksheets.
Detailed and Complete Comparison Summary
The Difference Explorer Window displays all found changes
They are grouped by worksheets and rows\columns
Complete List of Differences
The Difference Explorer gives a normal and easy way to browse all differences found between workbooks.
Filter Modifications
Keep on screen only the records you need - inserted, changed or equal. Use this filter to extract updated cells from the worksheet.
Merge and Bulk Merge
Merge cells one-by-one or merge all changes in one click. Move data between your worksheets in one click.
Compare and Update Excel Tables
Process large Excel tables within seconds with a maximum accuracy.
Excel Compare has a database comparison algorithms, which performs this task quickly and efficiently.
Inserted Rows\Columns
xlCompare detects new rows and columns in the worksheet and highlights them with background color. The colored pointers on the scrollbars help you to locate updated and inserted data in your Excel file.
Check for Duplicates
Keep your database up to date. Find and remove duplicates and redundant records. With xlCompare, you can find, highlight and remove, all duplicate rows with minimum efforts. Duplicates can be found by key, by full row data, or by criteria.
Compare "Mixed" Data
A rich set of options gives you a way to significantly reduce comparison noise. Compare strings with numbers, ignore characters, apply comparison accuracy, ignore hidden rows and columns and more ...
Compare Visual Basic Code and Forms
A complete comparison of the Visual Basic Projects. xlCompare does all comparison and merge operations needed for VBA developers.
Modified Code
xlCompare finds changes in the VBA Modules and displays them with color formatting.
Changed Forms and Controls
Finding modifications between Forms in an Excel Worksheet is the most complex task. It won't be in in other comparators.
xlCompare not only displays for you all Forms and Controls in the hierarchical tree view form, but also compares them and displays even minor changes between VBA Controls.
Merge Commands
Merge VBA Code and Form Controls in single click. Just select code lines and click on the check icon! In a few seconds you will resolve all merge conflicts in your VBA code.
xlCompare as a part of Version Control Applications
xlCompare is a Diff Viewer and Merge Tool for Source Control Systems.
Integrate it into a third-party application with a set of command line options, as well as a 2 and 3-Way Worksheet Comparison feature.
Compare Multiple Excel Files
3-Way comparison - Compare changes made by you and your co-worker in the same version of the workbook.
Resolve Conflicts
One of the most important version control tasks is to resolve conflicts between different versions of the same file.
xlCompare compares 3 versions of the Excel workbook - YOURS, THE BASE and THEIRS. It gives you comprehensive reports of the changes made, with ability to merge conflicts.
Diff Viewer for SVN\GIT Tools
xlCompare supports rich set of the command line options, to be integrated into the SVN\GIT environment as Diff Viewer and Merge Tool.
Highlight Conflicts
All differences are marked with colors exactly in the worksheet views. Conflicts will have a red color to attract your attention, among other diffs.
Aligned Rows
Inserted\Deleted rows are virtually inserted into same place in the corresponding workbook. This gives a normal look for the modified worksheets.
Detailed Report
Put the cursor over the colored cell to get a detailed report about the changes made.
Analyze and Debug Calculations in Depth
xlCompare is more than the usual workbook comparing program. This tool has features creating productivity in various aspects.
Evaluate Formula
Divide the formula into elementary parts. Display them in the hierarchical tree form. It's the most suitable way for recursive analysation.
Where the Value Came From
Review the list of calculation errors (#N\A, #VALUE, #DIV\0) and find out where the error came from. Expand all formula calculations and get source of the unexpected result.
Trace Precedents
A drill-down trace of the formula dependencies in depth. Go through the formula precedents to find its input value. Check if 2 cells are dependent from one to another.
Merge multiple Excel files into one
Drop files you are going to merge into xlCompare
Open your Excel files in xlCompare, to start merging you files with excel diff tool. This is very simple step. Excel File Compare has a number of commands to open Excel files. We recommend to drop your files into the xlCompare application.
This way is the most fast and simple.
Define Primary Keys in your Excel File
Usually this command (merge excel files into one) is applied to excel files with database structure. Like price lists, invoices, various tables stored in the Excel Files.
For this type of data Primary Key is a basis. Accurate comparison results are not possible without defined key columns and key rows on the worksheet.
Excel File Compare Tool (xlCompare) works flexible with primary keys and accepts complex key that consists of several columns and contains duplicated values.
Use the Merge button on the Home tab
After files are opened and primary keys are defined, excel diff tool has all needed information to consolidated excel files into one. Go to the Home tab on the Ribbon and press the Merge button to merge all different rows and updated cells from the FILE2 into the FILE1 (right to left).
Get your Excel Files merged!
Simplicity is one of the principles of the our excel diff tool xlCompare. We would like to give you powerful and best excel file compare tool, but it should be as easy to use as possible. The most actions you can do in Excel File Compare are done in a few clicks only.
Merge all sheets into one in Excel file
Open your excel file in the Excel File Compare Tool
We've described how to open excel file in xlCompare tool in the article above. So, just drop your excel file into the xl comparator (xlCompare) window.
Check the Primary Keys
Normally this step is optional. xlCompare has a number of algorithms to define the primary keys in your excel file. In most cases you need to look into them only.
However, if you have a complex data, or ID column is missed and primary key consists of the several columns - you may need to edit them using the Right Click Menu.
Open Merge Excel Sheets Wizard
Merge command on the Home tab on Ribbon opens Merge Excel Worksheets Wizard, if you have only one workbook opened in the excel file compare.
The Wizard has minimum fields to be filled. Just select worksheet that receives consolidated data and check the worksheets whose contents should be merged.
That's all. All other work is done by excel diff tool xlCompare. Complete the Wizard to get the results.
Get your worksheets consolidated!
As you see in a few clicks you are getting the consolidated worksheet. If you receive invoices, part lists, price lists or other tables splitted into smaller parts -
xlCompare is a best excel file compare tool to automate your work and increase your productivity.
xlCompare is an Ultimate Tool for Excel File Comparison
xlCompare Space on Quora!
We've created this space to publish useful information about xlCompare and discussing various tips and tricks. 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!
xlCompare will save your time and increase productivity!
xlCompare is a leading xl comparator solution that provides you powerful and efficient tool to compare excel files and CSV files.
Armed with this excel diff tool you will have following benefits:
This article on Quora clearly describes the advantages you are getting.
We give you more than excel spreadsheet comparison tool – we give you effectiveness.
There are online solutions that works with xlsx and csv files and checks Excel files for difference in values. Why do I need this xlsx diff tool? In the article below we’ve started this discussion.
We will be happy if you decide to share your feedback with us or with community on the Quora service.
F.A.Q. Options and Commands
What is Extended View?
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.
I need to see the Difference between changed values.
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.
Can I save the report I see in the Extended View?
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.
Does xlCompare find differences in formulas?
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 worksheet data
- Only constant cells
- Only calculated cells
- Only text of formula
- Only value of formula
- Combination of the options above
How to identify differences, found between my worksheets?
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.
Can I ignore hidden rows and columns?
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.
How to save the Comparison Report to present it to colleagues?
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:
- XLSX
- HTML
- Text
Or just copy it to clipboard and paste it into e-mail or another application.
I have a question regarding xlCompare
Please, describe your question or inquery in the form below. We will be happy to respond you!