How do I select two columns from Excel to open in SDL Trados Studio 2011?
Thread poster: Fredrik Pettersson

Fredrik Pettersson  Identity Verified
Hong Kong
Member (2009)
English to Swedish
+ ...
Nov 24, 2011

How do I select two columns from Excel to open in SDL Trados Studio 2011?

I opened the comma-separated .csv file from within Excel (Excel already opened), and chose encoding UTF-8 as the .csv contains one column with traditional Chinese characters, one column with simplified Chinese characters, one column with Pinyin, and the last column with English translations and explanations and examples.

The last column also contains some Chinese characters to a small extent (in the examples given in this last column that mainly though concists of the English translation and explanations written with Latin characters).

I want to open this in SDL Trados Studio 2011 for translation from Chinese into Swedish, but as I can only have one source language variant, I want to choose the second column, containing simplified Chinese characters, and the fourth column, containing the English translation and examples and explanations.

I want to skip the first column (with Traditional Chinese characters), and the third column (with Pinyin).

Can I do this, choose from within Studio to only import certain colunns? I know I could easily copy and paste in Excel those columns I want to open in Studio, but it would be convenient if I could do this from within Studio instead.


 

jimshanks
Local time: 08:33
Dutch to English
Hide the unwanted columns Nov 24, 2011

I believe that hiding the unwanted columns will mean that TRADOS will ignore them and only open the visible columns for translation.
Hope this helps


 

Jan Kolbaba  Identity Verified
Czech Republic
Local time: 09:33
English to Czech
+ ...
Copy Nov 24, 2011

the whole required (your source language) column(s) and paste it(them) into a new Excell sheet and save it as "working.xls(x)" (for example). Translate this "Working" sheet in Trados and finalize your translation. Use the original Excell sheet as reference while translating. Then copy the translated text into a desired column of your original Excell sheet.

HTH, Jan


 

Michael Grant
Japan
Local time: 16:33
Japanese to English
By far the easiest way... Nov 25, 2011

jimshanks wrote:

I believe that hiding the unwanted columns will mean that TRADOS will ignore them and only open the visible columns for translation.
Hope this helps


Jimshanks is right on the money: simply hide the columns you don't need...

MLG4035


 


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


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

How do I select two columns from Excel to open in SDL Trados Studio 2011?

Advanced search







Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



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