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.
- Fast comparison engine
- Simple user interface
- Correct, reliable results
To compare two Excel sheets, you can select or drag and drop the files you want to analyze into the program. Most analysis takes just one second!
- Drag and drop two files, these will be automatically sorted, newest right, older version left
- Drag and drop one file at a time, please drag the newer version to the right (you can always flip the files once they are selected)
- Click on one of the spaces to use explorer to find the files you want to select
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 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 items were directly affected by this difference, whether it was a insertion, edit, or deletion. You can adjust this list with a variety of filters.
Our tool also offers an export of differences back to Excel, some users even prefer to work in this file. The export can also be incredibly useful for keeping a log of changes, for sharing with colleagues or people you’re collaborating with, or simply to add to your Excel file to give any user information about changes to the model.