* Logo
* Translator Tools
*
* Motto
* *
TransTools suite Knowledge base Feedback Back to Index | Site map
*
*
*
*
**
**
**
**
***
***
***
**
*
*
*
*
*
*
Also on:

TransTools on Twitter TransTools on Google Plus TransTools on LinkedIn TransTools on Scoop.It!
*

Glossary manager

Excel

Category: Glossaries

Glossaries are perhaps the biggest friends of translators. They are a product of many years of our work and can sometimes be as big as full-blown dictionaries.

Microsoft Excel is the most common application for creating, maintaining and searching glossaries. It takes very little time to create a glossary in Excel, unlike MultiTerm, for instance, which takes a lot of training just to be able to create the structure for a glossary. We can quickly create new entries, search for terms, exchange glossaries with our colleagues, etc. However, we need to admit that Excel needs a little help.

Take searching, for example. Microsoft Excel does not exactly excel at searching. First, you cannot tell it which columns you want to search for terms, so the search results often contain text from Definition, Notes and other columns, and it is very hard to find what you look for. Second, if your glossary workbook contains several glossary spreadsheets, it takes a lot of time to start a search because you need to change Advanced Options (i.e. tell it to search the entire Workbook instead of the current sheet).

Glossary Manager is a special collection of tools to turn Excel into a powerful glossary management system. The intent is to create a system for:

  • creating new glossaries (based on templates or old glossaries),
  • adding and editing entries in an organised way,
  • searching for terms,
  • exporting entries into other formats, and
  • importing entries from other formats.

At this time, Glossary Manager contains a special tool for searching glossaries (Glossary Search) and a command for configuring your glossaries so that other tools understand their format (Glossary Configuration).

Commands overview

Command Description Usage
Glossary Search Searches glossaries located in the current workbook for terms. Use a convenient user interface to quickly find terms you are searching for.
Glossary Configuration Configures glossaries located in the current workbook for searching and, in future, for adding / editing entries, importing, exporting, etc. Use it to configure the structure of each glossary to enable other Glossary Manager commands to work with the glossary.
 
Developed by Stanislav Okhvat, 2007–2016

Microsoft Word®, Excel®, PowerPoint® and Visio® are registered trademarks of Microsoft Corporation.
Autocad© is copyright of Autodesk, Inc.
SDL Trados® (including SDL Trados Studio, Trados Workbench, TagEditor and Microsoft Word Addin) is a registered trademark of SDL plc.
memoQ is copyright of Kilgray Translation Technologies.
Wordfast© is copyright of Yves Champollion.

Software disclaimer