Creating Glossaries for Upload

If you do not have an existing glossary, you can create one in Excel and upload it to Lingotek.

To create a glossary to upload into Lingotek's Platform, Open a blank Excel spreadsheet (.xls; .xlsx will error) and enter the following:
 

Column Headers

Example Glossary Format:

1. Glossary headings
   1. Language code of the Source
      Use either the full locale code or the two letter language code.
      Example: en-US or EN
      
      
   2. Language code of the Target
      Use either the full locale code or the two letter language code. 
      Example: es-MX or ES
      
      
   3. Click for a List of Accepted Language codes 
      
      
2. Optional metadata columns
   1. These display in the Glossary popup without needing to expand the list to see them.
   2. The columns are entered starting with Column C. The order of the metadata columns doesn't matter.
       
3. Some example Column labels are listed below:
   1. Part of Speech
   2. Gender
   3. Classification
   4. Formal/Informal
   5. Notes
   6. Context
   7. Example in a sentence
       
4. For each row in the spreadsheet, enter the Source text, Target text, and metadata for the terms (optional).
    
5. For glossaries with multiple target languages, create each language as a separate tab (worksheet) in the spreadsheet. For example, tab #1 would be English to Spanish, tab #2 would be English to French, etc.
    
6. Save the .xls file