A data table is a simple table that lives inside n8n: your workflows can save rows to it and read them back, with no separate database to set up. This guide shows how to create a data table in n8n, add columns of the right type and add your first row.
The example is a small Tasks table with three columns: task (text), done (true or false) and due (a date). By the end it holds one task.
Cost: free. Data tables are part of n8n’s free Community Edition.
Every screen on this page is real, from n8n 2 running in Docker on macOS.
Step 1: Open New Data Table
Click + at the top of the left sidebar, then New data table.

Step 2: Name the Table
Type a name, here Tasks. Leave From scratch selected: you add the columns yourself. (Import CSV builds the table from a CSV file instead.) Click Create.

n8n opens the empty table. It already has three columns that n8n fills in for you: id, createdAt and updatedAt.
Step 3: Add the Columns
Click Add Column at the top right. Type the name task, keep the type string and click Add Column.

Add two more columns the same way, choosing the type from the Type list each time:
- done, type boolean: true or false.
- due, type datetime: a date and time.
The list has four types. number is the fourth, for amounts and counts.

The table now has your three columns, each with an icon for its type.

Step 4: Add Your First Row
Click Add Row. A new row appears with the task cell ready for typing. Type Buy printer paper and press Enter.

Double-click the done cell to show its checkbox. Press Space to tick it (true), and again to untick it (false). This task isn’t done yet, so leave it unticked and press Enter.
Double-click the due cell, pick a date in the calendar and click OK.

n8n saves each cell as soon as you finish it; reload the page and the row is still there.

Step 5: Find Your Data Tables
To come back to a table later, click Personal in the left sidebar (point at an icon to see its name), then the Data tables tab. Each table shows its size and number of columns; click it to open it.

Clean Up
The Tasks table was only an example. To delete a table, click ⋯ on its card in the Data tables tab, then Delete, and confirm with Delete.
Warning: deleting a data table removes all its rows, and n8n says the action cannot be undone.

Common Mistakes
| Mistake | What happens | Do this instead |
|---|---|---|
| Leaving a boolean cell untouched | A new row starts empty: the cell shows Null, not false | Tick and untick it to store false |
FAQ
How much data can n8n data tables hold?
By default, all the data tables in one n8n share a 200 MiB limit, and n8n warns you at 80%. On self-hosted n8n you can change the limit with the N8N_DATA_TABLES_MAX_SIZE_BYTES setting (n8n’s data tables guide (opens in a new tab)).
Can I import a spreadsheet into a data table?
Yes, as a CSV file: choose Import CSV when you create the table, or use Import CSV in the table’s ⋯ menu. The same menu has Download CSV to export it.
Who can see my data table?
Everyone in the same project, and n8n’s owner and admins, who can see every user’s tables (n8n’s docs (opens in a new tab)).
How does a workflow use a data table?
With the Data Table node (opens in a new tab), which can insert, get, update, upsert and delete rows. Part 2 of the n8n Tutorial saves every message from a website contact form into a data table this way.
Conclusion
To create a data table in n8n, name it, add a column for each piece of information with the right type, and add rows by hand or from a workflow. It keeps the data your workflows share inside n8n, with no database to run.
Additional Resources
- Data tables (opens in a new tab) (n8n docs)
- Data Table node (opens in a new tab) (n8n docs)
Related
- n8n Tutorial — Part 2: Build Your First n8n Workflow
- How to Publish a Workflow in n8n
- How to Install n8n with Docker
- n8n Tutorial — Part 1: What Is n8n? Workflow Automation Explained
n8n and other names mentioned are trademarks of their respective owners. JD Bots isn’t affiliated with or endorsed by n8n GmbH.
0 comments