Exporting TM to Excel and vice-versa Thread poster: Αlban SHPΑTΑ
| Αlban SHPΑTΑ United States Member (2008) English to Albanian + ...
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... See more 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!! ▲ Collapse | | | Jorge Payan Colombia Local time: 05:49 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/ Saludos | | | 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 | | | Αlban SHPΑTΑ United States Member (2008) English to Albanian + ... TOPIC STARTER 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! | |
|
|
AtelieruldeTrad Romania Local time: 12:49 Member (2015) English to Romanian + ...
Hi, Would you be so kind to add me to the group or send me the marcos at [email protected] ? Thanks, your help will be much appreciated. Elena | | | TM data converter macro needed | Mar 27, 2016 |
Dear Elena, Would you be so kindly send me the marcos to me as well to [email protected] ? Your help will be much appreciated and nice, Best Regards, Bahar | | | 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 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 » |
| Trados Studio 2022 Freelance | The leading translation software used by over 270,000 translators.
Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop
and cloud solution, empowering you to work in the most efficient and cost-effective way.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |