About this blog

Translator's Shack is a collection of links, news, reviews and opinions about translation technologies. It's edited and updated by Roberto Savelli, an English to Italian translator, project manager and company owner of Albatros Soluzioni Linguistiche, a team of English-Italian translators, which hosts and supports this blog.


The Life as a PM category, managed by Gabriella Ascari, contains topics that are less technical in nature, but which we're sure will be appreciated by owners of small translation businesses and freelancers.


Here are links to my pages on some social networks:


Highly recommended:


Importing the Microsoft Terminology Collection

The latest Tool Kit contains a nice description and details about importing the newly-available

Microsoft Terminology Collection into the translation environment of your choice. If your tool does not support the TBX format, however, you will have to transform the data into the proper format (e.g. CSV) before importing it.

The Tool Kit suggests using the excellent XBench for importing the TBX terminology file and exporting it into a comma-separated file. It also warns that XBench drops the “definition” field which, in my opinion, contains very useful context information. So in this case I’d say XBench is not the way to go.

By digging into the memoQ user discussion formum, I found this useful tidbit of information by Denis Hay:

True, we don’t have official support for TBX yet, but just add ".xml" to your file, open in Excel 2003 or 2007 and save as Unicode text. You will easily be able to import that into any memoQ termbase, picking only those columns you want.

Excellent. This should solve the problem and make the TBX easily accessible even if your favorite translation tool does not support this format natively (as is currently the case with memoQ).

Another solution that I tried and found to be working flawlessly is using Wordfast Pro, which supports TBX out of the box and allows you to export an imported glossary to CSV format. Wordfast Pro is available in a free trial version, which has some limitations. I’m not sure if the free version will allow to import and then export the whole Microsoft glossary, but my guess is it will.

3 comments to Importing the Microsoft Terminology Collection

  • Hi Roberto,

    Thank you very much for the tips. I own Wordfast Pro full version, however I can’t seem to export the imported glossary to CSV. It only lets me export it to Tab delimited txt or TBX (again). Thanks.

    Best.

    • Roberto Savelli

      Hi Daniel,
      thanks for letting me know. Tab-delimited is probably what I intended. As a file format it’s probably even easier to handle than CSV, since the strings do not need to be enclosed in quotes. You should be able to import or open any tab-delimited file with Excel or OpenOffice’s Calc.

  • Hey, I have noticed that on occasion this page displays a 500 error. I thought you would be keen to know. Regards

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>