Create a database
Each column holds one kind of value, such as text or a date. You need edit access to change a database.
Create the database
Section titled “Create the database”- Open the folder it belongs in.
- Choose New, then New database.
- Click the title at the top of the page to name the database, and press Enter.
The database starts with one table, which takes the database’s name until you rename the table.
To start from a spreadsheet instead, choose New, then New database from CSV…. See Import a spreadsheet into a database.
Add tables
Section titled “Add tables”- Choose New table (the plus button after the table tabs), type the Table name, and choose Create.
- Each tab’s menu has Rename… and Delete table…. Deleting a table deletes its rows and columns for good; the window says how many.
Add columns
Section titled “Add columns”-
Choose Add column, the plus button at the right end of the column headers.
-
Type the Column name, and choose its Type:
Type Holds Text Words and sentences. Number Numbers, which sort and filter as numbers. Checkbox Yes or no. Date A date, from 1900 to 2100. Single select One of a list of Choices you type, separated by commas, such as Todo, Doing, Done. Files Files you attach. See Attach files to rows. -
Optionally, add a Description of what the column holds. See Describe columns for people and AI.
-
Choose Add column.
Each column header shows its type, and has a ⋯ menu with Rename…, Change type…, Describe… and Delete column…. When you change a column’s type, values that don’t fit the new type become empty, and the window warns you first.
Show numbers as money or percentages
Section titled “Show numbers as money or percentages”- In a number column’s ⋯ menu, choose Number format….
- Under Show as, choose Number, Money (then pick the Currency) or Percent.
- Pick Decimals, and tick Group thousands for 1,000 rather than 1000.
- Choose Save.
The format changes how numbers look, not what they are: in a percent column, 25 shows as 25%. Use plain numbers removes the format. Each person sees numbers written the way their language writes them, such as 1,234.5 or 1.234,5.
Add and edit rows
Section titled “Add and edit rows”- Choose New row under the table. It opens with the cursor in the first cell.
- Work as in a spreadsheet: start typing on a cell to replace it, or press Enter or F2 to edit it. Enter puts the value in and moves down, Escape cancels, Delete clears the cell, and the arrow keys move between cells. A checkbox changes with one click.
- A number cell takes one number, such as 1200, 1,200.50 or 4,50 (four and a half).
- Click a column’s name to sort by it: once for ascending, again for descending, a third time to stop.
- To delete rows, tick them at the left, choose Delete, and confirm.
Changes appear for other people who have the database open. If someone changes a cell while you are editing it, the cell shows their value, and Use mine puts yours back.
Copy and paste
Section titled “Copy and paste”- ⌘C (Ctrl+C on Windows) copies a cell.
- Copy a block of cells in Excel, Numbers or another spreadsheet, click a cell, and paste. The block fills cells to the right and down, and adds rows when it runs past the last one. Up to 500 rows at a time.
Undo a change
Section titled “Undo a change”Open the side panels with the Side panels button at the top right, and choose Activity. It lists recent changes to the database, newest first, with who made each one. A change that can still be undone shows Revert. It writes back over edits made since; rows deleted since stay deleted.
- Save views of a database: search, filter, sort and group.
- Import a spreadsheet into a database: bring in existing rows.
- Open a row as a page: notes and comments for one row.
- Share a document: databases are shared the same way.