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

TranslateLab  Identity Verified
Belgium
Local time: 23:58
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.


 

Jean-Paul Salaün  Identity Verified
Canada
Local time: 17:58
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


 

Minh Nguyen  Identity Verified
Vietnam
Local time: 04:58
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]


 

Jean-Paul Salaün  Identity Verified
Canada
Local time: 17:58
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


 

TranslateLab  Identity Verified
Belgium
Local time: 23:58
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 thinkicon_smile.gif in my example, I'm talking about 6.

Thanks for your help anyway!

Nathan


 

Heinrich Pesch  Identity Verified
Finland
Local time: 00:58
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.

 

SDL Community  Identity Verified
United Kingdom
Local time: 23:58
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 thinkicon_smile.gif 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


 

TranslateLab  Identity Verified
Belgium
Local time: 23:58
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 wayicon_smile.gif

Nathan


 

Selcuk Akyuz  Identity Verified
Turkey
Local time: 00:58
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


 


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







SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



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