Importing two columns
Thread poster: Juancar

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

JC


Direct link Reply with quote
 

Andrea Bertocchi  Identity Verified
Italy
Local time: 12:35
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

A.

PS: Please pardon my English


Direct link Reply with quote
 

Juancar
English to Spanish
TOPIC STARTER
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!!!

JC


Direct link Reply with quote
 

Marc Cordes  Identity Verified
Poland
Local time: 12:35
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!

Thanks!

[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 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

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 »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search