SAP Knowledge Base Article - Public

3351099 - Format issues when exporting Survey Results

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

Product

SAP Cloud for Customer core applications 2305