How to search \"rapidly\" in a huge Excell glossary
Thread poster: Martine Etienne

Martine Etienne  Identity Verified
Local time: 21:18
Member (2003)
English to French
+ ...
Apr 28, 2003

After many years of translations, I have now a huge (123 pages) personal technical glossary in Excell. My problem is that I work with Trados and have always to click on the glossary file, click on the search button in this file, type the words to search and then click to go out of the search version to be able to view the different translations of the word.

Do you have an easy way of working?

Because it is taking much time...

Thanks a lot.


Direct link Reply with quote

Eva Blanar  Identity Verified
Local time: 21:18
English to Hungarian
+ ...
Try the "List Management" function Apr 28, 2003

You could use an Autofilter for the file (Select the whole of it -> Data -> Filter -> Autofilter). In this case, there will be a drop-down function available for both columns (or all of them). By clicking onto the small triangle in the corner of the first row of the column, the entries of that column will appear in ABC order and you only have to select the right one (=no typing). You\'ll have on the screen just the row with the word selected. You can leave the file open (as it is) and, if you need another word, you pull down the list again (there is no need to go back and select \"All\" in the drop-down menu in the meantime).

Direct link Reply with quote

Ralf Lemster  Identity Verified
Local time: 21:18
English to German
+ ...
Why don't you use MultiTerm? Apr 28, 2003

If you have Trados anyway, the obvious thing to do is to import your Excel-based termbase into MultiTerm.

A description of how to do that can be found here.

HTH - Ralf

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 »

How to search \"rapidly\" in a huge Excell glossary

Advanced search
You’re a freelance translator? helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »

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