Import and export terms with CSV
Use import to bring an existing word list into a glossary in one go. Use export to get all terms of a space as a file: as a backup, to edit them in a spreadsheet, or to move them to another space.
Who can do this: space admin, see Permissions.
Before you start
For import, prepare a CSV with the columns listed in Data format. The easiest way to get the right structure is to add one term by hand, export the glossary and use the file as a template.
Steps
Export terms
- Open the glossary settings of the space: click Settings on the Glossary page.
- Open the Import / Export tab.
- Optional: turn on With Global terms to include global terms in the file.
- Click Export. The browser downloads a CSV file.
Import terms
- Open the Import / Export tab of the glossary settings.
- Paste the content of your CSV into CSV input.
- Check the preview next to the input. It shows the terms the app read from your CSV.
- Click Import.
- Wait until the progress bar is full and turns green.
Result
The imported terms appear on the Glossary page of the space with their alternative forms, labels and languages. If some rows were not imported, the tab lists them with the reason.
Good to know
- The Import button is inactive until you enter a CSV.
- A CSV that cannot be read is not imported at all. For example, an unclosed quote gives CSV parsing error, the preview stays empty and nothing is added.
- Existing terms are not changed or duplicated. If the file has a term whose name is already in the glossary, that term is skipped and reported. The other terms of the file are imported.
- An alternative form that belongs to another term blocks the row. The term is skipped and the error names the word.
- Rows without a name or without a definition are skipped and listed in the errors.
- One term in several languages is several rows. Rows with the same
idare joined into one term, one row for each language. - Markdown in definitions becomes formatting. Bold text, lists and links written in Markdown are shown formatted on the term card. Plain text, including text in several lines, is shown as it is.
- Export writes formatted definitions as Markdown, so an exported file can be imported again.