Cannot convert from xlsx to xml (Studio 2021)

I have a normal Excel file (xlsx) and want to convert it to xml to add this to an existing sdltb later on. Unfortunately, there are no available fields on the column headers which ought to be there. What could be wrong and how to fix this. By the way, I tried an older xls from last year. On that left column were clearly "German" and "English".
Vokabeln 04-2001 deutsch-englisch.xlsx    Screenshot of SDL MultiTerm Convert showing a dialog box with empty available fields for column headers. A red exclamation mark indicates an error next to the empty field.



Generated Image Alt-Text
[edited by: RWS Community AI at 1:53 AM (GMT 0) on 15 Nov 2024]
emoji
  • Your problem is most likely this:

    Screenshot showing Excel workbook tabs with 'Tabelle1' highlighted, indicating it is selected, and other tabs 'Tabelle2', 'Tabelle3', 'Tabelle4' unselected.

    I didn't test it but I think if you remove the first empty worksheet, or move the "Tabelle1" to the left, then it will work just fine.

    I also wonder why you don't use the Glossary Converter for this, it's much easier although you'll still need to amend your workbook.

    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: Trados AI at 11:52 AM (GMT 0) on 4 Mar 2024]
  • Tks a bunch, Paul! Your expertise is always welcome, and your gentle way to indicate that there might be tomatos on my eyes (German slang). I have followed your instructions, and everything works out perfectly now. Take care and don't let that darned virus knibble on you.