On this page you will find a step-by-step walkthrough of the PerfectXL Compare Tool. We will show you how to successfully compare two Excel sheets with descriptions, screenshots and explanations as to how the functionality could be used in your own workplace.
We also offer a more technical explanation, a more indepth general help, and you can always contact us.
To compare two Excel sheets, you can upload or drag and drop the files you want to analyze into the program. Most analysis takes just one second!
The first overview you see is summary, this has metadata, and an overview of the aggregated differences found between the spreadsheets.
In this view you see the worksheets, this helps you quickly hone in on the different changed areas, and let’s you see which worksheets have been changed.
This overview shows you all differences found between the spreadsheets, you can filter, change the view, and see more details for each difference.
Summary of the spreadsheet comparison
The summary page is simply an overview of all the changes in your spreadsheet, split into different categories. Here you can dive into specific types of differences, so you can focus on editing just the data, formulas or structure. It is helpful for separating and categorizing differences, but the main purpose of this page is to give you an idea of how much has changed between the two versions of the spreadsheet.
The worksheet overview shows you which worksheets have been deleted, moved, inserted, hidden, renamed, and protected. You can also see where the changes in your spreadsheet took place, specifically which sheets have been changed and in which ways. This lets you zoom in specifically on the worksheets where the differences were found.
The all differences overview shows you all the differences found between the two versions of the spreadsheet. At the end of each differences you can see how many cells were directly affected by this difference, whether it was a insertion, edit, or deletion. You can adjust this list with a variety of filters.
The individual differences can be viewed in line, or side by side, whichever you prefer. Just adjust the filter at the top of the page.