TagEditor 2007/8.0 - how to populate source/target segments from a partially pre-translated Excel?
Thread poster: Tomas Mosler, DipTrans IoLET MCIL MITI

Tomas Mosler, DipTrans IoLET MCIL MITI  Identity Verified
Czech Republic
Local time: 10:50
Member (2008)
English to Czech
Feb 22, 2010


is there any easy way how to create ttx file with pre-translated target segments from Excel file, where column A contains source language segments and column B contains target language segments and column B has some cells empty (to be newly translated)?

I'd imagine after doing the trick, I have a ttx file where new lines are to be translated and existing lines are included in the ttx by default (and shown as green/100% fuzzy). I'm aware of a (pre)translation option within Workbench so I could perhaps use WinAlign, but this was somehow not able to recognize empty cells as empty segments and the alignment got a bit messy.



Adam Łobatiuk  Identity Verified
Local time: 10:50
Member (2009)
English to Polish
+ ...
Not very easy but quite possible Feb 23, 2010

You need to create a TM export/import file from the XLS. First, you need to filter for non-empty rows in Excel and copy them to another Excel file. Now, you can manually add TM export file (Trados or TMX) tags in the surrounding cells, or just download the free Olifant tool, save your file as tab delimited text, and import it into Olifant. Save as TMX, import into Trados, and enjoy your new TMicon_smile.gif

I'm not sure how the TTX file relates to the XLS, but you could make another copy of your XLS, hide or delete the column with the translated strings, and open it in TE.

BTW. segment coloring in Tag Editor only works with some file types, so you might not get the colors you want.


Achim Herrmann
Local time: 10:50
English to German
SDL Passolo 2009 can process the file Feb 23, 2010

Hello Tomas,

this kind of file type, where Excel is misused as a database table can be handled without any (manual) pre-processing and post-processing using SDL Passolo 2009. A special Excel Add-In is available, where you can define the source column, the translation column(s) and columns for additional meta data like ID or max. length for the translation.

Perhaps a good choice if you have to process not only one single file.



Jaroslaw Michalak  Identity Verified
Local time: 10:50
Member (2004)
English to Polish
Trados filter Feb 23, 2010

Trados 2007 has a rather obscure feature that allows importing a delimited file into TagEditor.

First you have to run SDL Trados Filter Settings application. Then select SDL Generic Delimted files. There you have a window which allows you to set the delimiter, which column is source, which is target, etc.

Note: Of course, to use that function you have to save the Excel file to a delimited file (tab or comma), so you will lose all the formatting the text might have...


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

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

TagEditor 2007/8.0 - how to populate source/target segments from a partially pre-translated Excel?

Advanced search

Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

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

Join this translator’s group buy brought to you by ProZ.com 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 ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search