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

Martine Etienne  Identity Verified
Local time: 07:31
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: 07:31
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: 07:31
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

PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »

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