We've launched a new support center at help.smartling.com. This site will continue to be maintained into January 2017. Please update your bookmarks.
Follow

Glossary Spreadsheet Format

Preparing your Excel spreadsheet correctly is important for a successful Glossary Import or Update.

Smartling only processes the first sheet of multi-sheet Excel files, so the first step is to either ensure that your glossary is the first sheet, or create a single-sheet file. For a successful glossary import, the columns of your Excel file must match the attributes of a Smartling glossary term. Most columns will accept any text input, but some accept only specific values. If an incompatible value is uploaded, the attribute will be set to the default value. A good way to get started is to Export a glossary as a CSV file and use this as a guide to naming your columns.

Below is a list of allowed columns for your Excel file. Only the ‘Term’ column is required for a successful import. Columns can be in any order but the column names must match. Column names are case sensitive. For more information about what should go in each column, see manage the glossary.

For the Source Term:

  • ID - Unique identifier for a term. This is included by Smartling in exported glossary files to identify any terms that have been edited when changes are merged. Do not edit this column. If adding a new term, leave it blank.
  • Term
  • Definition
  • Notes
  • Part Of Speech - Allowed values are ‘Noun’, ‘Verb’, ‘Adjective’, ‘Adverb’, ‘Pronoun’, ‘Preposition’, ‘Interjection’, ‘Conjunction’. Default is undefined.
  • Do Not Translate - Allowed values are ‘true’ and ‘false’. Default is ‘false’.
  • Case Sensitive - Allowed values are ‘true’ and ‘false’. Default is ‘false’.
  • Exact Match - Allowed values are ‘true’ and ‘false’. Default is ‘false’.
  • Variations
  • Synonyms
  • Antonyms
  • SEO - Allowed values are ‘true’ and ‘false’. Default is ‘false’.

For Each Target Language

  • [Locale Name] [Locale Code] - Contains the translation for each term in the target language. For example, for French (France), This column should be titled ‘French (France) fr-FR’.
  • Notes [Locale Name] [Locale Code] - Contains translation notes for each term in the target language. For example, for French (France), This column should be titled ‘Notes French (France) fr-FR’.
  • Locked [Locale Name] [Locale Code] - Determines whether translation resources are prevented from editing the translation. Allowed values are ‘true’ and ‘false’. Default is ‘false’. For example, for French (France), This column should be titled ‘Locked French (France) fr-FR’.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Powered by Zendesk