This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Spreadsheet (Excel) - Write translation in different column
Thread poster: Mirko Mainardi
Mirko Mainardi Italy Local time: 09:05 Member 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 Adriat... See more
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)... ▲ Collapse
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Stepan Konev Russian Federation Local time: 11:05 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 delim... See more
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' http://kb.memoq.com/article/AA-00447/0/Using-the-Multilingual-filter-for-terminology-translation.html 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.
Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value