Tables

Create and format tables, use formulas, sort data, and organize information effectively in Craft.

Tables in Craft let you organize data in rows and columns with powerful features like formulas, sorting, and cell formatting. Whether you’re creating a budget planner, tracking a project, or organizing any structured information, tables provide the flexibility you need.

Creating a New Table

Adding a table to your document is quick and easy across all platforms.

macOS

Using the Insert Panel

1. Open the Insert panel from the right sidebar

2. Drag the Table block into your document

3. Choose your initial table size (rows and columns)

You can also use the slash command method (see the Slash Command tab).

iOS

Using the Plus Button

1. Tap the + button at the bottom left of your screen

2. Swipe through the horizontal list and tap Table

3. Select your desired table dimensions

Web

Using the Insert Panel

1. Click the Insert panel in the right sidebar

2. Click Table from the list

3. Choose your table size

Slash Command

The Fastest Method (All Platforms)

Type / to open the slash command menu, then:

• Type /table and select from the menu, or
• Type the exact size you need: /3x4 creates a 3-row by 4-column table
• Works for sizes up to 9x9

Using /3x4 or similar size commands is the fastest way to create a table once you know the dimensions you need.

Working with Table Structure

Once your table is created, you can easily modify its structure.

Adding Rows and Columns

• Right-click any cell (Mac) or tap the three-dot menu (mobile)
• Choose to insert rows above/below or columns left/right
• Add as many as you need

Deleting Rows and Columns

• Right-click the row or column you want to remove
• Select “Delete Row” or “Delete Column”

Deleting a Table

To remove an entire table from your document, first select it as a block, then delete it.

1. Click outside any cell, then click the block handle (the dot to the left of the table) to select the whole table as a block

2. Press Delete or Backspace, or open the block menu and choose Delete

The block handle only engages when your cursor isn’t inside a cell. If clicking the handle doesn’t select the table, click somewhere outside the table first, then try again.

Resizing Columns

• Hover over column borders (Mac/Web)
• Drag to adjust width
• Each column can have its own width

Header Rows and Columns

• Turn the first row into a header row by enabling Header row in the table’s style options
• You can also enable Header column to use the first column as a header
• Header rows stay in place when you sort the table

Cell Formatting

Make your data more meaningful by applying the right format to your cells.

All Platforms

Available Formats

• Plain Text: Default format for text content
• Number: Formats numbers with proper alignment
• Percent: Displays values as percentages (0.5 becomes 50%)
• Currency: Adds currency symbols and formatting

To Apply Formatting

1. Select one or more cells (click and drag to select multiple)

2. Right-click (Mac) or tap the three-dot menu

3. Choose your desired format from the menu

When you apply a format to a column header, new cells added to that column automatically inherit the same format.

Cell Colors

Cells can also be colored. Select one or more cells, right-click (Mac) or tap the three-dot menu, then choose Cell Color and pick a color.

Using Formulas

Formulas bring calculation power to your tables, perfect for budgets, tracking metrics, or any data analysis.

Starting a Formula

1. Click into a cell where you want the formula result

2. Type = to begin formula mode

3. Start typing your formula or select from suggestions

4. Press Enter to confirm

Alternatively, you can right-click a cell and choose “Insert Formula” from the three-dot menu.

Available Functions

Craft supports many standard spreadsheet formulas:

Statistical Functions

• SUM(range) - Add up numbers
• AVERAGE(range) - Calculate average
• COUNT(range) - Count numeric cells
• COUNTA(range) - Count non-empty cells (including text)
• MIN(range) - Find minimum value
• MAX(range) - Find maximum value
• MEDIAN(range) - Find the middle value
• MODE(range) - Find the most frequently occurring value

Mathematical Functions

• ROUND(number, decimals) - Round to specified decimals
• ABS(number) - Absolute value
• INT(number) - Integer part of a number (truncates toward zero)
• PRODUCT(range) - Multiply all values together
• SIGN(number) - Return -1, 0, or 1 based on sign of the number

Referencing Cells

Use standard spreadsheet notation:

• A1 - Single cell reference
• A1:A5 - Range of cells (rows 1-5 in column A)
• B2:D2 - Range across columns

Example Formulas

• =SUM(A1:A10) - Sum all values in column A, rows 1-10
• =AVERAGE(B2:B20) - Average of column B, rows 2-20
• =ROUND(SUM(A1:A5)/5, 2) - Average rounded to 2 decimals

Formulas automatically recalculate when referenced cells change, keeping your data always up to date.

Sorting Data

Organize your table data by sorting any column in ascending or descending order.

To Sort a Table

1. Right-click any cell in the column you want to sort by

2. Choose “Sort Ascending” or “Sort Descending” from the menu

3. The entire table reorders based on that column

If your table has a header row, it stays in place when you sort. Only the rows below it are reordered. See Header Rows and Columns above for how to enable it.

Sorting Behavior

• Numbers sort numerically (1, 2, 10, not 1, 10, 2)
• Text sorts alphabetically
• Empty cells move to the bottom
• Formulas maintain their references even after sorting

Keyboard Navigation in Tables

Work efficiently within tables using these shortcuts:

macOS

• Tab - Move to next cell (creates new column at end)
• Shift+Tab - Move to previous cell
• Enter - Move down one row (creates new row at bottom)
• Cmd+Arrow Keys - Jump to edge of table

Windows/Web

• Tab - Move to next cell
• Shift+Tab - Move to previous cell
• Enter - Move down one row
• Ctrl+Arrow Keys - Jump to edge of table

Pressing Tab at the last cell of a row automatically adds a new column. Pressing Enter at the bottom row adds a new row. This makes expanding your table seamless as you work.

Convert a Table into a Collection

If your table outgrows simple rows and columns, you can turn it into a collection:

1. Right-click the table (Mac) or tap the three-dot menu

2. Choose Turn into Collection

Your data carries over to the new collection.

Tables vs Collections

While tables are great for organizing data, consider using Collections when you need:

• Database-like views (gallery, board, list)
• Multiple views of the same data
• Rich content within cells (nested pages, images)
• Filtering and grouping
• Relations between items

Use Tables When:

• You need simple rows and columns
• Formulas and calculations are important
• You want a traditional spreadsheet feel
• Data is primarily text and numbers

Use Collections When:

• Each row represents a rich item (project, person, task)
• You want multiple ways to view the same data
• You need to filter, group, or relate items
• Visual organization (cards, boards) is helpful

Common Use Cases

Budget Planner

| Category    | Budget | Actual | Remaining        |
|-------------|--------|--------|------------------|
| Groceries   | 500    | 450    | =B2-C2          |
| Utilities   | 200    | 180    | =B3-C3          |
| Total       | =SUM(B2:B3) | =SUM(C2:C3) | =SUM(D2:D3) |

Project Tracker

| Task        | Hours  | Rate  | Total    | Status |
|-------------|--------|-------|----------|--------|
| Design      | 10     | 50    | =B2*C2   | Done   |
| Development | 20     | 75    | =B3*C3   | Active |
| Total       | =SUM(B2:B3) |   | =SUM(D2:D3) |        |

Grade Calculator

| Assignment  | Score | Weight | Weighted       |
|-------------|-------|--------|----------------|
| Midterm     | 85    | 0.3    | =B2*C2        |
| Final       | 90    | 0.4    | =B3*C3        |
| Final Grade |       |        | =SUM(D2:D3)   |

Tips for Working with Tables

Start Simple: Begin with a basic table and add complexity (formulas, formatting) as needed. It’s easier to expand than to simplify.

Use Formatting: Apply number, currency, or percent formats to make data clearer at a glance.

Keep Formulas Visible: In complex tables, consider adding a note column explaining what formulas do.

Export When Needed: Tables copy and paste well into spreadsheet applications if you need more advanced features.

Combine with Text: Tables work great alongside regular text blocks. Add explanations above or below your tables for context.

Collections

Database-like features for rich data

Formatting

Text and content formatting options

Blocks and Pages

Understanding Craft’s content structure