Compare Excel files for differences
Check Excel worksheets for differences, merge and highlight changes
Find differences in
- cell values
- cell formulas
- array formulas
- defined names
- worksheet tables
- fill color
- text color
- font
- VBA Modules
- VBA Form Controls
- CSV files
Merge Excel files
- merge two Excel files into one
- merge two Excel sheets
- combine all sheets into one
- merge folders

15+ years on the market!
What xlCompare can do for you

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. xlCompare 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?
Companies that trust our software






xlCompare Product News
Why Use xlCompare?

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
Compare three XLSX\XLSM\CSV files
Check your worksheet for unique and updated rows
Fast and efficient xl comparator
Compare two Excel files from command line
Find duplicates in Excel files
Highlight differences on the Excel worksheets
- 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 ...
- English
- German
- Chinese
- Russian
10000+ satisfied customers
Boost your productivity with xlCompare!

Quality
Power
Efficiency
Visual Representation of the Comparison Results
Detailed Information
Native View
Merge Icons

Detailed and Complete Comparison Summary

Complete List of Differences
Filter Modifications
Merge and Bulk Merge
Compare and Update Excel Tables

Inserted Rows\Columns
Check for Duplicates
Compare "Mixed" Data
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
Changed Forms and Controls
Merge Commands
xlCompare as a part of Version Control Applications
Compare Multiple Excel Files
Resolve Conflicts
Diff Viewer for SVN\GIT Tools


Highlight Conflicts
Aligned Rows
Detailed Report
Analyze and Debug Calculations in Depth
Trace Dependents
Evaluate Formula
Where the Value Came From
Merge multiple Excel files into one
Merge all sheets into one in Excel file
xlCompare is an Ultimate Tool for Excel File Comparison
xlCompare Space on Quora!
xlCompare will save your time and increase productivity!
F.A.Q. Options and Commands
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 worksheet data
- Only constant cells
- Only calculated cells
- Only text of formula
- Only value of formula
- Combination of the options above
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:
- XLSX
- HTML
- Text
Or just copy it to clipboard and paste it into e-mail or another application.