Balance or Scale // PerfectXL Spreadsheet Validation
PerfectXL Compare

Walkthrough

On this page you will find a step-by-step walkthrough of the PerfectXL Compare tool. Here we 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

Getting started

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!

 

Getting started with PerfectXL Compare

  • 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

The summary of a spreadsheet comparison in PerfectXL Compare

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.

Worksheets

Comparing the differences in worksheets between two Excel files // PerfectXL Compare

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.

Differences

Walkthrough PerfectXL Compare : All differences between two Excel files

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.

Excel Export

Export results to Excel // Walkthrough PerfectXL Compare

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.

  • Fast comparison engine
  • Simple user interface
  • Correct, reliable results

Read more about comparing Excel files

Our software came to existence though a combination of passions for Excel, computer science, and board games.

This is the technical page for PerfectXL Compare. Here you will find information like system requirements, release notes, and answers to most questions about our software.

On this page you will find a summation which aims to show the relevance and application of a compare tool based on the user tests we did while developing our spreadsheet comparison tool.

We realize there are alternative solutions available in the realm of spreadsheet comparison, but PerfectXL Compare is in a different league. Below you will find a feature comparison with some of the market leaders in spreadsheet comparison.

Many nightmares have arisen because of confusion about the correct file versions of Excel documents. Learn more about version management.

What separates the great spreadsheets from the rest, is documentation! This will help future users of the spreadsheets to really understand your work.

How can PerfectXL help you?

Share your questions with us, we are more than happy to help you. We will get back to you within 48 hours.