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

Chris P.
United Kingdom
Local time: 11:22
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: 09:22
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: 11:22
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:22
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: 11:22
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






TM-Town
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »



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