---
metadata:
  - name: generator
    content: Diplodoc Platform v5.46.1
alternate:
  - https://yandex.com.tr/support/wiki/en/import-page.md
title: "How to import a page or table from a file in Yandex\_Wiki"
description: This article will show you how to import a page or table from a file into Wiki.
---
> **Documentation Index:** Fetch the complete configuration index at https://yandex.com.tr/support/wiki/en/llms.txt


# Importing a page from a file


{% note info "" %}

Here you'll learn how to work with the [new Wiki editor](https://yandex.com.tr/support/wiki/en/pages-types.md#new-editor).

{% endnote %}


<!-- source: en/_includes/import-intro.md -->
On the Wiki page, you can:
* [Embed the file content in the page.](https://yandex.com.tr/support/wiki/en/import-page.md#text)
* [Add data from a file to a dynamic table.](https://yandex.com.tr/support/wiki/en/import-page.md#table)
<!-- endsource: en/_includes/import-intro.md -->

## Adding text from a file to a page {#text}

To add the contents of a TXT file or DOCX document to a page:

1. Open a page or [create a new one](https://yandex.com.tr/support/wiki/en/create-page.md).

1. On the toolbar, click <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" aria-hidden="true" class="yc-icon"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 16 16"><path fill-rule="evenodd" d="M14 6.125a1.874 1.874 0 1 1 .001 3.749A1.874 1.874 0 0 1 14 6.125zm-5.906 0a1.874 1.874 0 1 1 0 3.749 1.874 1.874 0 0 1 0-3.749zM2 6.125a1.874 1.874 0 1 1 .001 3.749A1.874 1.874 0 0 1 2 6.125z"/></svg></svg> **Other actions**, then select <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="16" height="16" class="g-icon" fill="currentColor" stroke="none" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 16 16"><path fill="currentColor" fill-rule="evenodd" d="M8.53 11.78a.75.75 0 0 1-1.06 0l-2.5-2.5a.75.75 0 0 1 1.06-1.06l1.22 1.22V1.75a.75.75 0 0 1 1.5 0v7.69l1.22-1.22a.75.75 0 1 1 1.06 1.06l-2.5 2.5ZM4.25 4a.75.75 0 1 1 0 1.5H4A1.5 1.5 0 0 0 2.5 7v5A1.5 1.5 0 0 0 4 13.5h8a1.5 1.5 0 0 0 1.5-1.5V7A1.5 1.5 0 0 0 12 5.5h-.25a.75.75 0 0 1 0-1.5H12a3 3 0 0 1 3 3v5a3 3 0 0 1-3 3H4a3 3 0 0 1-3-3V7a3 3 0 0 1 3-3h.25Z" clip-rule="evenodd"/></svg></svg> **Import**. This will open the import window.

1. Click **Select file** and choose a TXT or DOCX file.

    If you select a file with an unsupported format, you'll see an error message.

The contents of the selected file will be uploaded to the page:

- When you upload a TXT file, its entire content will be copied onto the page. If the text contains [markup elements](https://yandex.com.tr/support/wiki/en/wysiwyg/text-format.md), they will be displayed correctly.

- If you uploaded a DOCX document with formatting elements, its text will be converted to [YFM markup](https://yandex.com.tr/support/wiki/en/wysiwyg/text-format.md).

## Creating a static table from a file {#static}

<!-- source: en/wysiwyg/tables-format.md -->
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.

1. Open a page or [create a new one](https://yandex.com.tr/support/wiki/en/create-page.md).

1. In the visual editor or markup mode, click <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" aria-hidden="true" class="yc-icon"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 16 16"><path fill="currentColor" d="M1.5 3.656v8.938c0 .685.533 1.219 1.219 1.219H13.28a1.22 1.22 0 0 0 1.219-1.22V3.657c0-.66-.559-1.219-1.219-1.219H2.72a1.22 1.22 0 0 0-1.219 1.22Zm11.984 5.688H6.502V6.906h6.982v2.438Zm0 1.015v2.133a.309.309 0 0 1-.304.305H6.502v-2.438h6.982ZM2.516 6.906h2.97v2.438h-2.97V6.906Zm3.986-1.015V3.453h6.678c.152 0 .304.152.304.305V5.89H6.502ZM5.486 3.453v2.438h-2.97V3.758c0-.153.127-.305.304-.305h2.666Zm-2.97 6.906h2.97v2.438H2.82a.293.293 0 0 1-.304-.305V10.36Z"/></svg></svg> → <svg xmlns="http://www.w3.org/2000/svg" width="16" height="14" fill="currentColor" aria-hidden="true" class="yc-icon GridTableSettingsPopup-ItemIcon"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 16 14"><path d="m15.21 7.734-1.827-1.853c-.203-.178-.508-.05-.508.228v1.245h-2.438V3.977c0-.305-.152-.635-.38-.864L7.924 1.006C7.695.777 7.39.625 7.086.625H1.88A1.236 1.236 0 0 0 .687 1.869v10.563c0 .66.534 1.193 1.194 1.193h7.312c.686 0 1.245-.533 1.245-1.193V9.79h-1.22v2.64H1.882V1.87h4.062v2.64c0 .33.28.61.61.61H9.22v2.235H5.055a.293.293 0 0 0-.305.304v.61c0 .152.127.304.305.304h7.82v1.219c0 .28.305.406.508.229L15.21 8.19a.322.322 0 0 0 0-.457ZM7.163 3.9V1.945L9.117 3.9H7.162Z"/></svg></svg> **Import table from CSV** on the toolbar.

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

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

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

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

1. Check the preview of the table and click **Save**.

A multi-row table with the file's data will be added to the page.
<!-- endsource: en/wysiwyg/tables-format.md -->

For more information about static tables, see [Static table](https://yandex.com.tr/support/wiki/en/wysiwyg/tables-format.md).

## Adding data to a dynamic table {#table}

You can import data from CSV or TXT files to dynamic tables:

1. Save your spreadsheet, such as an MS Excel file, in CSV format. Alternatively, you can create a TXT file where the cell values are separated by a comma, semicolon, or tab character.

1. Open a dynamic table or [create a new one](https://yandex.com.tr/support/wiki/en/wysiwyg/grid.md#add).

1. In the top right corner of the table, click <svg xmlns="http://www.w3.org/2000/svg" width="20" height="20" fill="currentColor" aria-hidden="true" class="yc-icon nv-aside-header-footer-item__icon"><svg xmlns="http://www.w3.org/2000/svg" fill="none"><path fill="currentColor" fill-rule="evenodd" d="M9 2.5h2a.5.5 0 0 1 .5.5v.418c0 1.77 1.917 2.877 3.45 1.992l.362-.21a.5.5 0 0 1 .683.184l1 1.732a.5.5 0 0 1-.183.683l-.362.21c-1.533.884-1.533 3.098 0 3.983l.362.209a.5.5 0 0 1 .183.683l-1 1.732a.5.5 0 0 1-.683.183l-.362-.21c-1.533-.884-3.45.222-3.45 1.993V17a.5.5 0 0 1-.5.5H9a.5.5 0 0 1-.5-.5v-.418c0-1.77-1.917-2.877-3.45-1.992l-.362.209a.5.5 0 0 1-.683-.183l-1-1.732a.5.5 0 0 1 .183-.683l.362-.21c1.533-.884 1.533-3.098 0-3.983L3.188 7.8a.5.5 0 0 1-.183-.683l1-1.732a.5.5 0 0 1 .683-.183l.362.209c1.533.885 3.45-.221 3.45-1.992V3a.5.5 0 0 1 .5-.5ZM7 3a2 2 0 0 1 2-2h2a2 2 0 0 1 2 2v.418a.8.8 0 0 0 1.2.693l.362-.21a2 2 0 0 1 2.732.733l1 1.732a2 2 0 0 1-.732 2.732l-.362.21a.8.8 0 0 0 0 1.385l.362.209a2 2 0 0 1 .732 2.732l-1 1.732a2 2 0 0 1-2.732.732l-.362-.21a.8.8 0 0 0-1.2.694V17a2 2 0 0 1-2 2H9a2 2 0 0 1-2-2v-.418a.8.8 0 0 0-1.2-.693l-.362.209a2 2 0 0 1-2.732-.732l-1-1.732a2 2 0 0 1 .732-2.732l.362-.21a.8.8 0 0 0 0-1.385l-.362-.209a2 2 0 0 1-.732-2.732l1-1.732a2 2 0 0 1 2.732-.732l.362.209A.8.8 0 0 0 7 3.418V3Zm5 7a2 2 0 1 1-4 0 2 2 0 0 1 4 0Zm1.5 0a3.5 3.5 0 1 1-7 0 3.5 3.5 0 0 1 7 0Z" clip-rule="evenodd"/></svg></svg> → **Import data from file**.

1. In the **Loading data from file** window, choose a CSV or TXT file.

    {% note warning "" %}

    A single table can have no more than 1000 rows and 300 columns.

    {% endnote %}

1. Specify the characters used to separate cells and format rows.

1. If the file contains column headers, enable **The first line contains headers** option. Otherwise, headers with column numbers will be added automatically.

1. Select import destination for each column from the file:

    * **New column**: Place the column to the right of the existing columns.

    * Existing column: Append the data to the selected column.

    * **Ignore column**: Exclude the column from the import.

1. Select the data type for the new columns.

1. Click **Upload data**.

The contents of the selected file will be uploaded to the dynamic table. For more information on how to create and edit dynamic tables, see [Dynamic table](https://yandex.com.tr/support/wiki/en/wysiwyg/grid.md).


#### See also

- [Creating a page](https://yandex.com.tr/support/wiki/en/create-page.md)

- [Dynamic table](https://yandex.com.tr/support/wiki/en/wysiwyg/grid.md)


{% included (yfmeditor/tables-format.md) %}
<!--
Учитывать при внесении изменений: текст из файла также собирается в документации Yandex Tracker.
-->

## Visual editor {#editor}

To add a table:

1. On the toolbar, click <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" aria-hidden="true" class="yc-icon"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 16 16"><path fill="currentColor" d="M1.5 3.656v8.938c0 .685.533 1.219 1.219 1.219H13.28a1.22 1.22 0 0 0 1.219-1.22V3.657c0-.66-.559-1.219-1.219-1.219H2.72a1.22 1.22 0 0 0-1.219 1.22Zm11.984 5.688H6.502V6.906h6.982v2.438Zm0 1.015v2.133a.309.309 0 0 1-.304.305H6.502v-2.438h6.982ZM2.516 6.906h2.97v2.438h-2.97V6.906Zm3.986-1.015V3.453h6.678c.152 0 .304.152.304.305V5.89H6.502ZM5.486 3.453v2.438h-2.97V3.758c0-.153.127-.305.304-.305h2.666Zm-2.97 6.906h2.97v2.438H2.82a.293.293 0 0 1-.304-.305V10.36Z"/></svg></svg> **Table** → **Static table**.

    <!-- source: en/yfmeditor/tools-tip.md -->
    You can also use the quick access menu: type `/` and select a command from the list. {#slash}
    <!-- endsource: en/yfmeditor/tools-tip.md -->

1. To add rows or columns, hover over the table edge and click <svg xmlns="http://www.w3.org/2000/svg" width="18" height="18" fill="currentColor" aria-hidden="true" class="yc-icon nv-composite-bar__menu-icon"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 16 16"><path d="M7.25 10.75v-2h-2A.72.72 0 0 1 4.5 8c0-.4.31-.75.75-.75h2v-2c0-.4.31-.75.75-.75.4 0 .75.34.75.75v2h2c.4 0 .75.34.75.75 0 .44-.34.75-.75.75h-2v2c0 .44-.34.75-.75.75a.72.72 0 0 1-.75-.75ZM16 8A8 8 0 1 1 0 8a8 8 0 0 1 16 0ZM8 1.5a6.5 6.5 0 1 0-.01 13.01A6.5 6.5 0 0 0 8 1.5Z"/></svg></svg> where you want to add new elements.

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

To edit a table, hover over it and click <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="16" height="16" class="g-icon" fill="currentColor" stroke="none" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 16 16"><path fill="currentColor" fill-rule="evenodd" d="M7 3a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0ZM5.5 9.5a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3Zm5 0a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3Zm0-5a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3ZM7 13a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0Zm3.5 1.5a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3Z" clip-rule="evenodd"/></svg></svg> above the column or at the beginning of the row. Then choose an action from the menu:
* Add a row or column.
* Clear row or column cells.
* Delete a row or column.
* Delete a table.
* Drag a row or column to a new position using the <svg xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" width="16" height="16" class="g-icon" fill="currentColor" stroke="none" aria-hidden="true"><svg xmlns="http://www.w3.org/2000/svg" fill="none" viewBox="0 0 16 16"><path fill="currentColor" fill-rule="evenodd" d="M7 3a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0ZM5.5 9.5a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3Zm5 0a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3Zm0-5a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3ZM7 13a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0Zm3.5 1.5a1.5 1.5 0 1 0 0-3 1.5 1.5 0 0 0 0 3Z" clip-rule="evenodd"/></svg></svg> icon.

![](../_assets/static-table-actions.png =450x){.border-yes}

## Markdown markup {#yfm}

[Multi-row tables](#multiline) allow you to add multi-row content such as lists, code snippets, and other tables to a single cell.

[Simple table](#simple) 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 info "" %}

Simple tables can only be added in Markdown mode.

You can convert a simple table into a [multi-row](#multiline) table in the visual editor. To do this, select a table cell, click <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="1bcf880d__svg-icon" viewBox="0.5 -0.5 16 16"><path d="M8.5 4a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3zm0 5a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3zm0 5a1.5 1.5 0 1 1 0-3 1.5 1.5 0 0 1 0 3z"/></svg>, and choose **Convert to YFM table**.

{% endnote %}

### Multi-row table {#multiline}

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

```
#|
|| **Header 1** | **Header 2** ||
||Two lines
of text
|
- Item 1
- Item 2
- Item 3
||
|#
```
{% note tip "" %}

To highlight the header row in the table, you can apply [formatting](../wysiwyg/text-format.md) to the text in the first row. For example, you can make it bold.

{% endnote %}

{% cut "Result" %}

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

{% endcut %}

### Simple table {#simple}

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 |
```

{% cut "Result" %}

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

{% endcut %}

### Aligning text {#align}

In [basic tables](#simple), 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           |
```

{% cut "Result" %}

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

{% endcut %}


<!-- source: en/_assets/style/image.md -->

<!-- endsource: en/_assets/style/image.md -->

{% endincluded %}
{% included (yfmeditor/tools-tip.md) %}
You can also use the quick access menu: type `/` and select a command from the list. {#slash}

You can also add formatting elements [using your keyboard](../edit-page.md#keyboard) or through the quick access menu: type `/` and select an item from the list. {#keyboard}


{% endincluded %}
{% included (_assets/style/image.md) %}


{% endincluded %}