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”
• You can also delete the entire table from the block menu

Resizing Columns

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

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.

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
• AVG(range) - Calculate average
• COUNT(range) - Count non-empty cells
• MIN(range) - Find minimum value
• MAX(range) - Find maximum value

Mathematical Functions

• ROUND(number, decimals) - Round to specified decimals
• ABS(number) - Absolute value
• SQRT(number) - Square root

Logical Functions

• IF(condition, true_value, false_value) - Conditional logic

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
• =AVG(B2:B20) - Average of column B, rows 2-20
• =IF(C1>100, "Over Budget", "On Track") - Conditional text
• =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

Sorting applies to the entire table. If you need a header row that doesn’t get sorted, create a separate single-row table above your main table. This keeps your header in place while the data below can be sorted.

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.

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

Formatting

Blocks and Pages