How to translate an Excel file with multiple columns
Thread poster: brittak

Local time: 20:30
English to German
+ ...
Oct 25, 2009

I have an Excel 2003 file I need to translate from English to German using Trados 2007.
The Excel file consists of the following columns:

- English
- German
- Category
- Text Length

The text I have to translate is in column "English". And my translation has to go into column "German". How would I do that as I don't want to overwrite the content in column "English"? How can I tell Trados which column to translate in?

And then I need to see the other two columns "Category" and "Text Length" while translating. They tell me which topic my translation is about and the max length of the translation I have to deliver. So I have to be able to see these two columns while translating.

How would you go translating such a file?

Thanks for your help!

[Bearbeitet am 2009-10-25 12:37 GMT]

Direct link Reply with quote

Sandra Emberger
Local time: 20:30
English to German
+ ...
2 options Oct 25, 2009

Option 1: You'll translate the file as in Excel and you don't get it into Trados.

Option 2: You translate with the TagEditor. When done you copy the translation to the coloum "German". While translating you have the original file displayed on your second monitor where you see the other 2 columns.


Direct link Reply with quote

Evija Rimšāne  Identity Verified
Local time: 21:30
English to Latvian
no title Oct 25, 2009

The easiest way to translate an Excel file using Trados is to copy the text from the source (English) column to the target column (German), then hide all the non-translatable columns (English, Category, Text Length) leaving only the German column visible; when it's done, open the Excel file with TagEditor and translate it -- in such way you are telling it to translate only the German column. After cleaning up the translated TagEditor file, open the Excel file and unhide all the hidden columns. That's all.
Good luck!

Direct link Reply with quote

Achim Herrmann
Local time: 20:30
English to German
3rd Option Oct 30, 2009

You can also use a software localization tool like SDL Passolo. (Doesn't work with Essential!). It lets you define the columns for source and translation. In addition you can extract the text length into the project and automatically check the translation length.

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 »

How to translate an Excel file with multiple columns

Advanced search

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

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

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »

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