| id | px | py | pz | color | pscale | rotation |
|---|---|---|---|---|---|---|
| 0 | 100 | 0 | 0 | #ff0000 | 1 | 0 |
| 1 | 92.38 | 38.26 | 0 | #ff0000 | 1 | 22.5 |
| 2 | 70.71 | 70.71 | 0 | #ff0000 | 1 | 45 |
| 3 | 38.26 | 92.38 | 0 | #ff0000 | 1 | 67.5 |
Spreadsheet gives you a direct look at how data is flowing and changing through nodegraph, how data changes after going through specific node. While Canvas shows you the visual result, Spreadsheet shows you the numbers and attributes that define it.
This can be used as a debugging tool. If a shape isn’t appearing or an effect looks wrong, the Spreadsheet will often tell you why it’s like that, possibly due to a missing attribute, a NaN value, or something else.
Accessing spreadsheet
- Shortcut: Shift + S
- Nodegraph: In the Nodegraph menubar, View → Toggle spreadsheet.
View modes
Points mode
This is the default view. It lists every single point in the geometry.
- Position:
px,py,pz - Attributes:
pscale,rotation,color,alpha, etc. - Vectors: Normals (
nx,ny,nz) and Tangents (tx,ty,tz). - etc…
If you use a Scatter node to generate 50 points, this view will show 50 rows.
Shapes mode
This view lists the high-level objects. Use this to inspect:
- Transforms:
tx,ty,sx,sy,rot(World space transforms) - Properties:
closed,opacity,blur, etc. - Metadata: Group memberships, layer types, and IDs.
- etc…
If your graph contains 50 scattered points but they act as a single “Point Cloud” object type, this view will show just 1 row.
Data flow analysis
Sometimes seeing the final value isn’t enough and you need to know how it got there. Data flow tool allows to trace the history of a specific point or shape back through the graph.
- Select any row in the spreadsheet.
- Click icon that appears in the toolbar.
This opens a dialog showing every node that modified that specific nide, highlighting exactly which values changed at each step up to currently selected node.
- Green values: indicate the new value after the node processed the item.
- Red strikethough: values indicate what the value was before the node changed it.
Tip: You can use search bar at the top of opened dialog to filter steps by node name (label).
Filtering and sorting
When working with thousands of points or tens of shapes, finding specific data can be hard. Spreadsheet provides tools to narrow it down.
Sorting
Click any column header to sort colum by a corresponding attribute. Click again to toggle between ascending and descending order.
Filtering
Click the icon to open the filter menu.
- Filter rows: Enter a pattern to show only matching rows.
*box*matches any value containing “box”.>0.5matches numbers greater than 0.5.^0matches anything except 0 (useful for finding non-zero values).
- Search scope: Choose which columns to search in (e.g., only search
idorgroups). - Column visibility: Toggle the icon next to column names to hide irrelevant data and declutter the view.
Exporting data
You can copy the current view’s data to your clipboard as JSON by clicking the icon in the spreadsheet header. This is useful for external analysis or debugging.