File Import Settings

Spreadsheets (MS Excel based)

Cells containing only numerals are skipped as it is assumed they do not contain data relevant to the import.

In-context preview can only be generated for a maximum of 200 columns in an imported file. Files with more than 200 columns will display the warning In-context preview was not generated. This limit does not apply to the columns that are marked Hidden in the original file.

File Types

  • .XLS

  • .XLSX

  • .XLT

  • .XLTX

  • .XLSM

  • .XLTM

Import Options

  • Cell flow

  • Import comments

  • Import sheet names

  • Import hidden columns, hidden rows, and hidden sheets

    By default, hidden content is not imported.

  • Process HTML code

    In cases where file contains HTML tags (<b>, <span>, etc.)

    • Disables options other than Convert to Memsource tags

    • HTML Import Settings cannot be used to edit the default settings.

  • Convert to Memsource tags

    Apply regular expressions to convert specified text to tags.

  • Import selected columns

    Enter a comma separated list of columns, e.g. A,C,Q

Multilingual Spreadsheet Files

Multilingual files are imported as multiple bilingual jobs with languages mapped before import. They are represented with multilingual_xlsx.png in the Jobs Table. If imported into several target languages, the Completed file is composed of all target languages.

  • Hidden sheets are not processed.

  • Files are converted to XML on import. Most formatting, graphs and images are lost.

  • Some files cannot be converted to multilingual files due to software packages or versions of those packages.

  • When creating a job, select Multilingual MS Excel from the File Type pane before applying Import Options. If not specified, the file will be imported as standard XLSX.

Import Options

  • Use HTML subfilter

    Imports HTML tags contained in the file. Tags can then be used with HTML File Import Settings. Paragraph tags <p> will create new segments even if Segment Multilingual XLS is unselected.

  • Segment multilingual XLS

    Text is segmented by a general segmentation rule rather than one segment per cell.

    Caution

    Applying Segment multilingual XLS to a file that contains target text may result in a different number of segments in the source than in the target.

  • Source (column)

    Use lowercase or capital letters. For more columns, enter letters separated by commas with no spaces (A,D,G).

  • Target (column)

    There is one column for each target language. For more columns, enter letters separated by commas with no spaces (B,E,H).

  • Import specific rows only

    Enter rows to be imported (1,4,7).

  • Context key (column)

    Specify a context key that is saved with the segment to the Translation Memory and used for match context.

  • Context note (column)

    Columns are set as context notes (B,C). Notes will be displayed on separate lines.

  • Maximum length (column)

    Sets the maximum length of the translation. For more columns, enter letters separated by commas with no spaces (I,J,K).

  • Convert to Memsource tags

    Apply regular expressions to convert specified text to tags.

Was this article helpful?

Sorry about that! In what way was it not helpful?

The article didn’t address my problem.
I couldn’t understand the article.
The feature doesn’t do what I need.
Other reason.

Note that feedback is provided anonymously so we aren't able to reply to questions.
If you'd like to ask a question you can leave a public comment below or Submit a request to our Support team.
Thank you for your feedback.

Comments

0 comments

Article is closed for comments.