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

Microsoft Excel documents (XLS, XLT)

Microsoft Excel workbooks are tricky to import because they contain much more than translatable text. Usually, only a small part of an Excel workbook is translatable.

There are many settings that help you select what to translate and what to ignore.

This window is for old-style Excel workbooks: Use it to import .xls and .xlt files.

To import multilingual tables: Use the Multilingual Excel filter instead. Use the Multilingual Excel filter, too, if the translation mustn't replace the source text but must go into another column.

How to get here

  1. Start importing a legacy Excel workbook (an .xls or .xlt file).
  2. In the Document import options window, select the Excel workbooks, and click Change filter and configuration.
  3. The Document import settings window appears. From the Filter drop-down list, choose Microsoft Excel filter.

If you see a different window that the one below: Click the Import as XLSX radio button.

What can you do?

First, memoQ converts the workbook in the XLSX format (the one used by Excel 2007 or later).

Under Select import type: Click Import as XLSX. Do not click Import through Office interop.

This works if Excel 2007 or later is installed on your computer. memoQ calls Excel to save the workbook in the newest format.

If Excel 2007 or later isn't installed: Check the Aspose check box. In this case, memoQ converts the workbook into the newest format on its own. For that, memoQ uses a module called Aspose.

From the Direction of linearization drop-down box, choose the option you need.

Normally, memoQ lists the cells from left to right and from top to bottom. This is the same order as you would read running text in a European script.

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.