3368203 - Workzone's reports (.csv) displaying non-alphabetic characters when English is not default language

• When opening .csv reports where source data is different of English language, non-alphabetic characters appear.
• Reports is normally displayed when data came from system where English is default language. 

• SAP Build Work Zone, Advanced Edition
• SAP SuccessFactors Work Zone

1. Go to a workspace where you would like to extract report.
2. Click on export.
3. Open .csv file and non-alphabetic characters will be in place of regular words.

It is a Microsoft Office Excel system behave.

By default Excel opens the CSV file with ANSI encoding. The ability to open the CSV file with UTF-8 encoding and non English characters was introduced in Excel 2016.

Workaround suggested:

Importing CSV file into Excel

•  Open a blank excel sheet
• Go to Data tab.
• Click Get Data Icon, it will expand.
• Hover mouse on the first option "From File" and select "From Text/CSV"
• Choose the downloaded report.
• Click on Load at the bottom screen.

OR

Try Libre Office or a different editor and follow the workaround below:

• Open the CSV file using Notepad.
• Click "File > Save As".
• In the dialog window that appears - select "ANSI" from the "Encoding" field. Then click "Save".
• Open this new CSV file using Excel - your non-English characters should be displayed properly.

• Trying to open csv file with diff language data and getting weird - Microsoft Community
  • https://learn.microsoft.com/en-us/officeupdates/current-channel?redirectSourcePath=%252fen-us%252farticle%252fWhat-s-new-and-improved-in-Office-2016-for-Office-365-95c8d81d-08ba-42c1-914f-bca4603e1426
• Question - Reports displaying non-alphabetic characters when Workzone is not in English. (int.sap)
• 2706322 - What is Support – What is Consulting: Cloud Solutions - SAP for Me

.csv, workzone, reports, non-english, alphabetic characters, Microsoft, Office, Excel , KBA , LOD-SF-SWZ-ARE , Admin Area Feature , How To