Compare Two Excel Files
Comparison report for two Excel files with highlighted differences (click 
for details)
Complete list of changes found between 2 Excel files (click for details)
No formulas
●
No Conditional Formatting
●
No Power Query
●
No manual work
Highlight Differences Between Two Excel Files Step-by-Step
Manually finding differences between Excel files requires knowledge of Excel features such as Conditional Formatting, formulas, and Power Query. It also carries a significant risk of errors.
Below, we'll show you how to compare two Excel files automatically with xlCompare and generate a clear comparison report.
1. Open Two Excel Files
To open two files in xlCompare, simply launch the application and drag and drop your files from File Explorer into the xlCompare window.
xlCompare has a familiar, Microsoft Excel-like interface, making it easy and intuitive to work with your spreadsheet data.
2. Click the Compare Files Button
To see the comparison results, simply click the Compare Files button in the main menu. xlCompare will give you the option to review and adjust the comparison settings, but you can skip this step and proceed with the default settings.
3. View the Comparison Report
The comparison results are now displayed on the screen. xlCompare compares all worksheets in both Excel files and highlights every difference with color.
xlCompare detects changes in cell values, formulas, fonts, text and background colors, other cell formatting properties, and comments.
What Differences Can xlCompare Find?
Changed Cells
Cells with changed values are highlighted with an orange background. Use the Changed Value and Display Difference commands to display the changed value together with the original value.
Changed Formulas
All modified formulas are included in the list of differences. To display only formulas that have changed, click Formulas in the Legend above the list of differences.
Hover over a cell, and xlCompare will highlight the changes within the formula text, making it easy to see exactly what was modified.
Inserted and Removed Rows
Rows that are missing from the other file are highlighted with color. In the left file, xlCompare highlights these rows with a green background, while in the right file they are highlighted with a red background.
You can customize these colors in the application settings.
Inserted and Removed Columns
Columns that are missing from the left file are highlighted in red. You can customize the highlight color in the xlCompare settings.
To hide all inserted and deleted columns, click Equal Columns in the menu. xlCompare will hide the unmatched columns and align the corresponding cells side by side in the comparison report.
Changed Cell Formatting
In addition to cell values and formulas, xlCompare compares all cell formatting properties, including fonts, text and fill colors, number formats, text alignment, and borders. You can choose which formatting properties to include or exclude in the xlCompare Comparison Settings.
Every cell with modified formatting appears in the list of differences. The Legend shows the total number of formatting changes found. Click Style in the Legend to filter the results and display only changes to cell formatting.
For detailed information about a formatting change, hover over the cell. A tooltip will show exactly which style properties have changed.
In this example, the font size and text color were changed, and bold formatting was applied to the cell.
Compare Formulas, Not Just Values
xlCompare analyzes the structure of each formula to detect only actual changes. Instead of treating a formula as a simple text string, xlCompare breaks it down into individual expressions and compares each part separately.
This approach helps eliminate false differences caused by inserted or deleted rows and columns. Inserting a new row - or making any other change that shifts cell references - can alter the text of many formulas even though their underlying calculations remain unchanged.
A cell-by-cell comparison such as FORMULATEXT(Sheet1!A1)=FORMULATEXT(Sheet2!A1) would report every formula that references a shifted range as different.
xlCompare uses a more intelligent formula comparison algorithm that takes these structural changes into account. As a result, it can distinguish reference changes caused by row or column shifts from actual edits to formulas and highlight only the formulas whose logic has genuinely changed.
Can I Compare Calculated Values Instead of Formula Text?
Yes. Disable formula comparison in the comparison settings, and xlCompare will compare only the calculated cell values instead of the formula text. You can also do the opposite: disable calculated value comparison and compare only the formulas.
Compare Two Excel Sheets by Key Columns
xlCompare natively supports Composite Keys (using two or more columns together as a single identifier). For example, if you have a staff roster, "John" or "Smith" alone isn't unique. You can select both the "First Name" and "Last Name" columns as keys. xlCompare combines these columns into a composite key to identify the corresponding row in the other sheet.
Who Uses xlCompare?
xlCompare is designed for anyone who works with Microsoft Excel and needs to compare spreadsheets.
It is equally useful for software developers and system administrators comparing large datasets exported from databases or analyzing log files, as well as financial analysts, managers, and accountants working with spreadsheets of any size, including complex models containing formulas and macros.
Whether you need to identify differences between two simple tables or analyze large, complex Excel workbooks, xlCompare provides the tools to get the job done quickly and efficiently.
xlCompare is designed to be easy to use, regardless of your experience with Microsoft Excel. Its simple, intuitive interface makes it easy to get started, and most operations can be completed in just a few clicks.
Compare complete files locally on your PC, including all worksheets, formulas, formatting, rows, columns, and VBA code. Review and filter differences, export reports, transfer changes between files, or automate comparisons from the command line.
Most comparisons require no configuration, while advanced options remain available when you need precise control over the comparison.
17 Years on the Market
The story of xlCompare began in 2009 with the release of its first version as an Excel COM Add-in. Over the past 17 years, xlCompare has evolved significantly, growing from a simple Excel add-in into a standalone application with a comprehensive set of tools for comparing and merging Excel files.
We continue to develop and improve xlCompare, and we are grateful to every customer who has chosen and supported our product over the years.
Compare Excel Files for Free with xlCompare
You can use xlCompare to compare Excel and text files for free, with no time limits or restrictions on the number of times you launch the application.
For more advanced functionality, xlCompare offers a Professional edition. You can find the list of paid features and pricing information for xlCompare Professional on the Order page.
Download and Install xlCompare
Download xlCompare
12.05
Build Date:
Version:
Name:
Full Path:
Size:
Publisher:
Get xlCompare from the Microsoft Store
Looking for Microsoft Spreadsheet Compare?
Microsoft Spreadsheet Compare is included with selected editions of Microsoft Office. If you need to compare Excel files without Microsoft Excel, match rows by key columns, or merge changes between workbooks, explore xlCompare