Skip to main content
0 reactions

How to Create a Data Table in n8n

Card titled How to Create a Data Table in n8n, labelled n8n Tutorial how-to, with a small table whose columns are task, done and due and whose first row reads Buy printer paper, not done, due Nov 28.

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.

The menu under the plus button at the top of the n8n sidebar, listing New workflow, New agent, New credential, New folder, New data table, New project and New AI chat.
Click +, 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.

The Create new data table dialog with Tasks typed as the data table name and From scratch selected instead of Import CSV.
Name the table and keep From scratch.

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.

The Add Column form with task typed as the name and string chosen as the type, above an Add Column button.
The task column, type string.

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 Type list of the Add Column form open, showing the four column types: string, number, boolean and datetime.
Four types: string, number, boolean and datetime.

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

The empty Tasks data table with the columns id, task, done and due, each with an icon for its type, and the message No rows.
The three new columns, still with no rows.

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.

A new row in the Tasks table with Buy printer paper typed into the open task cell, while done and due are still empty.
Type the task 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.

The due cell open with a calendar for November 2026 below it, with Now and OK buttons, next to the task Buy printer paper and an unticked done box.
Pick the date and click OK.

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

The Tasks table with one row: task Buy printer paper, done unticked, and due 2026-11-28T00:00:00.000+05:30.
The first row, saved.

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.

The Personal page in n8n with the Data tables tab open, showing the Tasks table card with 0MB, 4 columns, last updated just now.
Your tables live in the Data tables tab.

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.

The Delete data table dialog asking whether to delete the data table Tasks and saying the action cannot be undone, with Cancel and Delete buttons.
Confirm with Delete.

Common Mistakes

MistakeWhat happensDo this instead
Leaving a boolean cell untouchedA new row starts empty: the cell shows Null, not falseTick 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

n8n and other names mentioned are trademarks of their respective owners. JD Bots isn’t affiliated with or endorsed by n8n GmbH.

0 comments