Tables and sheets

A new table opens with one column, Name, and no rows — somewhere to start typing rather than a guess at your schema.

Create a table

1. Open Data.
2. Select Create table.
3. Name it. Table names must be unique within your organization.

Creating a table is a desktop action — on a phone, Data lists your existing tables, but the create control is not there.

Add columns

1. At the right end of the header row, select the + Column cell.
2. Name the column and choose its field type.
3. Select Add.

To change a column afterward, open its header menu (the chevron next to its name) and choose Rename, Change type, or Delete column. Renaming only changes the header shown — nothing else in the table shifts. Changing type changes how a column is shown, edited and sorted, and leaves the values already in it exactly as they are. Deleting a column removes it from the grid, but its values stay in the rows, hidden rather than erased — add a column back with the same name and they reappear.

Add rows

Select Add row, the strip below the last row. A new row opens at the top of the table for editing, not at the bottom, so adding to a table with thousands of rows never means scrolling to find it.

A locked table shows "This table is locked" in place of the add-row control. Only an owner or admin can lock or unlock a table.

Sheets

A table can hold more than one sheet, each with its own columns and rows — useful for a season's worth of near-identical sheets, or for a form's submissions exported into a tab of their own. Nothing is shared between sheets except the table's name.

1. Above the grid, select + at the end of the sheet tabs.
2. The new sheet opens blank and named the next free "Sheet N" — nothing from the sheet you were on is copied into it.

Double-click a tab to rename it, or open its ⋯ menu for Rename and Delete sheet. A table always keeps at least one sheet, so the last one can't be deleted — delete the table instead.