SAP Knowledge Base Article - Public

3165388 - Unwanted Records Are Created In The System Via Data Workbench


You have imported some data using data workbench and even though the file had X records, much more records are shown as processed and created in the system.


SAP Cloud for Customer

Reproducing the Issue

  1. Go to Data Workbench Work Center.
  2. Enter Import View.
  3. Select any object and method.
  4. Click next.
  5. Upload your file.
  6. Click on Next until last screen.
  7. Click on Import data.
  8. Go to Monitor View.
  9. Check your created task.

Result: Even though the file had 10 records, for example, the monitor shows 50 records processed. If you check in the system additional records were created.


This can occur when the user selects the rows and deletes through keyboard. This deletes the records but keeps the empty rows. You can confirm this is the cause by following below steps:

  1. Open the file used for the import with Notepad or other text editor.
  2. Check the rows. 
  3. You should find rows filled with "," commas. These rows are responsible for the additional records created in the system.


  1. Open the Excel file.
  2. Select the rows to be deleted.
  3. Right click.
  4. Delete the empty rows.

You could delete directly from the text editor as well.

See Also

 2204393 - Common Issues With CSV Files in Data Workbench and Mass Data Maintenance


Excel, Records, Empty, Row, Data Workbench, Import , KBA , LOD-CRM-INT-DWB , Data Workbench , How To


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