Try now!

Validate your spreadsheet for free



Visualization

To understand how a spreadsheet works, you need to know about its structure. In the visualization of PerfectXL, you can reveal this structure easily yet very effectively. Arrows indicate how worksheets in your spreadsheet exchange information through formulas.

See the Structure in Your Spreadsheet

Choose the 'Visualization' button in the main navigation after uploading your spreadsheet, to visualize the internal structure of your spreadsheet. (Also read 'Validate the Internal Structure of your Spreadsheet' to learn about all the advantages of data visualization)

PerfectXL - See the structure in your spreadsheet

1. Use these buttons to go fullscreen or zoom in and out. You can also scroll to zoom.

2. Click on a worksheet to view it in detail.

Detailed Visualization of a Worksheet

After clicking on a worksheet in the visualization of your spreadsheet, you'll find another visualization of this specific worksheet and its relation(s) to other worksheets.

PerfectXL - Worksheet visualization

1. Back to the full visualization.

2. Place the cursor over a worksheet to see which other worksheets information is exchanged:

Black: formulas in this sheet refer to cells in the other sheet.

Purple: formulas in the other sheet use cells from this sheet.

Default View

The Default View instantly visualizes how worksheets interrelate (blue), which external sources are used (yellow) and which worksheets are hidden (grey and white).

PerfectXL - Visualization default view

Risks View

The Risks View colours the worksheets after the highest risk detected in the sheet. This could reveal, for instance, that the source of a relatively safe sheet is actually quite risky. See the Risks & Improve page for all risk details and information about the various types of risk.

Tutorial Visualization - Risks View

Input/Output View

A good Excel spreadsheet clearly distinguishes between input-, calculation- and output sheets. To which extend this distinction has been maintained becomes clear in the Input/Output View of the visualization. Distinctive colors and arrows help to show precisely how information flows through the spreadsheet.

PerfectXL- Visualization input/output view

Data Count & Formulas

Where and how much information is exchanged between worksheets? In the Data Count & Formulas view, worksheets are colored according to the amount of information (=non-empty cells) they contain. How much information is relatively exchanged is indicated by the numbers and arrow thickness.

PerfectXL - Visualization Data Count & Formulas

Occasionally you might come across a worksheet relation you did not expect, such as an input sheet with references to an output sheet. In this case, it is quite useful to see where you can find the relevant formulas. These too can be found in the Data Count & Formulas visualization.

PerfectXL - Visualization Data Count & Formulas

Blue circles indicate the number of formulas between two worksheets. Click to reveal the formulas that constitute the connection.

Click on a formula to inspect it more thoroughly. This brings you to the Formula Breakdown.