Resources > Term bases > (TB) > Export

You often need to send terminology to other tools - or to other copies of memoQ.

memoQWeb can export terminology into three kinds of files:

  • Text files that contain a table: Each row is an entry from the term base, and each column is a term or a descriptive field from the entry. These are called tab-separated or comma-separated (CSV) files.
  • Excel files: XLSX files with a look similar to CSV exports. Normally, they contain only terms and examples, so they are ideal for external terminology review for people who do not have memoQ.
  • MultiTerm XML files: XML files that can be imported into SDL Trados Multiterm.

How to get here

  1. Sign in to memoQWeb.
  2. On the left sidebar, click the Resources Resources icon. icon.
  3. On the Resources page, click the Term bases button.
  4. On the Resources > Term bases page, find the term base you need.
  5. In the TB's row, click the More options More options icon showing three dots. icon. In the menu, click Export terminology. The Export page opens.

mqw-nxt-res-tbs-export

What can you do?

Normally, memoQWeb exports the term base in a text (CSV) file, but you can also choose Excel format (which has less options). Always use one of these, unless you know for sure that the exported file will be used in SDL MultiTerm iX or later. In that case, click the MultiTerm XML radio button.

If you choose MultiTerm XML: There will be no other options. If you have images in your term base, memoQWeb exports them. But memoQWeb won't export asterisks and pipes in terms. These tell memoQ how to look for the terms in text. But they are useless for MultiTerm.

Choose what to export

CSV files: In the Settings section, click the Show advanced settings link.

  • Column headers are always useful: Normally, memoQ exports them. Always leave the Write field headers in first row check box checked, unless you have problems in the other tool.
  • If the other end is memoQ, always export asterisks and pipes in terms. These tell memoQ how to look for the terms in text. If the other end is not memoQ, QTerm, Excel, or a plain-text editor - but a different terminology tool: Clear the Export prefix wildcards check box.
  • If you have images in your term base, check the Include images check box. memoQWeb exports the images and puts them in a ZIP file, together with the CSV file.
  • Choose fields one by one: Normally, memoQWeb exports all the fields from a term base. If the other end is memoQ or QTerm, this is the best option. If you're preparing the term base for human reading, you may want to omit some fields. To omit a field, clear its check box. To add or remove all fields, check the check box in the header, on the left of Field name.

Watch the preview: As you set the options, memoQWeb shows how your file will look like under Preview. This only happens If you export one term base.

XLSX files: In the File type section, under the XLSX radio button, click the Show exported fields link.

Choose fields one by one: Normally, memoQWeb exports the Entry ID, Term text (with wildcards), and Example of use fields from the term base. If you're preparing the term base for human reading, this is the simplest option - but you can add any other field as needed. If the other end is memoQ or QTerm, you may want to add all other fields. To add a field, check its check box. To add or remove all fields, check the check box in the header, on the left of Field name.

No images in XLSX: For this format, you cannot select the Image field. If you have images in your term base, they will not go into the export.

Watch the preview: As you set the options, memoQWeb shows how your file will look like under Preview.

Forbidden terms will appear in red in the export: This way anyone without memoQ can see which terms are forbidden. When you import an Excel file into a term base, memoQ imports terms colored in red as forbidden terms.

When you finish

To start the export: Click the Export term base button.

To return to the Term bases page: Click the Cancel link.