The Synonyms settings determines how synonyms in entries are converted from and to spreadsheets. There are three formats:

  • No synonyms
    If an entry has more than one term per language, only the first one is used
  • Full support
    multiple terms are stored in one line, separated by a user defined character or string. If you use a string, you may find it useful to include line breaks by using "\n". For example "|\n" will result in

synonym 1|

synonym 2|

synonym 3

Note: only xlsx/xls. Excel is terrible with newline handling in csv or txt.

More on synonyms here: Synonyms, more on separator formats here

  • Multi-line format
    each synonym gets its own line. This needs careful planning to work properly, details here: Synonyms in multi-line format. Since the format needs to synchronise on a source language, you can specify one. If left empty, the first language is used. For termbases, that is a random language, so you'd better specify your source language here. 
    You can choose if you want to repeat the source in case of multiple translations. If you select this option, your spreadsheet will look like this:

English

German

Comment

car

Auto


car

Wagen

colloquial


If you leave it unchecked, it'll look like this:


English

German

Comment

car

Auto



Wagen

colloquial


  • Multi-column
    All synonyms are in one row, but each gets its own column. That means that every entry gets as many columns as the entry with the most synonyms. See Multi-column format for more details.


English

Comment

German

Comment

German

Comment

car


Auto


Wagen

colloquial

bicycle


Fahrrad




Created with the Personal Edition of HelpNDoc: Free help authoring environment