Excel: handling multiple columns where text should be translated
Thread poster: TranslateLab

TranslateLab  Identity Verified
Belgium
Local time: 19:43
English to French
+ ...
Nov 10, 2014

Hello everybody,

I can easily translate an excel file with 2 columns (source language, target language) with Trados 2011.
The problem is when I have to deal with companies that use the same file for every language. It looks like this:

ENGLISH FRENCH GERMAN
ORIGINAL1 TRANSL1 TRANSL1
ORIGINAL2 TRANSL2 TRANSL2

I also have some clients that work with multiple columns where text should be translated, like this:

ENGLISH ENGLISH FRENCH FRENCH GERMAN GERMAN
ORIGINAL1 ORIGIN1 TRANSL1 TRANSL1 TRANSL1 TRANSL1
ORIGINAL2 ORIGIN2 TRANSL2 TRANSL2 TRANSL2 TRANSL2

Does anybody know how to tackle this problem?
Looking forward to your contributions.


Direct link Reply with quote
 
Jean-Paul Salaün  Identity Verified
Canada
Local time: 13:43
Member
English to French
Excel: handling multiple columns where text should be translated Nov 10, 2014

Hi Nathanè

Just copy the original columm in a new excel file,
then use it to open a new project in SDL Studio
then at the end copy the translated file (which should on column) in your target columm in the original Excel file.

Just pay attention that the segmentation could produce more cells in the final translated file.

This is a little tricky but it works
I use it often
JP


Direct link Reply with quote
 

Minh Nguyen  Identity Verified
Vietnam
Local time: 00:43
Member (2014)
English to Vietnamese
Hide column or content Nov 10, 2014

Hi Nathan

If you just want to translate a certain column then you only need to hide the other columns in Excel and import into Trados Studio. Hidden content wont be shown in Trados Studio editor.

Hope this helps.

LD

[Edited at 2014-11-11 05:34 GMT]


Direct link Reply with quote
 
Jean-Paul Salaün  Identity Verified
Canada
Local time: 13:43
Member
English to French
Excel: handling multiple columns where text should be translated Nov 10, 2014

Hi Lindhan

seems your solution is better than mine
and faster.
thanks for the tip
JP


Direct link Reply with quote
 

TranslateLab  Identity Verified
Belgium
Local time: 19:43
English to French
+ ...
TOPIC STARTER
Not trying to translate one column only Nov 10, 2014

Hi guys,

I'm not trying to translate one column at a time here but three columns.

For instance we have 3 columns with English original text and 3 columns where the translated French version should be.

You have provided tips for 2 columns in total I think in my example, I'm talking about 6.

Thanks for your help anyway!

Nathan


Direct link Reply with quote
 

Heinrich Pesch  Identity Verified
Finland
Local time: 20:43
Member (2003)
Finnish to German
+ ...
Whatever, copy into new file and copy translation back Nov 11, 2014

For this strange case, where two or more columns should be translated, there is no other solution. But if you have one source column A and you need to have the translation in column X, I use Wordfast Pro and the advanced feature. I don't know of other software that does this in one step.

Direct link Reply with quote
 

SDL Community  Identity Verified
United Kingdom
Local time: 19:43
English
Same approach... Nov 11, 2014

Nathan Vander Heyden wrote:

I'm not trying to translate one column at a time here but three columns.

For instance we have 3 columns with English original text and 3 columns where the translated French version should be.

You have provided tips for 2 columns in total I think in my example, I'm talking about 6.



... where you would copy the English three columns into the location where the German is. Then hide everything else.

If there is some German already in there then this is trickier, but you could handle this too by creating three more columns in the Excel file and using a formula to only apply the English if there was no German present already. Then hide the rows with German too. Once complete copy the translated German into the missing cells and delete the additional columns you added.

Straightforward if you're comfortable with Excel and if there are not 500 files like this to deal with!

Regards

Paul


Direct link Reply with quote
 

TranslateLab  Identity Verified
Belgium
Local time: 19:43
English to French
+ ...
TOPIC STARTER
Thanks Nov 11, 2014

Thank you all for your help. Paul, unfortunately I have to deal with a lot of these files.
I'll manage another way

Nathan


Direct link Reply with quote
 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 20:43
Member (2006)
English to Turkish
+ ...
memoQ Nov 11, 2014

I am not a memoQ user but its multilingual text filter is great. Perhaps you can consider downloading the trial version to create your project and translate the memoq xliff files with Studio again.

See http://kilgray.com/memoq/62/help-en/index.html?multilingual_delimited_text_fi.html


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 »

Excel: handling multiple columns where text should be translated

Advanced search







TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



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