If a survey build by the Web support needs to be translated in several languages, you are asked by the Web support to enter the translation content in a standard Excel file.

This file is not a classical "XLS" file, but a Unicode Text (Excel) format. Only this format ensure to preserves non-ASCII characters (for example, 是 or ñ) when saved in Excel.

This file will open in a text editor by default. Follow the steps below to properly open it in Excel.

Open the translation file in Excel

1 - In an Excel blank sheet, select Open from the File menu of Excel.
Syensqo IS - Customer Support > [Solvay] Survey translation - deal with a translation file > image2017-4-10 12:31:2.png

This step may appear differently depending on the version of Excel you are using.

Select the file you’ve just downloaded.
Syensqo IS - Customer Support > [Solvay] Survey translation - deal with a translation file > image2017-4-10 12:34:59.png

Depending on your version of Excel, you may need to view all file types, as highlighted above, before your file will appear.

3 - Wait until a Text Import Wizard appears, then select Delimited.
Syensqo IS - Customer Support > [Solvay] Survey translation - deal with a translation file > image2017-4-10 12:36:25.png

4 - Select Tab as the delimiter and press Finish.
Syensqo IS - Customer Support > [Solvay] Survey translation - deal with a translation file > image2017-4-10 12:37:45.png

Using the translation file

This file have the following layout in Excel:

Syensqo IS - Customer Support > [Solvay] Survey translation - deal with a translation file > image2017-4-10 12:57:54.png

A row is provided for each item to be translated, with a column for the language downloaded.

1 - Fill-in the translations in each cell for each language column.

Syensqo IS - Customer Support > [Solvay] Survey translation - deal with a translation file > image2017-4-10 12:59:23.png

The structure of the file mustn't be updated (no columns, lines or cells adding / removing).

The identifiers (1st raw and 1st column) mustn't be updated.

The reference language (2nd column) shouldn't be updated (the changes will not be taken in account).

2 - When finished, save the file as normal, keeping this "Unicode Text (Excel)" format.

It could need to press "Yes" in the following dialog.

Syensqo IS - Customer Support > [Solvay] Survey translation - deal with a translation file > image2017-4-10 13:2:7.png

3 - Attach the completed file to a response to your survey request ticket.