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

TranslateLab  Identity Verified
Belgium
Local time: 17:20
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: 11:20
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: 23:20
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: 11:20
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: 17:20
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: 18:20
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: 17:20
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: 17:20
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: 19:20
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







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 »
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 »



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