Can MemoQ recognize English text when importing a file?
Thread poster: Carlotta Minozzi

Carlotta Minozzi  Identity Verified
Local time: 11:19
Italian to English
+ ...
Oct 22, 2015

Hello everybody and thank you in advance for any help.
I have a few xls files to be translated, they are in part in English and in part in Italian. Only the IT text is to be translated. When I imported the first file (huge by the way), MemoQ imported everything and I do not know if there is a way to autmatically skip the English text, setting it as untranslatable or something like it. Any suggestion?
Thank you!


István Lengyel
Local time: 11:19
English to Hungarian
+ ...
confirm and lock rows Oct 22, 2015

Hi Carlotta,

Please lock for confirm and lock rows - that allows you to lock out text in a different language.



Carlotta Minozzi  Identity Verified
Local time: 11:19
Italian to English
+ ...
dont have that option Oct 22, 2015

thank you for your suggestion, but my version of MemoQ doesnt have the last option, the one you're talking about, only the first two lock options (all rows and only rows that are...)icon_frown.gif


Mikhail Popov
Local time: 17:19
Member (2015)
English to Russian
+ ...
Sort Oct 23, 2015

1. Select W letter in any segment. Press Ctrl+Alt+F. You will see all segments that have contain W letter. Since this letter is not being used in Italian language, it should be 98% English segments.
2. Ctrl+A and Copy source to target. Then Ctrl+Shift+Enter. Now 98% of your English segments are confirmed, but your TM is untouched.
3. Remove your selection (press the red cross near the funnel icon).
4. Lock ALL your segments.
5. Unlock only confirmed segments. Now the majority of Italian segments + some English segments are locked.
6. Change segments status of Confirmed segments to Edited.

Now 98% of your English segments have source text in target and Edited status.
98% of Italian segments are locked.
Some segments have to be sorted out manually.

You can clean source text from English segments with another memoQ function, by the way


Local time: 12:19
Russian to English
+ ...
Use Import with options Oct 23, 2015

Carlotta Minozzi wrote:
...part in English and in part in Italian. Only the IT text is to be translated...

Carlotta, why don't you just use Import with options command? It will open a submenu where you have to chose (Uncheck Create preview - it will speed up the process): Change filter and configuration - Import only these ranges - Select ranges in Excel. Then just select the cells of data in Excel you wish to translate (block by block). When you have chosen all you need, click Add ranges - Finish. It will import only those cells that are required for translation.

Good luck


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

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

Can MemoQ recognize English text when importing a file?

Advanced search

SDL MultiTerm 2019
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2019 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2019 you can automatically create term lists from your existing documentation to save time.

More info »
Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search