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

Local time: 18:29
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]


Sandra Emberger
Local time: 18:29
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.



Evija Rimšāne  Identity Verified
Local time: 19:29
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!


Achim Herrmann
Local time: 18:29
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.


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

Wordfast Pro
Translation Memory Software for Any Platform

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

More info »
Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »

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