Chapter 4: Tables - Spreadsheets in Plain Text

Start typing a table with pipes (|):

| Name    | Age | City      |
| Alice   | 28  | Portland  |
| Bob     | 35  | Seattle   |
| Carol   | 42  | Vancouver |

But here’s the magic: you don’t have to format it manually. Type this:

| Name | Age | City

Press TAB, and Org-Mode completes the row:

| Name | Age | City |
|------+-----+------|

Keep pressing TAB to move through cells. When you’re in the last cell, TAB creates a new row. Type your content and watch Org-Mode auto-format everything, keeping columns aligned perfectly.

Type messily:

|Name|Age|City
|Alice|28|Portland

Press TAB anywhere in this mess, and Org-Mode formats it:

| Name  | Age | City     |
|-------+-----+----------|
| Alice |  28 | Portland |

Never manually align columns again. Org-Mode handles spacing, creates separators, and maintains readability. Add more data, delete columns, change content—it stays formatted.

This is computational assistance that feels like magic.

The horizontal separator line (|---+---|) can be created with C-c - on any row. It’s useful for visual grouping:

| Product  | Q1    | Q2    | Q3    | Q4    |
|----------+-------+-------+-------+-------|
| Widget A | 1,200 | 1,450 | 1,380 | 1,620 |
| Widget B | 850   | 920   | 1,100 | 1,250 |
|----------+-------+-------+-------+-------|
| Total    | 2,050 | 2,370 | 2,480 | 2,870 |

Here’s where it gets wild. Org tables can contain formulas:

| Item          | Quantity | Price | Total |
|---------------+----------+-------+-------|
| Coffee        |        3 |  4.50 | 13.50 |
| Croissant     |        2 |  3.75 |  7.50 |
| Orange Juice  |        1 |  5.00 |  5.00 |
|---------------+----------+-------+-------|
| Total         |          |       | 26.00 |
#+TBLFM: $4=$2*$3::@6$4=vsum(@2..@4)

Let’s decode that formula line:

• #+TBLFM: - This is a table formula
• $4=$2*$3 - Column 4 equals column 2 times column 3
• :: - Separator for multiple formulas
• @6$4=vsum(@2..@4) - Row 6, column 4 equals the sum of rows 2-4

Press C-c C-c on the #+TBLFM: line to recalculate. Change a quantity or price, recalculate, and watch totals update.

Column formulas apply to entire columns:

#+TBLFM: $4=$2*$3

Cell-specific formulas apply to individual cells:

#+TBLFM: @6$4=vsum(@2..@5)

You can mix both. Org-Mode applies them in order.

Like Excel:

• @2$3 - Relative (changes when copied)
• @2$3 - Can be made absolute with $ but Org uses different notation:
• @2$3 stays relative by default
• Use @# for current row, $# for current column in formulas

For most use cases, relative references are what you want.

Org-Mode formulas can use:

Calc (Emacs calculator):

#+TBLFM: $4=$2*$3;%.2f

The ;%.2f formats to 2 decimal places.

Emacs Lisp:

#+TBLFM: $4='(* $2 $3);N

The single quote starts an elisp expression. ;N treats empty cells as 0.

External programs:

#+TBLFM: $4='(my-custom-function $2 $3)

If you can code it in elisp, you can use it in a table formula. The possibilities expand infinitely.

Formulas not working?

• C-c { - Toggle formula debugger
• C-c } - Toggle column/row number display (shows coordinates)
• C-c ' - Edit formulas in dedicated buffer

The debugger shows step-by-step evaluation. The coordinate display helps write correct references.

Can Org tables replace Excel/Google Sheets?

What Org tables do well:

• Basic calculations
• Data that needs to stay plain text
• Quick calculations in documents
• Version control friendly formats
• Infinite longevity (it’s text)

What spreadsheets do better:

• Complex financial modeling
• Charts and graphs (though Org can generate these via code blocks)
• Cell formatting and colors
• Large datasets (thousands of rows)
• Collaboration with non-technical users

Think of Org tables as “spreadsheets for text people.” They’re phenomenally useful but know their limits.

Here’s a teaser (we’ll cover this more in the code blocks chapter):

#+PLOT: title:"Sales Data" ind:1 deps:(2 3) type:2d with:linespoints
| Month | Product A | Product B |
|-------+-----------+-----------|
| Jan   |       120 |       95  |
| Feb   |       135 |      108  |
| Mar   |       128 |      115  |
| Apr   |       145 |      122  |
#+TBLFM: ...

C-c C-c on the #+PLOT: line generates a graph. Plain text tables creating visualizations. Beautiful.

Create at least three tables:

1. A simple data table (no formulas) - practice formatting and editing
2. A table with column formulas that calculate values
3. A table with a summary row that aggregates data

Experiment with:

• Moving columns and rows around
• Inserting and deleting
• Different formula functions (sum, mean, max, min)
• The formula debugger

Here’s what makes Org tables special: they’re human-readable without computation. Open a .org file in any editor, and the tables make sense. Run them through grep, diff, or any text tool—they work perfectly.

Compare this to binary spreadsheet formats or databases. Org tables sacrifice some power for universal accessibility. For many use cases, that’s the right trade-off.

You’ve mastered structure and tables. Next, we’ll connect your knowledge with links—both to other documents and to the wider world—and bring visual elements into your plain-text realm. The web of your knowledge awaits.