MemoQ only imports the first row from an excel sheet
Thread poster: Alex Maslow
Alex Maslow
Alex Maslow
Local time: 16:50
English to Russian
Mar 23, 2021

Super weird issue. I have an excel file with multiple sheets. I'm trying to import strings from just one sheet using the multilingual delimited text filter. All I need is two columns, one for the source text and one for the translation. Thing is, it refuses to import the source text column, instead only importing the first row. What could possibly cause this? Also, when importing the file it gives me a lot of "merged with other cells, content ignored" messages. What is this?

[Edited at 20
... See more
Super weird issue. I have an excel file with multiple sheets. I'm trying to import strings from just one sheet using the multilingual delimited text filter. All I need is two columns, one for the source text and one for the translation. Thing is, it refuses to import the source text column, instead only importing the first row. What could possibly cause this? Also, when importing the file it gives me a lot of "merged with other cells, content ignored" messages. What is this?

[Edited at 2021-03-23 02:08 GMT]
Collapse


 
Stepan Konev
Stepan Konev  Identity Verified
Russian Federation
Local time: 13:50
English to Russian
Did you change configuration when you imported the file? Mar 23, 2021

After you set Multilingual delimited text filter, you also need to set filters by clicking the 'Change filter & configuration' button. In the 'Document import settings' window, go to the Columns tab. Set columns as source and target. Also notice the "Sheet #" field. Make sure you have selected the correct value (sheet number counting from left to r... See more
After you set Multilingual delimited text filter, you also need to set filters by clicking the 'Change filter & configuration' button. In the 'Document import settings' window, go to the Columns tab. Set columns as source and target. Also notice the "Sheet #" field. Make sure you have selected the correct value (sheet number counting from left to right).


[Edited at 2021-03-23 14:45 GMT]
Collapse


 
Alex Maslow
Alex Maslow
Local time: 16:50
English to Russian
TOPIC STARTER
Yes, absolutely Mar 23, 2021

Stepan Konev wrote:

After you set Multilingual delimited text filter, you also need to set filters by clicking the 'Change filter & configuration' button. In the 'Document import settings' window, go to the Columns tab. Set columns as source and target. Also notice the "Sheet #" field. Make sure you have selected the correct value (sheet number counting from left to right).


[Edited at 2021-03-23 14:45 GMT]

I'm positive I've selected everything that needed to be selected, down to the exact sheet and columns. I'm guessing something is wrong with this specific excel file, because I've checked a few other files and they imported with no issue.


Stepan Konev
DOYOON KIM
 


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


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

MemoQ only imports the first row from an excel sheet






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