How to create Trados TM using Microsoft Excel

Recently I was handing a project that has a high repeat rate in between 3 files. I used trados to analyze the files and generated some texts with a repeat rate lower than 99%. A word file with these texts is generated and I further made it into a form with source language on the left column and the target language on the right. Here comes the question how to create a trados TM using excel. 1. Paste the word file to excel and let the source language text be in column A and target language in column B. 2. Insert “="<TrU>"&"<Seg L=EN-US>"&A1&"<Seg L=ZH-CN>"&B1&"</TrU>"” (exclude the outermost quotation marks) into column C. Press Enter. 3. Adjust the language pair inside , the first <Seg L=XX-XX>  is source language and the second <Seg L=XX-XX>  is target language, as a reference you can find each language code in this website: 4. Copy the formula to column C. (Method: select C1, right click, select Copy, select the rest of column C (from C2 to where the text ends, right click, select “selective paste” and tick “formula” in the dialog box) 5. Select column C, copy column C. 6. Create a new TM, remember to select the source and target language (must correspond to the language pair in the formula). Export as txt file. 7. Open the txt file, paste column C immediately following the last segment (start a new line) of the txt. Save txt. 8. Import the txt file to update the TM. Then a TM of the translated text is created successfully. (This method strongly applies to files that has a high repeat rate between each other, and by operating like this you can only send the extracted text to the translator to save cost) Hope that helps!!

Words translated by CCJK


Request a call or contact us


    Call for professional assistance


    Click Here to leave us a message and be as detailed as possible.

We are Certified

Our Client Satisfaction

rating for previous quarte

    Inquiry Form

    Please take few minutes to fill
    inquiry form and get Free Quote

    Request a Call

    Click to receive Free Call, Our
    Representative will contact you

    Leave a Message

    Please leave us a message and
    be as detailed as possible

Over 95% of our clients recommend our language services to others

Copyright © CCJK Technologies Co., Ltd. 2000-2017. All rights reserved.