This topic is for memoQ 9.2. Have an older version? Click here.

Multilingual Excel and delimited text files

You can import text from multiple-column formats including Excel sheets, CSV and text files with comma or tab-separated values. These files usually contain several columns, and each column has the same text in a different language.

In this window, you can control how memoQ imports multilingual Excel or delimited files. You can import text from multiple columns into the project's source language, as well as into its target languages. You can also export multiple target languages in one go, into a single export file - if you have a project manager license for memoQ.

Can't import in LiveDocs: You can't import a multilingual Excel or text file into a LiveDocs corpus.

Normally, only text is imported: Normally, memoQ will not import numbers or formulas from Excel workbooks. However, you can tell memoQ to import them: Use the Excel options tab for that.

How to get here

  1. Start importing a multilingual Excel or text file.
  2. In the Document import options window, select the Excel or text files, and click Change filter and configuration.
  3. The Document import settings window appears. From the Filter drop-down list, choose Multilingual delimited text filter.

What can you do?

Dealing with columns

When you finish

To confirm the settings, and return to the Document import options window: Click OK.

To return the Document import options window, and not change the filter settings: Click Cancel.

If this is a cascading filter, you can change the settings of another filter in the chain: Click the name of the filter at the top of the window.

In the Document import options window: Click OK again to start importing the documents.

Can be chained: Multilingual Excel or text can be the first filter in a filter chain. memoQ can run a regex-based filter after the columns were imported.