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


Direct link Reply with quote

Andrea Bertocchi  Identity Verified
Local time: 18:08
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

Direct link Reply with quote

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


Direct link Reply with quote

Marc Cordes  Identity Verified
Local time: 18:08
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]

Direct link Reply with quote

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 Trados Studio 2017 only €495 / $595
Get the cheapest prices for SDL Trados Studio 2017 on

Join this translator’s group buy brought to you by and buy SDL Trados Studio 2017 Freelance for only €495 / $595 / £425 / ¥70,000 You will also receive FREE access to Studio 2019 when released.

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

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