Term base Excel import settings

memoQ can import Excel worksheets into term bases. These files contain rows and columns, but the columns are not always the same as the fields in a memoQ term base.

Most of the time, the file you import does not have all the columns that memoQ would expect.

Sometimes the columns have names, and sometimes they do not. In the Term base Excel import settings window, you can convert the columns to term base fields, no matter whether they have names or not.

Mark any forbidden terms before import: If translators must not use some of the terms in the Excel file, format those terms with red text color in Excel. memoQ imports these terms into the term base as forbidden terms.

How to get here

  1. Open a project. In Project home, choose Term bases.

    From the Resource console: Open the Resource console. Choose Term bases.

    From an online project: As a project manager, you can open an online project for management. In the memoQ online project window, choose Term bases.

  2. If you need the terms in a new term base, create a term base first.
  3. Right-click the name of the term base you need to import the terms into. From the menu, choose Import Terminology.
  4. An Open window appears. Find the file you need to import. Click Open.

    If the file is an Excel workbook, the Term base Excel import settings window opens.

term_base_excel_import_settings_dialog

What can you do?

If some entries need to be updated, not added: You can do this if the Excel file comes from memoQ originally, and it still has the identifiers of the entries. If the same entry is still there, but it was edited, memoQ can update it. To do this, check the Update existing entries based on ID check box.

When you finish

To import the Excel file in the term base, and return to Project home or to the Resource console: Click OK.

To return to Project home or to the Resource console, without importing entries: Click Cancel.

Term base may have duplicate entries after the import: To get rid of duplicate entries, open the term base for editing. In the term base editor, filter the term base for duplicates. To learn more: See Help about the term base editor.