Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Create a Format Configuration
Anchor
Format Configuration
Format Configuration

A format configuration must be created for pre-translation of the document. This configuration defines what columns and languages are within the Excel file. 

To create a Multilingual Excel file format configuration, first click on Settings in the Menu Bar and then Excel in the Document Formats section. 

Image Added

Click on Add New to create a new configuration or Select to edit an existing one. 

Image Added

Give the configuration a name (if new). Next, you will need to configure the columns and languages for the Excel File. First, tick the radial next to the Multilingual option.

Image Added

Second add each column in the document and define the language for each one. To add a column and language, select the language in the provided drop-down menu and then click on the Add Button (plus)

Image Added

Note

Please note this step must be performed for each language and column in the document. You may also configure any columns with comments, etc. 

When adding the languages, you must also configure a column for the language in the configuration. Text columns (language columns) reside on the left and Comment columns reside on the right of the column section. Click on a field and type in the column value as it appears in the Excel File to be translation.

In the example below, the Excel file format configuration contains four columns:

  • English (en) - Column A
  • Comments - Column B
  • French (fr) - Column C
  • German (de) - Column C

Image Added

Once this information has been configured, you may also configure what rows the translation will begin with. For example, if Row 1 has headers you do not want to be translated, then the configuration can be changed to start with Row 2. Additional configuration options for sheets, HTML content, and text segmentation are provided. When finished with the configuration, click on Save in the upper right corner of the window. 

Image Added

Info

For more information about creating and managing Excel File format configurations, please see Microsoft Excel Files in the File Format section of Administration.

Create a Project (Standard or CoDyt)
Anchor
Create Project
Create Project

 

Select Configuration within Project
Anchor
Select Config
Select Config

...