Importing a page from a file

On the Wiki page, you can:

• Embed the file content in the page.
• Add data from a file to a dynamic table.

Adding text from a file to a page

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

1. Open a page or create a new one.

2. On the toolbar, click Other actions, then select Import. This will open the import window.

3. 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, they will be displayed correctly.

• If you uploaded a DOCX document with formatting elements, its text will be converted to YFM markup.

Creating a static 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.

For more information about static tables, see Static table.

Adding data to a dynamic 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.

2. Open a dynamic table or create a new one.

3. In the top right corner of the table, click → Import data from file.

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

   Warning

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

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

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

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

8. Select the data type for the new columns.

9. 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.

See also

• Creating a page

• Dynamic table