Data Tables

Data Tables bring spreadsheet-like functionality directly into your flowcharts. Add structured data with typed cells, formulas, filtering, conditional formatting, and CSV import — all embedded as a node on your canvas.

Creating a Data Table

In the flowchart editor, open the Node Palette and drag a Data Table node onto the canvas. You can also use the toolbar's “Add Data Table” button.

A creation modal lets you set the initial number of rows and columns, and choose column types before the table is placed.

Cell Types

Text

Plain text content — the default cell type.

Number

Numeric values with configurable number formats.

Currency

Monetary values with locale-aware formatting ($, €, etc.).

Date

Date values with a date picker for easy selection.

Checkbox

Boolean toggle — great for status columns.

Select

Dropdown with predefined options and color tags.

URL

Clickable links that open in a new tab.

Formulas

Start any cell with = to enter a formula. A formula helper panel shows available functions as you type.

SUM=SUM(A1:A10)

Add up a range of cells

AVG=AVG(B1:B5)

Calculate the average

COUNT=COUNT(C1:C20)

Count non-empty cells

MIN / MAX=MIN(D1:D10)

Find the smallest or largest value

IF=IF(A1>100,"Yes","No")

Conditional logic

VLOOKUP=VLOOKUP(E1,A:B,2)

Look up a value in another column

CONCAT=CONCAT(A1," ",B1)

Join text from multiple cells

ROUND=ROUND(A1,2)

Round to specified decimal places

Filtering & Sorting

Column Filters

Click the filter icon in any column header to filter rows. Supports text contains, equals, greater/less than, date ranges, and checkbox state filters.

Sorting

Click a column header to sort ascending, click again for descending, and a third time to clear. Works with all cell types.

Find & Replace

Use ⌘/Ctrl + F within a selected table to open find & replace. Supports case-sensitive search and regex.

Conditional Formatting

Apply visual rules to cells based on their values. Right-click a column header → Conditional Formatting to set rules like:

Highlight cells greater than / less than a value
Color-code based on text content (e.g., "Complete" = green)
Data bars that fill based on numeric value
Icon sets (arrows, dots) for visual indicators

CSV Import

Import data from CSV files. Click the Import CSV button in the table header to upload a file. The importer auto-detects column types and lets you preview before confirming.

Supported delimiters: comma, semicolon, tab. UTF-8 encoding recommended.

Status bar: When you select cells, a status bar at the bottom shows SUM, AVG, COUNT, MIN, and MAX of the selection in real-time.
Was this article helpful?

Related Articles