Creating a Termbase from a Multi-Sheet Excel File in Trados

Question

Hello all, I hope you are doing well! 
 I&rsquo;m trying to create a glossary in Trados using an Excel file with multiple sheets . Each sheet corresponds to a different product, and I need to specify from which product each term comes in the glossary. From what I understand, MultiTerm typically processes a single-sheet file , but I&rsquo;d like to confirm:Is there a way to import a multi-sheet Excel file directly into MultiTerm without manually consolidating the data? 
 Any guidance or best practices would be greatly appreciated. 
 Thank you!

RWS Community AI · Accepted Answer

"Probability score": 0.8 
 "Question improvement suggestion": Please provide the version of Trados Studio and MultiTerm you are using. Also, it would be helpful if you could share the structure of your Excel file (without sharing any confidential data) and any error messages you might have encountered during your attempts. 
 In the meantime, based on the information you have provided, here is a suggested answer to your question: 
 Hello, 
 Creating a termbase from a multi-sheet Excel file in MultiTerm is not directly possible. MultiTerm typically processes a single-sheet file. However, there are workarounds you can consider: 
 1. Consolidate your data: You can manually consolidate your data into a single sheet in Excel before importing it into MultiTerm. You can add an additional column to specify the product each term belongs to. 
 2. Use a third-party tool: There are tools available in the RWS AppStore that can help you convert your Excel file into a format that MultiTerm can process. One such tool is the Glossary Converter. This tool can convert Excel glossaries and simple termbases just by dragging and dropping onto a desktop icon. However, it requires that you have Excel and MultiTerm 2011 or later installed. 
 Please note that these are general suggestions and the effectiveness might vary depending on the specific structure of your Excel file and the version of Trados Studio and MultiTerm you are using. 
 I hope this answer addressed your question. If not, please reject the answer, add the question improvement suggestion information, and click the RWS Community AI checkbox on the right to try again. 
 RWS Community AI

Paul · Answer

Virginia Seggiaro 
 I see you responded to the CommunityAI, but you didn't reject the answer it gave so you never got another reply! 
 Virginia Seggiaro said: Is there a way to import a multi-sheet Excel file directly into MultiTerm without manually consolidating the data? 
 Possibly... if all your worksheets are exactly the same structure. For example, I just did this using these in a spreadsheet: 
 Worksheet 1 
 
 Worksheet 2 
 
 Dragged into the default settings and get this:

If the stuctures are different then you will have to correct that either within each worksheet or by consolidating. You'll also need a field that contains the name of the product. The conversion won't automatically add this based on a worksheet name for example... but I guess that's pretty trivial to do first.

Trados Studio > 3. MultiTerm

Creating a Termbase from a Multi-Sheet Excel File in Trados