Each note can have one table, alongside its text. The example in this guide is a trip budget, in a note called “Trip budget”: what was spent, how much it cost and whether it’s paid.

1. Create the table

  1. Open the note.
  2. On the editor’s bottom bar, tap the Table button, the one with stacked rows. If it isn’t on the bar, it’s in the same bar’s ⋮ menu.
  3. In Choose table size, use − and + to set Rows and Columns.
  4. Tap Insert.
Choose table size dialog with Rows 3 and Columns 2, minus and plus buttons and the Cancel and Insert buttons over the Trip budget note
The dialog starts at 3 rows and 2 columns.

You don’t need the exact size now. Rows and columns can be added and removed later.

2. Fill in the cells

  1. Tap a cell and type.
  2. Tap the keyboard’s next key to move to the next cell. On the last cell, it adds a new row below.
  3. On a physical keyboard, Tab moves to the next cell and Shift+Tab goes back.

The first row is the header and is always bold.

Trip budget note with a 4-row, 3-column table: Item, Cost and Paid in a bold header; Hotel 320 Yes; Train 85 No; Food 150 No
The finished budget. The "Item, Cost, Paid" header turned bold by itself.

While you edit a cell, the bottom bar shows a New line arrow, for a line break inside the cell, plus undo, redo and a ✓ to finish.

Touch and hold a cell for Copy, Clear, Add row and Add column. If the cell has a link, Open link shows up too.

Already have the data in a spreadsheet? Copy the cells in Google Sheets or Excel and paste them into a cell. The values spread to the right and down, and the app adds any rows and columns that are missing.

3. Open the table settings

Once the table exists, the Table button gets a gear. Tap it to enter Table settings. Tap it again to leave. Cells don’t open for editing in this mode.

Trip budget table in settings mode, with ⋮ to the left of each row, … above each column, four width icons at the top and the + and ⋮ buttons below
Settings mode: row menus on the left, column menus on top.
WhereWhat it does
⋮ to the left of each rowRow menu
… above each columnColumn menu (section 4)
Icons at the top, left to rightReset column widths, Equal column widths, Fit columns to content and Fit to table width
+ below the tableQuick actions: add a row or column at the end, remove the last row or the last column
⋮ below the tableCopy, import, export, colors, borders and delete (section 6)

The row menu has Add row, Duplicate row, Copy row, Bold, Center, Right Align, Move up / Move down, Clear Row and Delete. The header has no Bold option, because it is already bold.

4. The column menu

Tap the … above a column.

Column menu with Add column, Duplicate column, Copy column, Bold, Center, Right Align, Add Checkbox, Sort A to Z, Sort Z to A, Column stats, Set Width, Move left, Move right, Clear Column and Delete
The menu for the "Cost" column.
OptionWhat it’s for
Add column / Duplicate columnAdds an empty column or a copy to the right
Copy columnCopies the values, one per line
Bold, Center, Right AlignFormats the whole column. Tap again to undo it
Add CheckboxTurns the text into tick boxes. Only works on an empty or true/false column
Sort A to Z / Sort Z to ASorts the rows by this column. The header stays on top, numbers sort as numbers and empty cells go last
Column statsSum, average, smallest and largest value (section 5)
Set WidthSets the column’s width. Off while Fit to table width is on
Move left / Move rightMoves the column
Clear ColumnErases the text and keeps the column
DeleteRemoves the column

Clear and Delete ask for confirmation first.

Want a “Paid” column with tick boxes? Add a new column, use Add Checkbox, then type only the header.

5. Add up a column

In the column menu, tap Column stats. In the example, the “Cost” column shows the trip total.

Column stats dialog for Cost with Filled cells 3/3, Numbers 3, Sum 555, Average 185, Smallest 85 and Largest 320
A total of 555, an average of 185. The header isn't counted.
LineWhat it shows
Filled cellsHow many cells have something in them, out of the total
NumbersHow many cells were read as numbers
SumThe total
AverageThe average
Smallest / LargestThe lowest and highest value

Values such as $10, 1,234.50 and -5% count as numbers. For a checkbox column, the dialog shows how many are Checked.

6. Colors, borders and export

The ⋮ below the table has:

OptionWhat it does
Copy, Import & ExportCopies the table as CSV, Markdown or HTML, saves it to a file in those formats, or imports a table from a file. Importing replaces the current table
ColorOpens the Font, Background, Title (for the header row) and Border tabs. Alternating rows is on the Background tab
DeleteDeletes the whole table
Row of icons at the endThe border style: Full grid borders, Rows only borders, Outer borders only or No borders

On the home screen, the note’s card shows up to 6 rows of the table and counts the rest. In a checkbox column, you can tick boxes right on the card.

Next guides

FAQ

Can a note have two tables?

No. Each note has one table. Once it exists, the Table button opens its settings instead of making another. For a second table, use another note.

How big can a table be?

Up to 250 rows and 30 columns, with at most 3,000 cells.

Does the sum understand currency and decimal commas?

Yes. $10, 1,234.50 and 3,50 are read as numbers. Text such as "Item 2" or a date is left out of the count.

How is this different from a Markdown table?

A Markdown table is text with | that turns into a table in Reading mode. The table in this guide is edited cell by cell, with menus, sorting and sums. See the Markdown guide.