SAP Knowledge Base Article - Public

3485929 - Unreadable Symbols in CSV File From Data Import and Export Tool

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

  1. Open a new, blank Excel file.
  2. In the Data tab, click on "From Text/CSV" button.
  3. Select the affected .csv file and click on Import button.
  4. Make sure the file Origin selected is 65001: Unicode (UTF-8) and delimiter is Comma.
  5. 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