Compare Excel files for differences
Find all differences in Excel (files) worksheets, highlight changes and merge cells
Compare Excel Files (worksheets)
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©
How xlCompare can help you to compare Excel files for differences
Find Changed CellsxlCompare looks into your worksheets for changed cells and gives you a colored report, with highlighted changed cells and inserted\deleted rows.
Find Unique RowsKeep 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 FormulasCheck 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 ReportAll 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 DuplicatesGet 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 AlgorithmsDepending 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 ChangesEasy-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 ListBrowse 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 OptionsIgnore 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 do you need xlCompare?
Fast and efficient tool to compare Excel filesCompare large Excel files within seconds with a maximum accuracy. Get accurate and easy to understand comparison report.
Merge multiple excel sheets into oneConsolidate 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 with xl comparator
- 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
10000+ satisfied customers
Boost your productivity with Excel Compare!
Visual Representation of the Comparison Results
Detailed and Complete Comparison Summary
Complete List of Differences
Merge and Bulk Merge
Compare and Update Excel Tables
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.
Changed Forms and Controls
xlCompare as a part of Version Control Applications
Compare Multiple Excel Files
Diff Viewer for SVN\GIT Tools
Analyze and Debug Calculations in Depth
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:
Or just copy it to clipboard and paste it into e-mail or another application.