Export BT in Excel with comments to synonyms

Question

Dear all, 
 I'd like to export TB entries with comments to synonyms in excel. Unfortunately, synonyms and comment field appear in a row so it's difficult to see to which term the comments are referring to. Here's an example:

(the comment "fourrages" refers to the term "faneuse", "c&eacute;r&eacute;ales" to "moissonneuse" and "choux" to "r&eacute;colteuse") 
 
 How can we show comments to synonyms in a clearer manner in excel? 
 Thanks for your piece of advice 
 Aur&eacute;lie

Paul · Accepted Answer

Aurélie Machut 
 I'd recommend you use the Glossary Converter for a conversion like this. The MultiTerm export is based on years of believing termbases are not designed for excel spreadheets because of how a concept-oriented dataset should work. There s some truth to this, and the more complex the termbase becomes the harder it is to manage properly in Excel. 
 However, you just have a very simple structure to your termbase so the glossary converter will handle this very easily and put one entry per row with synonyms separated by a pipe symbol and the comments aligned on the same row. 
 The glossary converter is available here: 
 https://appstore.sdl.com/language/app/glossary-converter/195/

Trados Studio > 3. MultiTerm

Export BT in Excel with comments to synonyms