Version comparison · Formerly PerfectXL Compare
Compare two Excel files and see what really changed
Formulas, values, structure and VBA: PerfectXL shows every real difference between two versions in seconds, without the noise of shifted rows and columns.
- Ignores side effects of inserted rows
- Compares VBA and macros
- FMI Awards category winner
Why it matters
Never work in the wrong Excel version again
| The headache | With PerfectXL |
|---|---|
| Checking two versions cell by cell | Every difference listed in seconds, with the location in both files |
| One inserted row makes the whole sheet look changed | Shifted content recognised, so only real edits show up |
| Renamed sheets and modules break the comparison | Worksheets and VBA modules matched, even after renaming |
| No record of what changed between versions | A complete change log exported to Excel for your audit trail |
How it works
How PerfectXL version comparison works
From two files to a clear list of changes, without opening either one side by side.
Add two versions
Drop in the old and the new file. Swap left and right in one click: additions, deletions and edits follow the order you choose.
Explore the differences
Start from the summary, then drill into worksheets, structure, cells, formulas and VBA. Filter by location, difference type or action, and jump to Excel.
Export the change log
Export every difference and its details to a new Excel file, ready for sign-off or your version control.
Key capabilities
The Excel comparison that shows what
really changed between two models
Summary
Clear summary of differences
Data, formula, structure and VBA changes at a glance, alongside file metadata such as author and age.
Structure
Structure changes visualized
Added, deleted, reordered, hidden or protected worksheets, connected so you can follow what moved.
Cells
Cell and formula edits side by side
Compare the left and right situation, or switch to a unified view that shows each change inline.
Smart mode
Shows real changes, hides side effects
Smart mode accounts for insertions and deletions. Switch to basic mode for a strict A1-to-A1 comparison.
VBA
VBA and macro differences
Forms, class, sheet and generic modules compared line by line, with a direct link to the VBA editor.
Export
Comparison export
Log every difference with its details in a new Excel file for a clean audit trail.
“The category winner, PerfectXL Compare, deploys an intuitive user interface to solve a problem wanting in comparison of versions of the same model.”
Jury, Financial Modeling Innovation Awards
Audit Extraordinaire category
Questions about PerfectXL Compare
Version comparison (PerfectXL Compare) FAQ
Something else? Ask us directly. A real specialist answers.
Add both versions to PerfectXL. Within seconds you get a summary of every difference in data, formulas, structure and VBA. Drill into any change, jump to it in Excel, or export the full list.
Yes. Version comparison is the capability you may know as PerfectXL Compare. It works the same way and will soon be part of a unified PerfectXL tool.
No. Smart mode recognises content that shifted because of insertions or deletions and only reports real changes. Basic mode compares cell by cell when you need it.
Yes. Forms, class modules, sheet modules and generic modules are compared line by line, and renamed modules are matched automatically.
Yes. Export every difference and its details to a new Excel file to document changes or support version control.
Book a demo. We’ll compare two versions of your own model and help you find the best pricing option.
Compare two versions of your own model
Bring an old and a new version. We’ll show you every real change in minutes and answer your questions.
- We use a model of your choice
- Pricing for you or your whole team
- Help with roll-out, from one laptop to company-wide