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

Hello all,

I hope you are doing well! 

I’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’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.Blush

Thank you!

emoji
  • "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

    emoji
  • 2022 Trados Studio Version
    2024 Multiterm version

    Excel file structure: Source Language, Target Language, Clarification, Screenshot.

    emoji
  •  

    I see you responded to the CommunityAI, but you didn't reject the answer it gave so you never got another reply!

    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

    Partial view of an Excel spreadsheet with columns A, B, and C containing headers 'en', 'de', and 'Product'. Row 2 has the words 'two', 'zwei', and 'Abacus'.

    Worksheet 2

    Partial view of an Excel spreadsheet with columns A, B, and C containing headers 'en', 'de', and 'Product'. Row 2 has the words 'dog', 'hund', and 'Pets'.

    Dragged into the default settings and get this:

    Screenshot of MultiTerm interface showing 'Terms' section with 'Entry Id: 1', 'Product: Abacus', and language fields 'EN' with term 'two' and 'DE' with term 'zwei'.            Screenshot of MultiTerm interface showing 'Terms' section with 'Entry Id: 2', 'Product: Pets', and language fields 'EN' with term 'dog' and 'DE' with term 'hund'.

    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.

    Paul Filkin | RWS Group

    ________________________
    Design your own training!

    You've done the courses and still need to go a little further, or still not clear? 
    Tell us what you need in our Community Solutions Hub

    emoji


    Generated Image Alt-Text
    [edited by: RWS Community AI at 10:12 PM (GMT 0) on 3 Feb 2025]