File Import settings

MS Excel

By default, the MS Excel file filter imports files with the following extensions:

  • .xls
  • .xlsx

The file import options that can be selected when creating a new job are:

  • Cell flow:
    • Columns, left to right (the default option)
    • Rows, left to right (Select this if content flows as in a Word document, by rows.)
    • Columns, right to left (This is an alternative to the first option for right-to-left languages, such as Arabic or Hebrew.)
    • Rows, right to left (This is an alternative to the second option for right-to-left languages, such as Arabic or Hebrew.)
  • Import comments
  • Import sheet names
  • Import hidden columns, hidden rows, and hidden sheets (Hidden content does not get imported by default; if some content should not be imported for translation, mark it Hidden in the MS Excel file.)
  • Process HTML code (Use this in cases where your XLSX file contains HTML tags such as <b>, <span>, etc.):
    • Only the option "Convert to Memsource tags (use regexp)" is available.
    • The other options are disabled.
  • Convert to Memsource tags (use regexp). Use this if you need to convert special text into tags, to protect this text from translating, for example. To convert {variable} use the regular expression \{[^\}]+\}
  • Import selected columns (Enter comma-separated list of columns, e.g. A,C,Q)

An In-context preview in the Memsource Editor can only be generated for a maximum of 200 columns in the imported file. A file with more than 200 columns will have a warning displayed in the project saying "In-context preview was not generated." and the In-context preview will not be available in the Memsource Editor.
This limit does not apply to the columns that are Hidden in the original file and are not imported for translation. However, if the import option "Import hidden columns" is used, then they are in the preview and the limit will apply to them.