Importing concepts with files

1. You can download the sample Excel below and modify it according to your own needs, or create a new Excel in which you use the column headings described in the table.
   Example 1: Concept import Excel example (XLSX, 9.26 kB)Opens in a new window.(Includes Finnish)
   Example 2: Test terminology (XLSX, 20.85 kB)Opens in a new window.  (Includes Finnish)
   Example 3: (Row 2 has instructions, which need to be removed before you import the file to the tool.) Terminologies Excel import template (XLSX, 11.72 kB)Opens in a new window. (Finnish only)
2. The Excel file uploaded to the tool can only contain the fields described in the table below. The last column is not functional yet; it is planned to describe, if the row in the Excel file is to be added, updated, or removed; currently, possible old information is overwritten, and deletions are not possible.
3. Remove the example texts and guideline rows in the example excel. 
4. The languages in which material is added to the terminology must be defined. The Excel file cannot contain languages other than those defined for the terminology. If this requirement is not met, an error message will occur. If you add concepts in only one language (e.g. prefLabel_fi), then remove the columns of other language versions from the file (e.g. prefLabel_sv) before uploading the file to the Terminologies tool. 
5. The synonym, not recommended synonym, note, and example fields can have more information in the same Excel cell. These can be separated within the cell with a line break (alt + enter). 
6. Via Excel, you can add (names of) the terms (prefLabel, altLabel, notRecommendedSynonym), but not other information about the term. All other data (information in the cells) is stored in the concept. (In other words, is metadata for the concept.)

If you want to import concepts with an XML file (NTRF XML import), familiarise yourself with these materials:

• NTRF documentation (PDF, nordterm.net)Opens in a new window.
• Schema (yti-terminologu-api, github.com)Opens in a new window.
• Examples (yti-terminologu-api, github.com)Opens in a new window.