Multilingual Excel and delimited text files

You can import text from multiple-column formats including Excel sheets, CSV files, and other 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.

You can control how memoQ imports text from multiple columns into the project's source or target language. If you have a project manager license, you can also export multiple target languages in one go, into a single export file.

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

Imports only text by default: Normally, memoQ will not import numbers or formulas from Excel workbooks, but 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 & configuration.

  3. The Document import settings window appears. From the Filter drop-down list, choose Multilingual delimited text filter.

    Document import settings window showing Filter and Filter configuration drop-down lists, Add cascading filter link and tabs with Base format tab open, showing options to choose from: Select base format: Excel, Comma or tab-separated or Simple bilingual configuration, and Segmentation options: Segment source text only if the target cell contains no text, and a sample file. OK, Cancel, and Help buttons are in the bottom right corner.

What can you do?

When you finish

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

  • 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.

It is possible to cascade filters after the bilingual and multilingual filters. For example, Multilingual Excel and delimited text can be the first filter in a filter chain, but remember that regex tagger should always be the last filter applied.