Compares two Excel sheets for differences between the two versions and provides users a detailed overview of findings so they can analyze them
PerfectXL Compare is an intuitive software solution that was created especially for those who often work in Excel and want to review the changes that were made between two spreadsheets.
Compare Excel documents
PerfectXL Compare allows you to browse to the location of your two files (XLSX, XLSM, XLS or XLSB), or you can easily drag and drop them onto the main window. A handy feature is that your selected documents do not necessarily need to share the same format, so you can compare XLS and XLSX files without any issues.
The older document should be loaded in the left side, whereas the newer one should be added to the right panel. If you accidentally mixed them up, you can flip them with the press of a button.
After you selected the files, the app instantly displays information about them, such as file size, last modification date, last author, or workbook protection status.
Review differences in the spreadsheets
Once you have loaded the documents, you get a summary with the total number of differences (insertions, edits, and deletions) related to data, formula and structure. You can also review information regarding the number of worksheets in each document.
Moving on to analyzing the actual differences, you have the possibility to filter them if you are looking to locate a certain item.
All in all, PerfectXL Compare is of great help to all those who want to quickly review differences in their Excel documents, even if they do not have Excel installed on their PC. Also, it includes a so-called Legend in each relevant tab so you can easily interpret the data presented to you.
On the downside, only two documents are supported at a time, so if you want to compare several spreadsheets, you need to process them in pairs.