MemoQ Multilingual Excell Import Problems
Objavljivač niti: Spela Groselj

Spela Groselj  Identity Verified
Slovenija
Local time: 00:57
španski na slovenački
+ ...
Apr 8

Hi!

I am having troubles importing certain columns from the Excell sheet to my MemoQ. I have selected the columns which I wish to import: B column as a source text and C column would be my translation text. Here comes the problem: I can select the "Translation", but MemoQ doesn't save it. Therefore, it doesn't import the document as there is no "Translation" column.


 

Tomasz Sienicki  Identity Verified
Danska
Local time: 00:57
Član (2007)
danski na poljski
+ ...
Indicate the source column Apr 8

Remember that after specifying “Meaning of selected column” as “Translation” you have to indicate the source column in the “For column” drop-down list.

HTH.


 

Spela Groselj  Identity Verified
Slovenija
Local time: 00:57
španski na slovenački
+ ...
POKRETAČ TEME
When selecting "Translation" the option "source coulmn" remains locked. Apr 8

Thank you Tomasz,

I have tried this, but it doesn't give me an option. If I select "Context", "Source Text" or basically anything else, it works just fine. The only thing it doesn't let me select is the "Translation".

I have also tried another option: basic 2 language text, but the Excell file is locked, therefore it just imports the first sheet.


 

Tomasz Sienicki  Identity Verified
Danska
Local time: 00:57
Član (2007)
danski na poljski
+ ...
Works for me Apr 8

I use this filter several times a month and it simply works. You must be making some basic mistake. Please have a look at the instruction at https://docs.memoq.com/current/en/Places/multilingual-excel-and-delimit.html

Good luck!


 

Stepan Konev  Identity Verified
Ruska Federacija
Local time: 01:57
engleski na ruski
screenshot Apr 8

First you say: I can select the "Translation"
Then you say: The only thing it doesn't let me select is the "Translation".
Which one of these statements is correct?
You should select B and mark it as Source text. Then you select C and mark it as Translation/For column B/Target language.
What is a 'basic 2 language text'? Which Excell file is locked (and where)?
Can you attach a screenshot?


[Edited at 2021-04-08 22:22 GMT]


 

Spela Groselj  Identity Verified
Slovenija
Local time: 00:57
španski na slovenački
+ ...
POKRETAČ TEME
Screenshhot Apr 9

Stepan Konev wrote:

First you say: I can select the "Translation"
Then you say: The only thing it doesn't let me select is the "Translation".
Which one of these statements is correct?
You should select B and mark it as Source text. Then you select C and mark it as Translation/For column B/Target language.
What is a 'basic 2 language text'? Which Excell file is locked (and where)?
Can you attach a screenshot?


[Edited at 2021-04-08 22:22 GMT]


Hi!

Thank you! I have solved it.

Alternatively, I tried to import it as a bilingual document, where you have an option to say: all columns B are "Source Text" and all columns C are "Translation". In this case, it imported just the first sheet. When I checked the Excell, if it's possible to save every sheet as a separate document, I noticed that this was not an option, as the document was protected for this kind of changes.



[Edited at 2021-04-09 05:45 GMT]


 


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


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

MemoQ Multilingual Excell Import Problems

Advanced search






Trados Studio 2021 Freelance
The leading translation software used by over 270,000 translators.

Trados Studio 2021 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2021 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »
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 »