How to translate an excel document keeping the source language column
Thread poster: Alessandra Armenise

Alessandra Armenise  Identity Verified
United Kingdom
Local time: 02:00
English to Italian
+ ...
Dec 27, 2016

Hi there,

Is it possible to translate an excel document in OmegaT turning it into a bilingual document?
I would like to be able to export having 2 columns and not the target language column replacing the source one.

Also, it would be amazing if someone had a solution for the lines mix-up old problem.

Thanks and happy festive season!


Direct link Reply with quote
 

Susan Welsh  Identity Verified
United States
Local time: 21:00
Member (2008)
Russian to English
+ ...
two columns Dec 27, 2016

What I do is to copy the column with the source text into a Word file, translate it, and then paste it back into the Excel file, in the second column.

I don't know what you mean by the "lines mix-up old problem."


Direct link Reply with quote
 

Mair A-W (PhD)
Germany
Local time: 03:00
Member (2016)
French to English
+ ...
yup Dec 27, 2016

As wendy said, but without the word document: I save a second copy of the source elsewhere, translate it with omegat, open up the translated document, select the translated column, and paste it into my spare source copy. boom, done. have not experienced a lines mix-up problem.

Direct link Reply with quote
 

Alessandra Armenise  Identity Verified
United Kingdom
Local time: 02:00
English to Italian
+ ...
TOPIC STARTER
thanks, but... Dec 27, 2016

Hello guys, thank you for your help!

I do use the workaround explained by Mairaw, I just wanted to know if there was a method to make OmegaT do all this, producing a bilingual document like the sdlxliff ones.

As for the mix-up, unfortunately, I'm not able to find the relevant thread at the moment, but there is a common problem importing excel files: some rows get mixed up in CAT tools and the segments don't appear in the correct order.

Thanks!


Direct link Reply with quote
 

Didier Briel  Identity Verified
France
Local time: 03:00
Member (2007)
English to French
+ ...
The random order is a known issue Dec 27, 2016

Alessandra Armenise wrote:
As for the mix-up, unfortunately, I'm not able to find the relevant thread at the moment, but there is a common problem importing excel files: some rows get mixed up in CAT tools and the segments don't appear in the correct order.

It's a known issue in OmegaT:
https://sourceforge.net/p/omegat/bugs/288/

If your document, doesn't include macros, etc., there is a simple workaround: from Excel, save as XML Spreadsheet 2003.

Didier


Direct link Reply with quote
 
esperantisto  Identity Verified
Local time: 05:00
Member (2006)
English to Russian
+ ...
No Dec 28, 2016

Alessandra Armenise wrote:
…OmegaT do all this, producing a bilingual document like the sdlxliff ones.


OmegaT produces TMX files that are bilingual documents and can be converted to spreadsheet files if necessary. It can’t, however, produce Excel files of the kind that you want because OmegaT generally can’t change source document structures, it only replaces translatable source texts with respective translations.


Direct link Reply with quote
 

Alessandra Armenise  Identity Verified
United Kingdom
Local time: 02:00
English to Italian
+ ...
TOPIC STARTER
It works (random order issue) Dec 29, 2016


If your document, doesn't include macros, etc., there is a simple workaround: from Excel, save as XML Spreadsheet 2003.


Thanks a million!


Direct link Reply with quote
 

Alessandra Armenise  Identity Verified
United Kingdom
Local time: 02:00
English to Italian
+ ...
TOPIC STARTER
ok Dec 29, 2016

esperantisto wrote:
It can’t, however, produce Excel files of the kind that you want because OmegaT generally can’t change source document structures, it only replaces translatable source texts with respective translations.


Thanks! So the only solution would be to create a bilingual document from excel before importing it to OmegaT I guess. i don't know if it is possible. Probably it is easier to keep working around though.

Thanks everybody


Direct link Reply with quote
 


There is no moderator assigned specifically to this forum.
To report site rules violations or get help, please contact site staff »


How to translate an excel document keeping the source language column

Advanced search






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 »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »



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