MemoQ2013: how to extract a Termbase into Excel?
Thread poster: Madeleine Chevassus

Madeleine Chevassus  Identity Verified
France
Local time: 03:33
Member (2010)
English to French
Mar 3, 2014

Hello

a future client (?) asks me to build a glossary, I was thinking of extracting the termbase into an excel file, then work on the content to add comments.

the extraction (edit, cut and paste) didn't work;

could you recommend a method?

generally speaking I am very satisfied with MemoQ.

Have a good day!

Madeleine


Direct link Reply with quote
 

Tomás Cano Binder, BA, CT  Identity Verified
Spain
Local time: 03:33
Member (2005)
English to Spanish
+ ...
Easy! Mar 3, 2014

This is what I do:

1. Go to the edit mode of the termbase (in the list of termbases of the Resource Manager or in your project, select the termbase and click the "Edit" link).

2. Look for the Export icon and click it, or choose the "Term base > Export" menu options. The "Term base export settings" dialog appears.

3. For "Encoding", choose "Latin-1" (if your language is Latin-1 based; I think French is), since Microsoft Office uses the Latin-1 encoding and not the UTF-8 encoding. In "Delimiter", choose Tab. Choose the location for your file, which will have the CSV extention, and export.

4. In theory Excel should open this CSV file with separate columns, but at least in my case it clumps all columns together. In this case, you can easily open the CSV file with Windows' Notepad and copy/past into Excel. (You might also want to use semicolon or comma as a separator and see whether Excel opens the CSV file correctly, with separate columns.)

Now you have an Excel file with different columns. The ones you want to use for your customer will be immediately apparent since they contain your source and translated terms. You can delete the rest and rename the columns as appropriate.

I hope this helps a bit!


Direct link Reply with quote
 

Oscar Martin
Spain
Local time: 03:33
English to Spanish
+ ...
Export terminology Mar 3, 2014

Hi Madeleine,

You can export terminology to .csv format. In memoQ, go to Tools > Resource Console > Term bases. Select the term base and click on Export terminology.

Select Export as CSV, UTF-8 as Encoding and comma as Delimiter. Once exported, go to Excel, select File > Open to open the .csv file and follow the wizard steps.

Regards,

Oscar


Direct link Reply with quote
 

Madeleine Chevassus  Identity Verified
France
Local time: 03:33
Member (2010)
English to French
TOPIC STARTER
Thanks a lot Tomas! Mar 3, 2014

Madeleine

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 »

MemoQ2013: how to extract a Termbase into Excel?

Advanced search






LSP.expert
You’re a freelance translator? LSP.expert 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 »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search