Importing two columns
Thread poster: Juancar

English to Spanish
Oct 21, 2013

Hi guys

Does any of you know if it's possible to import a bilingual file in Excel? I mean, we can import a bilingual Word document and have it in MQ in two columns. I wonder if this can be done with an Excel file with the original and the translation in two different columns, so that we get the same view in MQ than the Word doc.

Many thanks!!



Andrea Bertocchi  Identity Verified
Local time: 19:44
German to Italian
Yes we can Oct 22, 2013

Hi Juancar,

Import with options > select filter "Multilingual delimited text filter" > Change filter and configuration > select the tab Columns and define which column contains source and target text.

Just try it out, it's very simple but also very powerful


PS: Please pardon my English


English to Spanish
Almost perfect Oct 22, 2013

Dear Andrea,

Thanks a million for this explanation!!!
It worked, but just a couple of precisions:
1) This option only exists in 2013 version
2) When you should the filter and change the configuration, you need to click the first tab, not the Columns tab.

At least it's the way it worked for me

Anyway, you gave me a really great hint!!!!!

Thanks a lot!!!



Marc Cordes  Identity Verified
Local time: 19:44
English to German
+ ...
Another Thank you! Oct 25, 2013

Big thanks from me as well. I just received an Excel sheet from one of my customers with 1300+ segments which are partly translated already.

Importing it the way you suggested lets me keep the segment structure and I was also able to import all segments already translated as locked so I avoid polluting the TM with any entries that are not my own (customer requested it).

This saved me a LOT of time!


[Edited at 2013-10-25 09:09 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 two columns

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 »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »

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