Importing xlsx (with nine tabs) in bilingual form
Thread poster: Chris P.

Chris P.
United Kingdom
Local time: 12:59
German to English
Nov 24, 2015

memoQ 2015:

I'm having issues importing an Excel xlsx which contains nine different tabs (or sheets, if you prefer).

It imports just fine using the "multilingual delimited text filter" but only imports the first tab, instead of all nine.

Any and all suggestions most welcome.

Thanks in advance!


 

Mario Freitas  Identity Verified
Brazil
Local time: 08:59
Member (2014)
English to Portuguese
+ ...
I had that problem, too Nov 24, 2015

I had the same problem, and I found the solution here:

http://kilgray.com/memoq/60/help-en/index.html?microsoft_excel_documents_xls_.html


 

Chris P.
United Kingdom
Local time: 12:59
German to English
TOPIC STARTER
Thanks Mario Nov 24, 2015

Mario Freitas wrote:

I had the same problem, and I found the solution here:

http://kilgray.com/memoq/60/help-en/index.html?microsoft_excel_documents_xls_.html


Thanks for your input, Mario!

I've already tried this method, which works fine, except that the import required is a simple bilingual Column A & B, for source and translation respectively.

Best regards!


 

Stepan Konev  Identity Verified
Russian Federation
Local time: 14:59
English to Russian
For multilingual delimited text filter, Nov 24, 2015

you need to mark source and target for each tab (= Sheet#), where the leftmost tab is #1, next tab is #2, etc.
Have you done this?

*If you do not see this 'Columns' tab in memoQ, uncheck the 'Simple bilingual configuration' box.

Update: If you use same pattern day to day (e.g. Column A = source, B = target for all sheets), then you can mark source and target for 15 sheets once and save your pattern configuration using the red cross diskette button. Even if you actually have less tabs (say 9) than you marked (say 15), you will not need to mark those 9 tabs every time, but just select your saved pattern from the drop-list.

[Edited at 2015-11-24 08:33 GMT]


 

Chris P.
United Kingdom
Local time: 12:59
German to English
TOPIC STARTER
Excellent advice Nov 24, 2015

Thank you so much, Stepan, it worked like a charm!

The mistake I made (as you mentioned) was selecting "Simple bilingual configuration" under the Base Format tab.

Brilliant, thank you very much!

icon_smile.gif

Added:
And thanks also for the great suggestion in your update!


[Edited at 2015-11-24 14:53 GMT]


 


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


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

Importing xlsx (with nine tabs) in bilingual form

Advanced search






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

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 »



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