Need the terms from a MultiTerm termbase as a plain glossary: for a style guide, a client who
wants to check terminology, or a tool that only imports spreadsheets? This page turns an
.sdltb file into an Excel workbook and a CSV without MultiTerm installed.
How to convert SDLTB to Excel
- Upload the
.sdltbfile (MultiTerm 2009 or later). You can add several termbases at once. - Open the result's preview to check the entry and term counts and the languages found.
- Download the Excel glossary (
.xlsx) or the CSV glossary.
What the workbook contains
Concepts has one row per termbase entry: the concept ID, entry-level fields such as Subject, then a column for each language. Synonyms get extra columns, so an entry with three English terms fills English (en), English (en) 2 and English (en) 3. Up to ten terms per language get their own column; any beyond that are joined into the last one.
Terms has one row per term, with the concept ID and language, every term-level field (part of
speech, status, gender, usage notes…), language-level fields such as definitions, entry-level
fields prefixed with Entry:, and who created and last modified the term, and when.
Termbase info holds the name, description, copyright notice, languages, field names and counts of the original termbase.
The CSV has the same layout as the Concepts sheet, is encoded as UTF-8 with a byte-order mark, and keeps accents and non-Latin scripts intact when opened in Excel.
Tips
- To filter by subject or status, use the Terms sheet: it has one field per column, so Excel's filters work directly.
- For a two-language glossary, copy the Concepts sheet and delete the columns you don't need. Synonym columns show which alternatives exist for the same concept.
- Pictures are not embedded in the workbook. They come as a separate ZIP of image files, and the illustration field's column lists the file names for each entry.
- To import terminology into memoQ, OmegaT, Phrase or Wordfast with all fields intact, the TBX export from the same conversion is usually the better choice.
- Encrypted termbases can't be opened.
More about what this tool reads and writes: Trados File Converter (SDLTM, SDLTB, SDLXLIFF, SDLPPX).