How to Build a Database with Tables

Step-by-step guide

1

Create your first table

From the sidebar, open Tables and click New table, or start from a ready-made structure in the Table Templates gallery. A new table opens with a few starter columns and an empty grid. Give it a name at the top so you can find it later. The grid is your workspace: every row is a record and every column is a field.

2

Design your columns

Click the plus button at the end of the column headers to add a field, then choose its type: text, long text, number, single select, multi-select, date, checkbox, URL, email, or phone. Single and multi-select fields let you define color-coded options, which is what powers the kanban and chart views later. Rename a column by clicking its header. Set up the fields your data needs, for example a Name, a Status select, an Owner, and a Due date.

3

Add and edit records

Click into any cell to start typing, or use New record to add a row. Cells are typed, so a date column opens a date picker, a select column shows your colored options, and a checkbox toggles on click. Edits save automatically as you go. Paste a block of rows from a spreadsheet to bulk-fill, or import a CSV to bring an existing dataset in.

4

Switch between grid, kanban, timeline, and chart

The same records can be viewed in different ways. Use the view tabs at the top of the table to add a Kanban board (grouped by a select column), a Timeline (laid out by date columns), or a Chart (counts and sums by category). Each view is saved on the table, so you can jump between a spreadsheet grid and a visual board without duplicating any data.

Tips

• Use a single-select Status column with colored options to unlock the kanban and chart views
• Date columns power the timeline view, so add a start and due date for a Gantt-style layout
• Paste directly from a spreadsheet or import a CSV to fill a table fast
• Give each table a clear name and icon so it's easy to spot in your Tables list
• Start from a Table Template if you want a ready-made structure for projects, CRM, or content

Frequently asked questions

Related guides