SAP Knowledge Base Article - Public

2665545 - Incorrect Characters are shown when Downloading an Excel with Information in a Non-Latin Alphabet

Symptom

You have some information in the system which is not written in the Latin Alphabet. The information is readable in the correct language in the system but when you download the information in an Excel document (.csv file), the characters change and the information is not readable anymore.

Environment

SAP Hybris Cloud for Customer

Reproducing the Issue

The following steps are an example. The same behaviour can also happen when downloading other excel files from the system.

  1. Go to the Visits work centre.
  2. Go to the Visits view.
  3. Click New and create a visit with the name in a Non-Latin Alphabet.
  4. Go to the Surveys Facet.
  5. Click Add and select a survey.
  6. Check In.
  7. In the Surveys Facet, select the survey that you added, click on the cog wheel and Edit.
  8. Answer the survey.
  9. Check out.

    VisitChinese.jpg

  10. Go to the Surveys work centre.
  11. Go to the Surveys facet.
  12. Find and open the survey that you added to the visit.
  13. Go to the Results facet.
  14. Click Export.
    Result: An Excel file will download.
  15. Open the Excel file.

    Result: You can see incorrect characters where you are supposed to see the name of the visit.

    VisitExcelIncorrectCharacters.jpg

Cause

These incorrect characters are shown because of your Excel settings. We scraped the data as unicode text, but Excel reads CSV files in non-unicode by default.

Resolution

To configure Excel to use unicode on your exported CSV:

  1. Go to the Data facet in Excel.
  2. Click From Text CSV.
  3. Select the excel file that you downloaded.
  4. Click Open.
    Result: A new window will open.
  5. Select File Origin: 65001: Unicode (UTF-8).
  6. Click Load.

    ExcelFileOrgin.jpg

Result: The characters are now be readable.

Keywords

characters, alphabet, download, excel, csv, Unicode, survey, visit , KBA , chinese , AP-RC-ANA-UI-XLS , C4C, ByD, Travel: Excel AddIn , Problem

Product

SAP Cloud for Customer add-ins all versions