SAP Knowledge Base Article - Public

3351099 - Format issues when exporting Survey Results


When exporting the results of a Survey that contains non-English characters, the format of the excel file contains strange characters.


SAP Cloud for Customer


This is an issue with Excel and how it displays characters.  


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"


excel, survey results , KBA , LOD-LE-SUR-DEF , Survey definition = design time , Problem


SAP Cloud for Customer core applications 2305