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 Excel 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 an Excel 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?

Set the order of cells as they are imported (Direction of linearization)

Import or ignore certain types of content (settings under General)

Line breaks in cells: New segment or inline tag?

Import or ignore cell ranges

Need to chain a HTML or an XML filter, or a Regex Tagger after the Excel import? Ignore inline formatting

Get the source text from one cell, and its context from another

Get the source text from one cell, and its comment from another

Deal with content that work in the newest Excel versions only

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.