SAP Knowledge Base Article - Public

2826998 - Error: “Upload error; use UTF-8 encoded CSV file” While Uploading File using Data Workbench

Symptom

Your requirement is to upload data for any object using Data Workbench. Upon uploading the file in the Import view in Data Workbench workcenter, system throws error:

Upload error: Use UTF-8 encoded CSV File

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Data Workbench workcenter
  2. Go to Import view
  3. Select the radio button for Individual Object
  4. Go to Import tab
  5. Go to Standard Object tab or Custom Object tab
  6. Search for the Data Workbench object XYZ (where XYZ represents any object in Data Workbench)
  7. Select the button Download Comma Separated Values (.csv) to download the template
  8. Fill the required data in the file
  9. Select Browse and go to the file location
  10. Select the file and select Open
  11. Select Upload
  12. System throws the mentioned error

Cause

The upload .csv file is not in UTF-8 encoding. There may be characters with umlauts and other special characters (example à, ê, ñ, ó, ï, Ð, ß, etc.) in the upload file.

Resolution

Download the system delivered .csv templates for the Data Workbench objects. Fill data in the templates and use a csv editor to open a .csv file that uses UTF-8 character encoding.

For example, you may use Notepad++ to edit the CSV file by following the below steps:

  1. Save the csv file on your system
  2. Right click on the csv file and select Edit with Notepad++
  3. Select Encoding and select Convert UTF-8-BOM
  4. Save the file on Menu->File->Save as
  5. Provide a name for the file and add the extension .csv (Example: filename.csv)
  6. Upload this file in the Import view in Data Workbench

Note:
You may use any csv editor software which is approved by your organization/IT.

Keywords

Data Workbench, UTF-8 , Upload error, csv file , KBA , csv file , upload error , data workbench , utf-8 , special characters , LOD-CRM-INT-DWB , Data Workbench , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions