A multilingual excel file is one that contains more than one language column such as one column for English, French, and German. When translating these files, a few additional steps must be taken to ensure the pre-translation and workflow is handled appropriately.
To translate a multilingual file, you will need to perform the following tasks:
- Create a Format Configuration
- Create a Project (Standard or CoDyt)
- Select Configuration within Project
- Mark Document for Online Translation
Create a 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.
Click on Add New to create a new configuration or Select to edit an existing one.
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.
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 
.
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
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.
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)
Before the configuration can be assigned for use with the document, you must create a Standard or CoDyt project within Wordbee Translator and upload the document.
To create a project, first click on Projects in the Menu Bar and click on New Project.
Then click on Create Standard Project or Create CoDyt Project.
Enter the information for your project and then click on Save & Continue in the upper right corner. For a standard project, you will need to choose the client, enter deadline information, choose languages, etc.
The image below is for a Standard Project:
Then upload the document to the project. You will automatically be directed to the Documents Tab. To upload a document perform the following steps:
- Click on Upload Files
- Browse to the Excel File and select it.
- Click on the Add....
- Click on Close.
The uploaded document will appear as shown below:
Once a project has been created and the document has been uploaded, you will be able to mark it for online translation and select the created Excel file format configuration.