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)
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.
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.
The Default View instantly visualizes how worksheets interrelate (blue), which external sources are used (yellow) and which worksheets are hidden (grey and white).
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.
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.
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.
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.
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.