Working with Multilingual Excel Files
By default, the Bilingual Excel file type can handle Excel spreadsheets where the content is organized into columns, for one source and one target language. However, you can also translate the content of an Excel sheet organized into columns for multiple languages.
About this task
For example, a Multilingual Excel sheet may contain an English source column, and three target columns, French, German and Japanese. Any additional columns containing reference information are extracted as comments or document structure information.
Procedure
- Create a project for each target language available in your Excel spreadsheet. For example, start with creating a new project for the English-French language pair in the multilingual sheet.
- For each project, go to the Projects view.
- Go to and indicate the columns that contain the source and target language content for the first language pair. For example, English content is in Source Column A and French content will be placed into Translation column B.
- If your spreadsheet contains reference information in additional columns, configure the Bilingual File type to extract these as comments or document structure information.
- Open the project file and translate it into the specified target language.
- Use the Generate Target Translations batch task to add the translated content into the original Excel file.
- Repeat the steps for the remaining language pairs in the Excel file.