SAP Knowledge Base Article - Public

2793258 - The double bytes characters are garbled when double clicking to open a csv file which is exported from a SAP Analytics Cloud (SAC) model in Microsoft EXCEL

Symptom

  • The double bytes characters are garbled when double clicking to open a csv file which is exported from a SAC model in Microsoft EXCEL
  • The double bytes characters might be Chinese, Japanese, Korean words

Environment

  • SAP Analytics Cloud (SAC)

Reproducing the Issue

  1. Open a model which contains double bytes characters data in SAC.
  2. In Data Management, create an export schedule job to export it to CSV format.
  3. Download the CSV files to local and double click it to make it open by Microsoft Excel.
  4. Notice that the double bytes characters are garbled.
  5. However, if opening the same CSV file in notepad, notice there is no such garbled characters

Cause

In SAC, the exported CSV file is encoded in UTF-8 without BOM (Byte Order Marks).
When directly opening it in Excel, it cannot determine the correct encoding.

Resolution

When using Excel to open the exported CSV, use the below steps to set the encoding manually instead of double clicking to open it.

  1. Launch Microsoft EXCEL
  2. In the toolbar menu, choose Data -> From Text/CSV
  3. Select the exported/downloaded CSV file
  4. In the coming dialog, manually change the File Origin/Encoding as 65001: Unicode (UTF-8)
  5. Notice that the correct characters will be shown.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0