How Excel File Compare Tool works

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 Diffs 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!