Create TM Content From Table
Thread poster: Owen owenfw

Owen owenfw
Local time: 17:19
Finnish to English
+ ...
May 2, 2008

I have a two-column spreadsheet (xls) that I want to turn into TM content automatically. So in one column is my source and in the other the target. Anybody know how to do this without too much trouble?


Sylvain Leray  Identity Verified
Local time: 01:19
Member (2003)
German to French
Creating TM from an Excel file May 2, 2008

Maybe this topic or the topic which is linked in it will help you.


[Modifié le 2008-05-02 13:18]


Oscar Martin
Local time: 01:19
English to Spanish
+ ...
Create tm content from table May 2, 2008


There are two ways:
1. You can use PlusToyz (, which is a .doc file (with macros) that converts Excel Workbook into Trados file.
2. You can download XBench from
- Install the software and create a new project (File > New).
- Save the excel as tab .txt file. And add it to XBench as tab txt file.
- Go to Tools > Export items. In the output section, select the tmx format, insert the filename and language codes in the bottom.
- It is free
- XBench provides a unified and convenient view of the bilingual information, which can be prioritized by the user as required.
- You can create projects in which you upload very different sources: tabbed text files, MS glossaries, Exported Trados memories, XML trados multiterm glossaries, TMCX memories, .doc, .itd, .ttx bilingual files, etc.
- Xbench also features powerful Quality Assurance features, to check for consistency, numeric values and more.



Owen owenfw
Local time: 17:19
Finnish to English
+ ...
thanks! May 2, 2008

Thanks. I ended up just creating two docs, one with one column, and then using WinAlign, but I'll definitely check out the links you sent.


Vito Smolej
Local time: 01:19
Member (2004)
English to Slovenian
+ ...
PlusToyz.doc by Aleksij Visotski does all this May 2, 2008

from within word (sorry for the unformatted output):

+Toyz v0.34
Move cursor to any macro name and double-click it

Extended analysis in Wordfast
Counts TM matches and internal analogies within a document using Wordfast. To view internal analogies only, run this macro on an empty TM

Extended analysis in Trados
Counts TM matches and internal analogies within a document using Trados. Create a new TM or backup existing TM - it will be changed during analysis

File Maintenance

Creates a master document containing all the files in directory specified. Name of resulting document is __Master.doc. Useful when performing search-replace or spellcheck over several dozens of documents

Restores source text from segmented documents

Segmentation validity check
Checks Trados-like segmented file for segmentation errors.

Format conversions

Double-click the desired conversion, then open a document to convert. Before conversion, a backup copy with the same name and .BAK extension will be created.

Trados-like segmented text to Word table
Word table to Trados-like segmented text
Excel workbook to Trados-like segmented text
Wordfast TM to Trados-like segmented text
Trados TXT export to Word table
STAR Transit project to Trados-like segmented text and back
TTX (TagEditor) file to Trados-like segmented text and back

and if you REALLY want to see how to write the entries for global search and replaces between all those alternatives, the VBA code is open for every


Local time: 01:19
English to German
Yet another macro May 2, 2008

My simple macro might work, too.



Local time: 01:19
English to Hungarian
+ ...
how advanced May 3, 2008

All I did was take a look at an exported TM, insert a couple of columns into my xls, type in the appropriate tags and text, copy/paste the whole thing to word and use search and replace to correct the format where it was needed. Then copy/paste the whole thing under the header of the export and done.

This requires a bit more elbow grease but you're in total control. E.g. you can insert data like source document name etc. I am having some encoding troubles tho.

I'll take a look at the suggested tools, thanks.


Soonthon LUPKITARO(Ph.D.)  Identity Verified
Local time: 06:19
Member (2004)
English to Thai
+ ...
SDL maintain May 4, 2008

SDLX package has SDL Maintain that makes importing an Excel file or delimited file (e.g. cvs file) into a blank TM is quite easy.

Soonthon L.


Vito Smolej
Local time: 01:19
Member (2004)
English to Slovenian
+ ...
Correction: Arkadij Vysotsky May 4, 2008

is the name of the author of PlusToyz


To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Create TM Content From Table

Advanced search

PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
SDL Trados Studio 2017 only €435 / $519
Get the cheapest prices for SDL Trados Studio 2017 on

Join this translator’s group buy brought to you by and buy SDL Trados Studio 2017 Freelance for only €435 / $519 / £345 / ¥63000 You will also receive FREE access to Studio 2019 when released.

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search