I wanted to setup a new SDL Multiterm 2009 Termbase to organize our Terminology. Since we have lots of stuff already in existing Excel spreadsheets, importing them would make sense. This is a post about how to do this.
First, to get a little order into the whole thing, I figured adding a Category setting to every Term would help later on.

In the picture above, you can see the Category. It’s built into Multiterm and is of the type Picklist. But that Picklist does not contain the categories that I wanted yet, so you have to add them manually.
Add a entry into the Category Picklist
First, you need to have a Termbase open. I used the predefined termbase template “Multilingual termbase”.

Extending the Category itself is actually pretty simple:
- Go to the Catalog of your Termbase
- Right-click on Definition and then Edit
- Go through the Wizard until Step 4
- Select Category and then Properties below
- Now you can add new Entries (see in the pictures below)


Get the Excel ready
Now that we prepared our Termbase, we can get the Excel ready. Besides the two obvious columns with the terms, we need 2 more columns with the Category. The title needs to be exactly the same as in Multiterm. In this case “Category”. The same is true for the entries, I’ve added an entry “amount” to the termbase, which is exactly the same as in the Excel spreadsheet. Upper and Lowercase matters too. Otherwise there will be no match.
Make sure the titles are on the first line, otherwise Trados will not recognize them.

Now we have to start SDL MultiTerm Convert 2009. You cannot import an Excel directly into MultiTerm unfortunately.
The Excel import wizard is pretty straight forward. There are only two points that need a little attention. On Step 5 make sure that you set the 2 Term columns to be Index fields with the right language and the Category column to be a Descriptive field of type Picklist. Don’t worry if you only see the Category column once.

In the next step we have to add the two Category fields to the structure, as you can see in the picture below, I’ve added Category #1 to the Term below CH-DE and Category #2 to EN-US.

This all we have to do in MultiTerm Convert. Finish the wizard and go back to the SDL MultiTerm 2009 main application.
Import into MultiTerm
Go to the Catalog of your termbase, click on Import and then I would use the “default import” definition. Right-click and choose Process. You should have an *.mtf.xml file from the Excel converting process. Choose that and just follow the Wizard.
That’s about it.
Please post comments below if you run into issues.