MemoQ2013: how to extract a Termbase into Excel? Thread poster: Madeleine Chevassus
|
|---|
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
| | | |
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 n... See more 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! ▲ Collapse
| | | | Oscar Martin
Spain
Local time: 03:32
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
| | | | Madeleine Chevassus 
France
Local time: 03:32
Member (2010)
English to French
TOPIC STARTER SITE LOCALIZER | Thanks a lot Tomas! | Mar 3, 2014 |
Madeleine
| | |
|
|
|
| no luck here! | Dec 18, 2018 |
This is driving me mad, I can't believe it's impossible to export an Excel file with terminology, just a useless unreadable CSV.
The steps here haven't helped me unfortunately, as Excel opens these CSV files wrongly, just lumps everything together in one column.
Seriously thinking of moving to SDL, memoQ is looking very Mickey Mouse.
| | | | Stepan Konev
Russian Federation
Local time: 05:32
English to Russian
| Ok, let's simplify it for you | Dec 19, 2018 |
1. Open your TB in Edit mode (in memoQ)
2. Select Term Base tab => Click 'Export'
3. In the next window, uncheck all checkboxes except 'Term text (with wildcards)'
4. Select 'Tab' for the 'Delimiter' options
5. Select your encoding. I use 'Windows, Cyrillic (1251)' for my target Russian language. Have no idea about yours.
6. Make sure 'Export as CSV' is still there.
7. Locate your saving path.
8. Ready? Click 'Export' now.
Now open the resul... See more 1. Open your TB in Edit mode (in memoQ)
2. Select Term Base tab => Click 'Export'
3. In the next window, uncheck all checkboxes except 'Term text (with wildcards)'
4. Select 'Tab' for the 'Delimiter' options
5. Select your encoding. I use 'Windows, Cyrillic (1251)' for my target Russian language. Have no idea about yours.
6. Make sure 'Export as CSV' is still there.
7. Locate your saving path.
8. Ready? Click 'Export' now.
Now open the resulting csv.
9. Click on letter A above the leftmost column (which actually means 'select all column A').
10. While column A is still selected, click 'Data' tab and then 'Text to table'.
11. In the newly appeared window, click 'Next' 2 times ('delimiters' and 'tabs' checked), then 'Finish'
12. Drag the column A vertical border to the right.
Behold the magic.
Now (or before step 9) you can re-save it as regular xlsx if you need.
Good luck!
[Edited at 2018-12-19 00:31 GMT] ▲ Collapse
| | | | Stepan Konev
Russian Federation
Local time: 05:32
English to Russian
| The type of delimiter does not make any change | Dec 19, 2018 |
You can leave comma delimiter as by default in memoQ. But then in Excel you will have to select comma too.
In Excel, the default delimiter is tab. That's why you have to select tab as delimiter in memoQ to ensure 'compatibility'.
Anyway, you still have the plurality of choices: select now 'tab' first for memoQ, then leave 'tab' as is for Excel; or leave 'comma' as is now in memoQ, but then select 'comma' later in Excel. Freedom of choice =)
| | | | | thanks Stepan!! | Dec 20, 2018 |
Thanks, that worked!
It's actually 'text to columns', but it got me where I wanted to be.
Still miffed as to why memoQ doesn't have an excel output option to save mucking around, i wasted a LOT of time on this yesterday
| | |
|
|
|
| exporting Ternbase as backup | Sep 23 |
I want to export a TermBase in case I need to use the TermBase in another instance of memoQ running on another computer
When I select the TermBase in Edit mode, and then select Term Base editor > Export ,
I got an error :
"the requested task could not be completed ....." "internal application error"
Same problem when I select the TermBase on the Resource console and then select "Export terminology"
I use memoQ version 8.7.19
<... See more I want to export a TermBase in case I need to use the TermBase in another instance of memoQ running on another computer
When I select the TermBase in Edit mode, and then select Term Base editor > Export ,
I got an error :
"the requested task could not be completed ....." "internal application error"
Same problem when I select the TermBase on the Resource console and then select "Export terminology"
I use memoQ version 8.7.19
[Edited at 2024-09-23 09:03 GMT]
[Edited at 2024-09-23 09:05 GMT] ▲ Collapse
| | | | 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? | Wordfast Pro | Translation Memory Software for Any Platform
Exclusive discount for ProZ.com users!
Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value
Buy now! » |
| | Trados Business Manager Lite | Create customer quotes and invoices from within Trados Studio
Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.
More info » |
|
| | | | X Sign in to your ProZ.com account... | | | | | |
Login to reply/comment 
