Microsoft Excel Files

Owned by April Hatton (Unlicensed)
Last updated: Feb 21, 2019 by Sara mendez
2 min read



For more information, please see the following sections: The following file extensions are supported when setting up file format configurations for Microsoft Excel: .xls, .xlt, .xlsx, .xlsm, .xltx, .xltm, .xlsb.

 

Default Excel Configuration

Every file format has a default configuration to ensure that a file can be translated; however, it does not handle every complex property that could be thrown your way when translating a source file. The default configuration for Microsoft Excel files does the following: 

  • Handles monolingual content.
  • Translates all columns, rows, and sheets.
  • Extracts document properties, headers, footers, sheet names, and user comments.
  • Uses SRX rules for segmentation and splits text at line breaks.
  • Does not show leading and trailing whitespaces.
  • Converts sequences of multiple whitespaces into markup.
  • Does not show leading or trailing characters that do not contain letters or digits.
  • Converts words that do not contain letters or digits as markup.
  • Ignores formatting changes to whitespaces.

 

Custom Excel Configurations

If you use Microsoft Excel files for translations, a custom file format configuration might be necessary to achieve the right results in your target file. Outside of the default configuration selections, Wordbee Translator offers many additional choices for configuring:

  • Managing how content is extracted.
  • What will not be translated (i.e. columns, rows, sheets, fonts, comments, etc.).
  • Translating monolingual and multilingual Excel files. 
  • Handling whitespaces and symbols. 
  • Reducing markup. 
  • Handling embedded files.

To learn more about available file format configurations for Excel, please see the Excel Configuration Options page.

 

A Few Examples

The following are just a few examples of what you can do with a custom Excel configurations in Wordbee Translator. For more advanced examples, please see our Excel Questions and Answers page.

Excluding Colored Text

For instance, if red and green text within a Microsoft Excel file should not be translated, this formatting rule is not part of the standard default configuration. However, this can easily be accomplished by creating a custom configuration for Microsoft Excel files. 

Translating Multilinqual Excel Files

The default configuration is designed to translate monolingual files; however, a custom configuration will be necessary when needing to translate a multilingual Excel file. 

Configuring Specific Columns and Rows for Translation

In some instances, only specific columns or rows within the Excel file will need to be extracted for translation. For example, maybe only Columns B and D need to be translated and the extraction should start on another row other than Row 1. In order for the translated target file to be correct, a custom configuration must be created to accomplish this task.

 

For more information, please see the following pages: 

Copyright Wordbee - Buzzin' Outside the Box since 2008