Generating a TM from a bilingual xlsx with many tabs

Question

I got a bilingual xlsx file with past translations from a client and I would like to generated a TM from it. The xlsx file has many (30-40) tabs, each containing a column with source English and another column with target Japanese (there were other columns but I deleted them). What is an efficient way to generate a TM? 
 I see that Glossary Converter can generate a tmx but it works with an xlsx file with only one tab. Separating 40 or so tabs into xlsx files and combining them into one TM is time consuming and I do not want to get into it. 
 Your help would be greatly appreciated! 
 Yuki

Yukihiko Okada · Accepted Answer

Hi Paul, 
 Thank you for pointing me to the right direction. I fund a nice person who makes exactly what I wanted to do available: https://www.extendoffice.com/documents/excel/1184-excel-merge-multiple-worksheets-into-one.html 
 I used the VBA code here to merge all the tabs into one. I then used Glossary Converter to get a tmx and imported into a new TM. I am now ready to go! 
 Yuki

Paul · Answer

Yukihiko Okada 
 I think your best solution is to use a macro in Excel to combine all the tabs into just one, then use the GlossaryConverter. It&rsquo;s probably fairly trivial but I&rsquo;m replying from my phone so can&rsquo;t help more at the moment. If you can&rsquo;t find how to do that just reply and if nobody answers before Monday we can give you a bit more assistance.

Paul · Answer

Yukihiko Okada 
 Thanks for sharing the resource you found... that looks helpful. I'm very happy you found the solution you were looking for.

Trados Studio > 1. Trados Studio

Generating a TM from a bilingual xlsx with many tabs

Top Replies