Convert Excel file into XML with comments

Dear community, 

I have an Excel file with three columns: German - Italian - Source (where I've found the translations). Is there a way to convert this Excel file into a TMX and keep the "Source" column at the same time? As a matter of fact, I'd like to import this Excel file into an existing TB where it is already possible to add information concerning the source (in the TB structure, I added the "Source" field).

I use SDL Trados Studio 2019.

Thanks!

  • Bit of confusion here I think.  Do you want an XML, a TMX.. or do you simply want to create a termbase from this or import into an existing termbase?

    Most likely the best solution for you will be to use the Glossary Converter from the appstore but I think a slightly clearer explanation would be helpful so we give you the right information.

    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

  • Hello Paul, 

    thank you for helping me. Sorry, I wrote TMX in the text but I meant XLM as in the title. This is my situation: I have an Excel file and a TB I created some time ago. I'd like to import the Excel file into this TM. In order to do this, I usually use SDL Multiterm Convert 2019, which converts the Excel file into a TMX file. Then I import this file into the TB. I've already added some definitions to the structure of the TB ("source", "comments" and "grammar" ). The fact is that I do not only need to import the first two columns of the bilingual Excel file (A: German and B: Italian), but also the third one, which contains references to the websites where I found the translations. Is there a way to set this conversion in such a way that, at the end, I can import the new terms and the references to the source as well (see picture)?

    Screenshot of Trados Studio Termbase viewer showing an entry with fields for German language, source, comments, and grammar. (Termbase viewer in the Editor window)

    At the moment, I don't care if the references to the source are added at term level or at language level. Maybe it is better to add them at language level, but it is the same.

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 3:42 AM (GMT 0) on 29 Feb 2024]
  • Here's one way to tackle this:

    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

  • Thank you so much for your detailled answer!

    Just one last question:

    Let’s suppose that I also wish to add information on the meaning of the words themselves at term level, such as here:

     Trados Studio interface showing a term entry with a description in English, German term 'Abholzigkeit' and its standard, and an Italian term 'conicit ' with its description.

     

    In this case, it is sufficient to add the “Description” column (in this specific case) before the German column. That is, taking the screenshot below as an example, column A would contain the description, column B the German terms and so on… then the process you described in your video remains the same, right?

     

    Excel spreadsheet with columns labeled 'German', 'Source', and 'Italian', containing URLs and corresponding terms 'Abholzigkeit' and 'conicit '.

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 3:42 AM (GMT 0) on 29 Feb 2024]
  • I guess the best thing to do is play with it!  It's pretty simple as you can see.

    A good tip is to do this:

    1. create the termbase in MultiTerm that you want with a few fully populated entries (maybe include some synonyms in there too)
    2. convert the termbase to Excel using the Glossary Converter

    Now you can see exactly what it will be looking for in terms of structure.

    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