SDL Trados Studio
SDL Trados GroupShare
SDL Trados Business Manager
SDL Trados Live
SDL MultiTerm
SDL Passolo
SDL Speech to Text
SDL Managed Translation - Enterprise
SDL MultiTrans
SDL TMS
SDL WorldServer
Translation Management Connectors
SDL LiveContent S1000D
SDL Contenta S1000D
SDL XPP
SDL Tridion Docs
SDL Tridion Sites
SDL Content Assistant
SDL Machine Translation Cloud
SDL Machine Translation Connectors
SDL Machine Translation Edge
Language Developers
Tridion Developers
Tridion Docs Developers
Xopus Developers
Community Help
SDL User Experience
Language Products - GCS Internal Community
SDL Community Internal Group
SDL Access Customer Portal
SDL Professional Services
SDL Training & Certification
Style Guides
Language Technology Partner Group
SDL Academic Partners
SDL Approved Trainers
SDL Enterprise Technology Partners
XyUser Group
ETUG (European Trados User Group) Public Information
Machine Translation User Group
Nordic SDL Tridion Docs User Group
SDL Tridion UK Meetup
SDL Tridion User Group New England
SDL Tridion West Coast User Group
SDL WorldServer User Group
Tridion Docs Europe & APAC User Group
Tridion User Group Benelux
Tridion User Group Ohio Valley
SDL MultiTerm Ideas
SDL Passolo Ideas
SDL Trados GroupShare Ideas
SDL Trados Studio Ideas
SDL Machine Translation Cloud Ideas
SDL Machine Translation Edge Ideas
SDL Language Cloud TMS Ideas
SDL Language Cloud Terminology Ideas
SDL Language Cloud Online Editor Ideas
SDL Managed Translation - Enterprise Ideas
SDL TMS Ideas
SDL WorldServer Ideas
SDL Tridion Docs Ideas
SDL Tridion Sites Ideas
SDL LiveContent S1000D Ideas
SDL XPP Ideas
Events & Webinars
To SDL Documentation
To SDL Support
What's New in SDL
Detecting language please wait for.......
Introduction
The application allows user(s) to use Excel spreadsheet (add/delete terms) as a glossary in Studio just as it would do within MultiTerm. The application is available for SDL Trados Studio 2017 and SDL Trados Studio 2019.
Install the provider from the AppStore. (On the AppStore, the app is found under TermExcelerator name)
Set the Excel Terminology Provider from Project Settings -> LanguagePairs -> All Language Pairs -> Termbases
Once the provider is set up, the following options will be displayed:
If you maintained a spreadsheet in the past with synonyms in different columns, then just concatenate them into a new column. If you are not familiar with this feature, then you can apply a formula like this in the Excel file: =B2&"|"&C2&"|"&D2. This would allow you to concatenate words in cells B2, C2 and D2 with a pipe symbol between them, like this:
So now you would have the correct string containing all synonyms in one cell, E2. You can then copy the cell down your spreadsheet and do them all at once. Make sure you then select the column, copy it and paste it in as values so you have the text as opposed to the formula, then finally delete the original three columns so you only have the one with the concatenated synoynms:
IMPORTANT: Make a copy of your original spreadsheet before you start to mess around with it!!
If you don’t use synonyms then don’t worry, you only have to select your columns in Studio exactly as they are.
Once you have set your settings, just select your spreadsheet and click on the submit button:
The spreadsheet is now set up as a termbase and is ready to be used:
Below you have the custom Termbase Viewer next to the Termbase Recognition window.
The recognition window you’ll be familiar with because this is just how MultiTerm works. You will see the terms that were found in the spreadsheet and you can also view the term details from there in the same way you would using MultiTerm to see the terms in the Termbase Viewer. In this case, there is little value in using the viewer for more detail, because it’s exactly the same as the Term Recognition window. However, if you want to edit anything this is where it comes into its own. There are a number of features around this to be aware of, and all associated with the buttons you can see in the screenshot above:
In the translation editor itself you get all the usual benefits of being able to see the highlighted terms, and place them using AutoSuggest:
To Add New Term/ Add Quick Term you should select a word/phrase from the source segment and the corresponding one in the target and press on the button from the Ribbon "Add New Term"/ "Add Quick Term". The same option(s) of adding new terms is available also on right click.
After pressing on the "Add New Term" option, the terms will be inserted in the spreadsheet and you will see them in the Termbase Viewer:
Verification: at the moment the API doesn’t extend to being able to make use of the term verification features that MultiTerm offers. So you cannot use your Excel spreadsheet of terms for verification purposes.
Settings: the settings for the spreadsheets you add can only be accessed when you add a spreadsheet. This is also a limitation of the current version of the API and available functionality in Studio. So if you wish to change something you have to remove the spreadsheet and add it again. During testing I occasionally corrupted the settings in Studio, probably as a result of messing around so much, but if this should happen it’s worth noting that the solution was simple in every case:
The Excel file itself: Excel is not a database! There are no controls over it at all. So here’s a few precautions worth noting:
Logging
In case the application crashes or issues are thrown, you can find the file which logs the problems at the following location: C:\Users\{USERNAME}\AppData\Roaming\SDL\ExcelTerminologyProvider. The "ExcelTerminologyProvider.txt" file should be attached to the message when the issue is raised on the Sdl Community forum/email.
*More information about the Excel Terminology Provider can be found in the following article: https://multifarious.filkin.com/2016/03/02/committing-the-cardinal-sin/