Running Excel translation in TRADOS
Thread poster: Ivan Tobias

Ivan Tobias  Identity Verified
United Kingdom
Local time: 00:16
Slovak to English
+ ...
Jul 31, 2010

Hi,


I have a question/query regarding excel running in Trados and I hope that someone will know what to do.

I have an Excel file with a translation where one column is the source language and the column next to it is the target language. However it's a massive file (talking about several tens of thousands words), which makes it very difficult to ensure consistency using just Excel. Therefore, I would want to open this file in Trados (TagEditor) so that each source would have its corresponding translation as it is in this Excel file. Then I could easily go through the entire file a see what's what.

Does anyone know how to do that?


Thanks

Ivan


Direct link Reply with quote
 

Emma Goldsmith  Identity Verified
Spain
Local time: 01:16
Member (2010)
Spanish to English
Hide source column Jul 31, 2010

Open your file in Excel, copy your source text column into the target column. Hide your source text column, save and then open it in Tag Editor.
Your source text will then be preserved.


Direct link Reply with quote
 

Ivan Tobias  Identity Verified
United Kingdom
Local time: 00:16
Slovak to English
+ ...
TOPIC STARTER
in the same column? Jul 31, 2010

Hi Emma,

Thanks for your swift response to my post.

Let me recap what you want me to do. You want me to highlight the entire source column and copy it into the target column. Could you please tell me where in the target column? Above the target text, below it? How will Trados recognise the difference between the source and the target and how will it then assign target to each corresponding source?
BTW, what do you mean by "hiding the source text column"? That won't exist any more once I copy it into the target one, will it?

Looking forward to your clarification...

Cheers


Ivan


Direct link Reply with quote
 

Emma Goldsmith  Identity Verified
Spain
Local time: 01:16
Member (2010)
Spanish to English
Isn't the target column empty? Jul 31, 2010

In that case I don't understand what you mean.
I thought you had source text in one column and an empty column next door where you want to insert the translation.
Are you saying you have already got the translation in the target column and you want to revise it? Have you got the translation in a TM?


Direct link Reply with quote
 

Ivan Tobias  Identity Verified
United Kingdom
Local time: 00:16
Slovak to English
+ ...
TOPIC STARTER
explanation Jul 31, 2010

Yes, I do have both. The Excel file has the source text in one column and the target text in another column. Basically, the translation was done in Excel where someone translated text in the source column to the column next to it (the target column). There is no translation memory. But since the file is huge, I would want to open it in Trados whilst preserving both, the source and the corresponding target text. Is that possible?


Regards

Ivan


Direct link Reply with quote
 

Emma Goldsmith  Identity Verified
Spain
Local time: 01:16
Member (2010)
Spanish to English
Ah... Jul 31, 2010

...so you have a bilingual excel file that you can't open as such in Tag Editor.

The only thing I can think of is separating the columns into 2 separate excel files (source column in one file, target column in the other) and then aligning them with Winalign. That way you would could populate a TM with your translation. Then you could translate the file with the source column in it, but preparing it as I mentioned in my first reply (copy your source text column into the target column. Hide your source text column, save and then open it in Tag Editor.).
You would use your new TM to get a ttx with source and target segments and then you could revise it in Tag Editor.

It sounds quite laborious, but I think it's a possible solution.


Direct link Reply with quote
 

Evija Rimšāne  Identity Verified
Latvia
Local time: 02:16
English to Latvian
Creating a TM Jul 31, 2010

This will help you to easily create a TM from the source and the target text: http://www.proz.com/forum/sdl_trados_support/155516-trados_translation_memory.html
Next step is up to your imagination.
Good luck!

[Edited at 2010-07-31 09:54 GMT]


Direct link Reply with quote
 

SDL Community  Identity Verified
United Kingdom
Local time: 01:16
English
Use Olifant Jul 31, 2010

Ivan Tobias wrote:

Yes, I do have both. The Excel file has the source text in one column and the target text in another column. Basically, the translation was done in Excel where someone translated text in the source column to the column next to it (the target column). There is no translation memory. But since the file is huge, I would want to open it in Trados whilst preserving both, the source and the corresponding target text. Is that possible?


Regards

Ivan


Hi Ivan,

One solution that might be useful for you would be to save the excel file as a tab delimited file and then create an empty TM using Olifant that you can import the two column tab delimited file into.

Then save the file as a TMX so you can bring it easily into your Trados application (2007 or 2009).

Edited after : I forgot a bit. Create a TM in one language direct in Trados and import the TMX, then create another TM in the opposite language direction and import the same TMX.

Now hide the target column and open the excel file and translate the source. When you are done save the target file. Now hide the source column in the newly translated excel file and translate the target with the other TM. Once you are done save the target file and now you have a fully checked excel file.

Regards

Paul


[Edited at 2010-07-31 12:17 GMT]

[Edited at 2010-07-31 12:22 GMT]


Direct link Reply with quote
 

Anne Bohy  Identity Verified
France
Local time: 01:16
English to French
WordFast Pro Jul 31, 2010

Although I do understand that it is not the right time to change to another tool, FYI: WordFast Pro is (to my knowledge) the only CAT tool which allows to define source and target columns in an Excel file, and which will automatically produce the Excel output file with the source AND translated text in the right columns.
I have not experimented with partially translated files, but this should work to!
Usually, when I have to translate in a multi-column Excel file, I turn to WordFast Pro... It avoids some headaches.


[Edited at 2010-07-31 13:21 GMT]


Direct link Reply with quote
 

SDL Community  Identity Verified
United Kingdom
Local time: 01:16
English
How do you do that? Jul 31, 2010

Hi Bohy,

I would be very interetsed to know how to do that? I have a copy of Wordfast Pro and as far I was aware you could set a column for the translated text to go (which is a nice feature), but you can't open a file with source and target in it so you can work on the file as a bilingual document.

Am I wrong?

Regards

Paul


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 »

Running Excel translation in TRADOS

Advanced search







SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »



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