Static table

Note

Here you'll learn how to work with the new Wiki editor. For more information about markup in the old editor, see Markup guide (old editor).

In a static table, you can manually adjust the formatting and order of rows using the toolbar or markup elements.

Unlike dynamic tables, static tables don't support the features of sorting, filtering, or checking cell data types.

Adding a table

To add a table:

  1. On the toolbar, click Table → Static table.

    You can also use the quick access menu: type / and select a command from the list.

  2. To add rows or columns, hover over the table and click next to its right or bottom edge.

  3. Fill in the cells. You can format text in the table cells.

To edit a table, select a cell and use the buttons above the column or at the beginning of the row. You can:

  • Add rows or columns before or after the current cell.

  • Delete the selected row or column.

  • Delete a table.

Multi-row tables allow you to add multi-row content such as lists, code snippets, and other tables to a single cell.

Simple table cells can only contain inline formatting elements: text formatting, images, and links. In addition, simple tables support left-aligned, right-aligned, and centered cell text.

Note

Simple tables can only be added in Markdown mode.

You can convert a simple table into a multi-row table in the visual editor. To do this, select a table cell, click , and choose Convert to YFM table.

Multi-row table

To add a multi-row table, use the following markup:

#|
|| **Header 1** | **Header 2** ||
||Two lines
of text
|
- Item 1
- Item 2
- Item 3
||
|#

Tip

To highlight the header row in the table, you can apply formatting to the text in the first row. For example, you can make it bold.

Result

Header 1

Header 2

Two lines
of text
  • Item 1
  • Item 2
  • Item 3

Simple table

To insert a basic table into your text, use the following markup:

| Header 1 | Header 2 | Header 3 |
| --- | --- | --- |
| cell 11 | cell 12 | cell 13 |
| cell 21 | cell 22 | cell 23 |
Result
Header 1 Header 2 Header 3
cell 11 cell 12 cell 13
cell 21 cell 22 cell 23

Aligning text

In basic tables, you can left-align, right-align, and center the contents of a column. To do this, use colons (:) in the table's separator row.

| Left-aligned | Centered     | Right-aligned |
| :---           | :----:        | ---:            |
| Text          | Text         | Text           |
| Text          | Text         | Text           |
Result
Left-aligned Centered Right-aligned
Text Text Text
Text Text Text

Importing a table from a file

You can add a static table to the page using data from a CSV or TXT file.

  1. Create a CSV or TXT file with data for your table. The cell values in the file must be separated by a comma, semicolon, or tab character.

    For example, you can save an MS Excel file in CSV format.

  2. Open a page or create a new one.

  3. In the visual editor or markup mode, click → Import table from CSV on the toolbar.

    To access a quick menu in the visual editor, type / and select a command from the list.

  4. In the window that opens, click Select a file and choose a CSV or TXT file.

  5. If needed, specify the characters used to separate cells. By default, the separator is detected automatically.

  6. If you don't want to add empty rows from the file to the table, select Skip empty lines.

  7. Check the preview of the table and click Save.

A multi-row table with the file's data will be added to the page.

Previous
Links
Next
Dynamic table