Help center

Bases

Bases stores your information in tables with typed columns, like a smart spreadsheet. Each column has a type (text, number, date, select, formula, image, links between tables and much more), and you view the same rows in several ways: Table, Gallery, Kanban, List, Calendar, Chart or Analysis — and you can save each arrangement as a named view.

Core concepts

A table is a set of rows (records) and columns (fields). Each column has a type that defines what it accepts and how it appears: a number sums and averages, a date opens a calendar, a select shows colored labels, a reference links the row to a record elsewhere. The same rows can be displayed in different ways through views, without duplicating any data.

The same data is never copied between views. Table, Kanban and Chart are just distinct ways of looking at the same rows; editing in one is reflected in all of them.

Organize your tables

The module opens on an overview of all your tables, with search and per-table counters. Tables can be grouped into collections — the same concept used in Drawing and Tasks — so related tables stay together. Create a collection, then use move to collection in a table's ⋯ menu.

  • All tables — the overview listing every table with its collection, record and column counts.
  • Collections — named folders for tables; deleting a collection never deletes its tables.
  • Templates — ready-made tables (CRM, sales pipeline, projects, bug tracker, inventory, HR, expenses, content calendar, OKRs, roadmap and more) to start from.

Create a table

  1. 1Open Bases and click new table (or pick one of the templates).
  2. 2Give it a name and choose an icon to identify it in the list.
  3. 3Add columns: for each one, set the name and the type.
  4. 4Configure each column's options according to its type (the choices of a select, the currency, the decimal places, the formula, the linked table).
  5. 5Start filling it in: click new record and type the values cell by cell.

You can rename the table, change the icon, reorder and delete columns at any time via edit structure. Deleting a column erases its values across all rows, so the app tells you how many values will be affected and asks you to confirm.

Fast and offline-friendly

Tables open instantly from a local cache on your device and reconcile with the server in the background. Every edit is saved automatically — the save indicator in the status bar shows the current state. If the connection drops, changes are queued on this device and sent when you are back online; closing the tab flushes anything still pending.

Go deeper

Each topic has its own page:

  • Column types — all available types (including image, autonumber, lookup, rollup and reverse links) and the system columns.
  • Rows — add, edit and delete records, edit cells and open a row as a full record with previous/next navigation.
  • Views — Table, Gallery, Kanban, List, Calendar, Chart and Analysis, plus saved views.
  • Filter and organize — search, structured filters, quick filter, grouping, multi-level sorting and large tables.
  • Formulas — calculated columns: operators, functions and examples.
  • Import and export — CSV/Excel in; CSV, Excel, JSON and Markdown out.
Bases is the foundation of the Forms module: a public form is built from a table and each submission becomes a new row that you read back here.
Column typesEach column's type defines what it accepts, how it appears and how it is aggregated (summed, counted, calculated). Pick the type when you create the column and adjust its type-specific options in edit structure.RowsA row is one record in the table. You add rows, fill them in cell by cell, and edit them right in the grid — there is no save button, changes are kept automatically, even offline. Each cell behaves according to its column type. You can also open a row as a full record, browse from record to record without closing the panel, and delete rows you no longer need.ViewsA view is a way to display the same table rows. Switch between Table, Gallery, Kanban, List, Calendar, Chart and Analysis in the tab bar, and save any arrangement — mode, sorting, filters and hidden columns — as a named saved view, without affecting the others or duplicating data.Filter and organizeTo find and tidy up a table's data you combine several tools: search, filters, multi-level sorting, and grouping. Each one narrows or reorganizes what you see without ever changing the underlying records. Filters, sorting, and the quick filter can also be captured in saved views, so the same table can show different cuts of the data side by side — and, one level up, collections keep the tables themselves organized in the sidebar.FormulasA Formula column calculates a number automatically from other columns in the same row — like a spreadsheet cell. It is read-only and recalculates itself whenever the source values change. Alongside it live three sibling column types that also derive their value instead of storing one: Lookup, Rollup, and Reverse links, which read through the connections between tables.Import and exportBring existing spreadsheets into a table without retyping anything, and take your data back out whenever you need to share it or open it in another tool. This page covers the import dialog step by step — choosing a file, creating a new table or appending rows, and how column mapping and type conversion behave — plus every export format and how to copy a table straight to the clipboard.