Omega T - using excel glossaries
Thread poster: Karen Roos

Karen Roos  Identity Verified
United Kingdom
Local time: 14:50
Italian to English
Aug 13, 2009

I have just about got off the mark with Omega and can load the source file to translate, but am having difficulty with glossaries. I can write a glossary (tab separated text file etc) which works fine and have downloaded OpenOffice but I am sent huge glossaries in excel by one agency and cannot for the life of me seem to get them working. I tried copying and saving just the 2 columns I need into a word doc then opening with OpenOffice and saving as a .utf8 (with unchecked auto extension and checked filter options, then ASCII filter options as Unicode 8 just as I think I should) but still they do not appear. I've put them in the glossary file of the project of course. 3 whole days I have been at this. I think I am about to lose my marbles.
Any ideas anyone..? Please..? Help much appreciated.


Robert Tucker (X)
United Kingdom
Local time: 14:50
German to English
+ ...
Open with OpenOffice Calc Aug 13, 2009

Can you open the glossaries with OpenOffice Calc?

If you can, can you get the terms in two columns, preferably A and B?

If so, save the Calc file as text CSV from the drop down list of file formats. Keep current format when it asks (not "Save in ODF format"). Select {tab} as the "Field delimiter" and delete the "Text delimiter" (block it with your mouse and hit the "Delete" key on your computer keyboard). In the file folder where you have now saved the file, change the extension to .utf8. I think it should now be usable in OmegaT.

Otherwise try saving the file as a CSV with Excel.


Karen Roos  Identity Verified
United Kingdom
Local time: 14:50
Italian to English
Thanks Robert Aug 28, 2009

Hi Robert
I did eventually work it out, but your input was helpful. Yes, I think the problem was I didn't have the source and target words in columns and A and B before saving as a text file, but finally I am up and running. Many thanks!
Best wishes, Karen.


There is no moderator assigned specifically to this forum.
To report site rules violations or get help, please contact site staff »

Omega T - using excel glossaries

Advanced search

memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »

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