Excel Tools

PerfectXL Explore

Excel is incredible, but many important files are complex and difficult to grasp. Not with PerfectXL Explore! Our tool visually represents Excel models and gives you all the details you need to really understand them.

  • It’s fast & easy to use
  • Get detailed insights
  • Save frustration and time

Seeing is believing

Every Excel user struggles to understand unfamiliar, complicated Excel files. Our software, PerfectXL Explore, starts by visualizing the model. Then breaking down everything, including external references, formulas, tables, and even VBA code. Gain a complete understanding of even the most complex, unfamiliar Excel models in an instant.

Automobile by Edison // PerfectXL Spreadsheet Validation

Directly applicable

PerfectXL Explore is designed to be immediately applicable in your work with Excel, the tool is incredibly easy to use.

  • Install & begin using in a few clicks
  • Visualize your whole Excel model & individual objects
  • Gain deeper insight in formulas and references
  • Use alongside Excel to gain context & information

Gather information on pivot tables, VBA, defined names, external connections, and much more.

And you are in
good company

PerfectXL serves clients from different industries. The tool has proven its value to accountants, consultants and financial experts as well as professionals from high tech, energy, logistics and transport industries.

“As soon as PerfectXL becomes part of your routine, it becomes software that does exactly what you want it to do.”

  • It’s fast & easy to use
  • Get detailed insights
  • Save frustration and time

More articles related to PerfectXL Explore

On this page you will find a step-by-step walkthrough of the PerfectXL Explore Tool. This page will give you information on how you can use explore to gain a better understanding of complex Excel files.

This is the technical page for PerfectXL Explore. Here you will find information like system requirements, release notes, and answers to most questions about our software. If you have more questions please use the form at the bottom of the page.

In this video we’ll show you how to run a quick basic check of the input sources of your Excel files and how to determine if there is any unknown input. We’ll also show you a powerful way to visualize your spreadsheet’s information flow to help determine the function and dependability of each worksheet.

Garbage in, garbage out. So pay serious attention to cleaning your input data as it is the foundation of your spreadsheet and if possible, do it in such a way that it becomes an automated process for the next time you use the same spreadsheet.

Treat transferring a spreadsheet like you would treat the process of renting your house via Airbnb. Most people realize it will stay neater if you clean it first. Mess stimulates mess, and neatness stimulates neatness. Remember that in an average spreadsheet there will be 12 different users that have to use it after you! What do you think happens when this chain starts with a messy file?

Curious to see what your spreadsheet’s all about? PerfectXL Explore gives you a great starting point. An overview of worksheets, input sources and potential risks are all part of our general spreadsheet characteristics section. It also gives you an insight into the amount of formulas used in your spreadsheet.

In this article we’ll discuss some good practices that will help you with structuring your Excel files.

The use of external links in Excel is very powerful. It’s a very efficient way to populate your Excel models. But what happens when Excel can’t find your source anymore? How do you effectively track the links and references you’ve introduced?

Be honest with yourself, how much time does it take you to spit through an Excel file? The opportunities in Excel are endless but this comes with a downside. PerfectXL has the solution. Starting now you can gain a better understanding of your spreadsheets, to help you in improving, documenting, and cleaning up your files. Here are 9 tasks that PerfectXL Explore makes easy.

When we read a book or a report or a website, we read from top to bottom and from left to right. Keep this in mind when you create an Excel file. Try your best to follow that structure both within each worksheet and between them. We advise you to distinguish separate input & output sheets as well as sheets for calculations, documentation and dashboards.

Understanding the workings of a spreadsheet is key to correctly interpreting its results. Spreadsheet visualization is an essential feature of PerfectXL Explore. It allows you to create a graphical model of the general flow of information, which also shows of risks, input & output and data & formula flows.

Numbers without meaning are worthless. Excel is a program for numbers, but it is only useful if it is clear to the reader or user what these numbers mean. So, make sure that you provide textual information for all data and formulas, let’s call these pieces of text information labels.

Named Ranges make it clear to users what value is being referred to and it allows you to update it globally if it changes. Only one question remains… Where is my Named Range used?

How can PerfectXL help you?

Share your questions about our products. We will be
in touch with you in the next 48 hours.

Other PerfectXL solutions

PerfectXL Risk Eliminator

Excel is only as reliable as its user, and human error is sadly only predictable in that it occurs often. Our Risk elimination tool helps you find mistakes and gives improvement suggestions through more than 70 risk findings.

Read more here

PerfectXL Highlighter

The PerfectXL Highlighter is what’s been missing from Excel. Understanding your Excel files has never been this easy.

Read more here