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 - Select Open from the File menu of Excel.
This step may appear differently depending on the version of Excel you are using.
2 - Select the file you’ve just downloaded.
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.
4 - Select Tab as the delimiter and press Finish.
Using the translation file
This file have the following layout in Excel:
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.
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.
If the following dialogu appears, press "Yes":
3 - Attach the completed file to a response to your survey request ticket.
The best way to get IT support is to use the new
Service One Platform.