xlCompare in the Action

Overview of our product will not be complete, if we miss how xlCompare works on the real examples. If you are looking for utility to compare and merge Excel files – probably you find your case here. Whoever you are - Excel User, Spreadsheet Professional or Developer, or you are using Excel for specific tasks – we find something useful for you in xlCompare.

This page is not completed. We continuously add new common cases here, so you can add a bookmark for this page in your browser. May be on your next visit there will be new useful information for you.

If situation you have is not described here – please, contact us using the form below. We'll analyze it and publish a solution on this page.

Compare two Excel Sheets for Differences

The most common situation. This is primary goal of xlCompare. If you are on this website - in 90% you are looking for a tool to compare your Excel files.

We’ve created 2 price lists to show you how xlCompare finds differences in them. Price list is just an example. Worksheet of any type could be on its place:

  • Accounting Statements
  • Contact Lists
  • Sales Reports
  • Financials Models
  • And more ...

Open this page to read the full article:

Open this page to read the full article:

Merge Several Excel Worksheets into One

Very often you need to combine several lists into one. Excel file is a good way to keep various tables and datasets. So, you need an efficient and robust way to merge them.

If data is relatively small – probably you don’t need a specific utility for this. But imagine a workbook with 50 sheets and 10000+ records in each one. No one can handle this amount of data manually. You should not only copy cells, but also check rows for modifications and conflicts.

Look how xlCompare does this work:

Report Changes Between two Excel Files

You’ve received a file from your colleague, edited some formulas and need to report him your changes. How to do this quickly and effectively?

xlCompare gives you outlined Difference Report with structured list of changes. Page below shows how we’ve created Difference Report for the example with compared Price Lists.

Look how to create Diff Report and which options you have to export it:

I need Diff and Merge Utility for other use

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

Download Excel Compare

Download and install the latest up-to-date version of xlCompare. The download is a full-featured version.

Current Version: 10.3.0

Build Date: 12/1/2021

Start using Excel File Compare now!

Excel File Compare Home Tab on Ribbon

Filter Mathching Rows
Display only rows present in both excel files and exclude new (removed) rows
Filter Different Rows
Hide rows that have corresponding row on the other sheet. Display only different records on both sheets.
Update sheet with cells from other sheet (Merge)
Insert all different rows into other excel worksheet and update all modified cell values. In one click you can move million of rows!
Get Matching rows
Extract and save rows that has a corresponding row in other excel file.
Get Different rows
Save on the third worksheet rows that doesn't have a matching row on the correspondding sheet.
Mark Differences with Color
Permanently mark all changes you've found with background and text color to highlight them for future analyzis.
Get the Diff Report in PDF format
Create outlined report in the XLSX, HTML or PDF format. Save color formatting in the PDF file.

Display modified cells in the excel file compare tool

Extended View
Display original value and modified value in the same cell. Change this to display difference between values in the options.
Trending Arrows
Green and Red arrow icons indicate that value in this cell was increased or decreased. In addition to usual color formatting this gives you visual indication about tendency in the numerical values.

If you are still thinking if xlCompare is worth to try - please review long features list on the page below.

Questions & Answers

Can I use xlCompare to consolidate Excel Files?
Yes. xlCompare is not only Excel File Diff Viewer application. Utility has number of commands and options to combine several Excel worksheets into single one. Ability to update and merge Excel files is one of the primary features of the product. Use the Merge command on the Home tab on the Ribbon to update records in your Excel table with records from another one.
Which version should I choose, the 64-bit or 32-bit?
If you have 64-bit Windows - install 64-bit version of the xlCompare. With 64-bit version you can open larger workbooks and use full power of your 64-bit processor.
How does the 30-day trial work?
Once you decide to use xlCompare, you can run a 30-day free trial first. Including all the product features. This will help you decide which features are of the greatest value to you. Once the 30 day period is over, you will be asked to make your choice.
Do you offer discounts for students?
We offer student and non-profit discounts. Just open a private discussion with us, verify your status and we will provide you with a 25% discount on the regular price. We may ask you to confirm your status with documentation, so please get ready to verify that.

Version History

During 10+ years, our team has been working to provide for you a robust and quality software. It boosts your productivity and saves you time and money. Just look into our list of changes on the page below to imagine the amount of work done on the product.

32-bit Version

The most of the modern computers have 64-bit processors, which give you significantly more calculation power and other benefits. But if you have an old PC with 32-bit processor, please download xlCompare 32-bit using the link below.