Symptom
When trying to open a CSV export file from Data Import and Export tool, the characters are replaced with unreadable symbols (e.g. ¼).
Environment
- SAP Sales Cloud v2
- SAP Service Cloud v2
Cause
This issue comes from Excel side. The CSV format requires additional steps to read special characters.
Resolution
- Open a new, blank Excel file.
- In the Data tab, click on "From Text/CSV" button.
- Select the affected .csv file and click on Import button.
- Make sure the file Origin selected is 65001: Unicode (UTF-8) and delimiter is Comma.
- Click on load button.
After that, the original characters should be displayed correctly.
Keywords
Excel, CSV, Format, Character, Symbol, Data Import and Export , KBA , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , How To
Product
SAP Sales Cloud and SAP Service Cloud Version 2 1.0