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.
image09

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.
image07

4 - Select Tab as the delimiter on the second step.
image29

5 - Make no changes on the third step and select Finish.
image44

Using the translation file

This file have the following layout in Excel:

image27

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

1 - Fill-in the expected translations in each cell

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.

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