Symptom
When exporting the results of a Survey that contains non-English characters, the format of the excel file contains strange characters.
Environment
SAP Cloud for Customer
Cause
This is an issue with Excel and how it displays characters.
Resolution
1. Open new workbook Excel
2. Go to "Data" ribbon
3. Click "Get External Data From Text"
4. Search for the CSV file and press "Import"
5. Choose "Delimited" option for the type of data and "65001 : Unicode (UTF-8)" for the file origin
6. Hit "Next"
7. Choose "Comma" as delimiter
8. Hit "Next" and "Finish"
9. Decide where to write the imported data to (existing cell or new worksheet) and hit "OK"
Keywords
excel, survey results , KBA , LOD-LE-SUR-DEF , Survey definition = design time , Problem