Exporting TM to Excel and vice-versa
Thread poster: Αlban SHPΑTΑ

Αlban SHPΑTΑ  Identity Verified
Member (2008)
English to Albanian
+ ...
Aug 25, 2010

I have a document in a language pair different from my working languages, which I need to outsource to a colleague of mine who doesn't use any CAT tool.

I think I have seen this somewhere, so I am almost sure that what I am talking about can be done, but I just don't know how. Not a Trados expert myself either... Now, I have all the segments of the document inserted into a new TM (source and target has the same text) and I need to export this TM in an Excel document with the source in one column and the target in another column. Then my colleague can translate one of the columns like he usually does. After he is done with that, I want to import the translation in the Excel file back to the TM (or a different TM). I could just do this by copy pasting the translation somehow, but the document is huge and it will be really time consuming... Can anyone help me with this?

I would be very grateful for any hints!!

Direct link Reply with quote

Jorge Payan  Identity Verified
United States
Local time: 03:01
Member (2002)
German to Spanish
+ ...
Plustoyz should do the trick! Aug 25, 2010

This free collection of macros, by Arkady Vysotsky, will allow you convert from TRADOS TM export (.txt) to Word table.

Then you can paste the Word table into an empty Excel table and send it to your colleague.

When the translation is done, you will convert from Excel to TRADOS-like segmented text, to be cleaned e.g. on an empty TRADOS TM

Download it from here :http://tech.groups.yahoo.com/group/wordfast/files/


Direct link Reply with quote

Soonthon LUPKITARO(Ph.D.)  Identity Verified
Local time: 15:01
Member (2004)
English to Thai
+ ...
TM data structure Aug 26, 2010

Trados *.txt TM date structure cntain many rows and you need a special macro to adjust into Excel columns. For WordFast TM, data structure has one row and I can paste into Excel column easily [data paste options]. But an easier method is opening WC *.txt TM in MS Word, select all, convert text to table, and paste the table into Excel columns. You can import the Word table into WF TM in reverse steps.

Soonthon Lupkitaro

Direct link Reply with quote

Αlban SHPΑTΑ  Identity Verified
Member (2008)
English to Albanian
+ ...
Thanks for your help! Aug 26, 2010

Thank you so much for your help Jorge and Soonthon! This macro works like a charm

Much appreciated indeed!

Direct link Reply with quote

AtelieruldeTrad  Identity Verified
Local time: 10:01
Member (2015)
can't access Sep 2, 2015


Would you be so kind to add me to the group or send me the marcos at elena.polearush@gmail.com ?

Thanks, your help will be much appreciated.


Direct link Reply with quote
Bahar Demirci
TM data converter macro needed Mar 27, 2016

Dear Elena,

Would you be so kindly send me the marcos to me as well to linguaeurope@gmail.com ?

Your help will be much appreciated and nice,

Best Regards,

Direct link Reply with quote

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

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

Exporting TM to Excel and vice-versa

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 »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »

  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search