Spreadsheet (Excel) - Write translation in different column
Thread poster: Mirko Mainardi

Mirko Mainardi  Identity Verified
Local time: 04:41
English to Italian
Aug 2, 2017

Any news about this? I Googled for it, even found an old thread from more than 4 years ago here, but never a real 'solution'. Copying the source column where you want the translation before importing the file is what I've been doing myself, but it's not really feasible when you're dealing with a lot of individual files. I haven't installed Adriatic yet, so I don't know if they finally added this functionality. Or maybe I just missed it and it's hidden somewhere...

At any rate, it seems quite weird that this option is not there, along with the import filters for spreadsheet-type files that let you select specific ranges and specify offsets for other values (such as comments, for instance). IMHO something like that (e.g. write translation to cell XY+1/X+1Y or column+1/row+1, etc.) would be very useful. Plus, Studio does have a similar option (for the "Bilingual Excel" and "CSV" file types)...


Stepan Konev  Identity Verified
Russian Federation
Local time: 06:41
English to Russian
It's been there for years Aug 2, 2017

This option is available from 2013 as a minimum. And until now it works much better with memoQ. Unlike Trados that processes only simple structure with one worksheet, memoQ can process multiple worksheets even when you have different column letters for source and target in different worksheets.
Import with options > Select 'Multilingual delimited text files'
The above article describes CSV, but actually it supports xlsx too.
If you need to mark different columns for source and target in different worksheets, memoQ counts such worksheets as 1, 2, 3, 4 ... etc. from left to right regardless of their actual names.

Another major inconvenience with T. is that you have to make it understand what type of Excel you want to translate (either normal or bilingual). Otherwise it cannot recognize the format automatically. Even when you manually select Bilingual Excel when browsing for the file, T. always recognizes it as regular Excel. You have to either disable other Excel modes or move the Bilingual Excel up so that it is above the others.
memoQ is much more user-friendly in this regard.

[Edited at 2017-08-03 10:54 GMT]


Mirko Mainardi  Identity Verified
Local time: 04:41
English to Italian
Wow, thanks a lot Stepan! Aug 2, 2017

So I had really just missed it! At any rate, thank you very much Stepan, you just saved me quite a bit of fiddling around.


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

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

Spreadsheet (Excel) - Write translation in different column

Advanced search

PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

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 »

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