How do I create a bilingual excel file in Studio 2015?
Thread poster: Andrea Garfield-Barkworth

Andrea Garfield-Barkworth  Identity Verified
Germany
Local time: 11:18
Member (2015)
German to English
Oct 29, 2015

I have been sent a 3-column excel file (.xslx if that makes any difference), so how do I go about creating a bilingual file. Must I add the columns before I import the file into Studio 2015 or is there some kind of automatic process?

 

Mark Nathan  Identity Verified
France
Local time: 11:18
Member (2002)
French to English
+ ...
One way Oct 29, 2015

I am not sure if I have understood your situation - you have an excel file with three columns of source language, and you wish to create a bilingual excel file with six columns? For example, alternating columns with the target language to the right of each source language column?

If this is the case, then simply translate the source excel file (without changing it in any way) in Studio and generate an excel document with three columns of target language.

Then create a new excel document and copy and paste the source/target columns into it.

A bit boring, but it works!


 

Andrea Garfield-Barkworth  Identity Verified
Germany
Local time: 11:18
Member (2015)
German to English
TOPIC STARTER
Thanks Mark but... Oct 29, 2015

Yes, that is how I would usually go about it but I was hoping there was an automatic way using Studio 2015.

I know you can lock out columns when you receive a file and some may not need to be translated. I just wondered if you could sort of add them as an automatic process or something.


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How do I create a bilingual excel file in Studio 2015?

Advanced search







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 »
BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »



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