Microsoft Excel 2007 and higher (XLSX)

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 workbooks from Excel 2007 or higher: Use it to import .xlsx 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 workbook from Excel 2007 or higher (an .xlsx 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 2007, 2010 and 2013 filter.

What can you do?

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.