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.

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:

Open this page to read the full article:

Open this page to read the full article:

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:

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: