From Excel to Trados/Logoport

Tools: Excel, Trados/Logoport, Dreamweaver (or any other text editor with unicode support, and multi-line search and replace).

Exporting from Excel to Trados or Logoport, if manual, is rather a very easy task. Here is a step by step guide on how to do it. Note, however, that in this example, I will be only exporting the translations without any type of attribute fields:

1. You will receive an Excel file that looks something like this. If not, arrange it -move, delete, etc- so it has only the source language in colum A and target language in colum B.

2. Insert a colum before A. In that colum and in the first row, add the following: <TrU><CrU>Username<Seg L=EN-US>. Replace Username with your initials. In this case JC. Fill the rest of the rows with the same string.

3. Insert a colum before C. Fill that colum with the following: <Seg L=ES-EM>. In this case the target language is Spanish (ES-EM). Refer to the language codes for the rest of the languages. Fill colum E with the following: </TrU>

4. Now you will Save your file as unicode text. Save As –> Other Format –> Unicode Text –> Ok –> Yes. Close Excel. Open the exported file in Dreamweaver. Your file should look like this:

5. Now you will have to run a couple of search and replace:
<TrU><CrU>JC<Seg L=EN-US>select tab
with
<TrU>shift return<CrU>JCshift return<Seg L=EN-US>remove tab

6. select tab<Seg L=ES-EM>select tab
with
remove tab, shift return<Seg L=ES-EM>remove tab

7. select tab</TrU>
with
remove tab, shift return</TrU>

8. Your file should look like this. Save it as UTF-8 and import it into Trados/Logoport.