Creating a TM from Excel files?
Thread poster: pantransnet

South Korea
Local time: 00:00
Sep 16, 2014

Hello, There.

Well, I've hit the wall for finding out the way to creat a TM from Excel file using SDL 2009 or 2011.

I used to create TM from Excel file by using a feature 'Align' in SDLX when I was using Trados 2007.

It was okay, but took a lot of time.

So, as SDL 2009 or 2011 are much more advanced, I was wondering if there's any way that I can import and create TM from Excel files.

I have Excel file which has "Source" on row 'A' and "Translation" on row 'B'.

Q. Can I export directly from excel file?

Q. If not, can I export from seperate files, like I have done using 'Align' from SDLX?

Please send me an answer

Direct link Reply with quote

Emma Goldsmith  Identity Verified
Local time: 16:30
Member (2010)
Spanish to English
Simple Sep 16, 2014

Here's a simple way to do it:

- Save your bilingual Excel file as a "tab delimited" text file,
- Before you open it in Studio, go to Options>Filetype>Tab Delimited Text>Format and make sure that the source and target column numbers match your Excel file (by default column 1 is Source and column 2 is Target).
- Open the file for translation in Studio (and add a new TM) and click Ctrl+S to save the sdlxliff file.
- Go to batch tasks, select "update main translation memory". In the wizard, enable the "not translated" segment status box to make sure all the segments go into the TM.


Direct link Reply with quote

SDL Community  Identity Verified
United Kingdom
Local time: 16:30
An even easier, and fast way... Sep 16, 2014

... is to use the Glossary Converter from the OpenExchange.. This will convert a spreadsheet like that to a TMX very quickly. Then just upgrade the TMX in Studio.



Direct link Reply with quote

Christian Hoel
United States
Segmentation Jan 26, 2015

Some of the cells in my Excel file have multiple sentences. Using the processes suggested above, I'm getting TUs/segments with multiple sentences.

Since I almost always use sentence segmentation when creating new projects, I'd prefer to always update my TMs with single sentence TUs.

Any suggestions on how to solve this dilemma?

Direct link Reply with quote

Local time: 16:30
English to Hungarian
+ ...
Obviously... Jan 26, 2015

you need to chop those up before converting the file to tmx.
You can do that manually in excel, which is convenient if the file is very small, but it will take a lifetime if the file is large and there are many multi-sentence cells.
Alternatively, you can use an aligner. This is only worth the trouble if there are many multi-sentence cells. Copy column A into a text editor, save, copy column B to the text editor, save, then align the two txt files and you'll have your TMX.

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 »

Creating a TM from Excel files?

Advanced search

Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
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 »

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