SAP Knowledge Base Article - Public

3239980 - Extra Characters in Report Downloaded in CSV Format


When you download a report in CSV format there are added characters for negative values.


  • SAP ByDesign
  • SAP Cloud for Customer

Reproducing the Issue

  1. Go to Business Analytics.
  2. Go to Design reports and find your report.
  3. Open your report and run it.
  4. Download the report in CSV format.
  5. Open the report in excel.
  6. Notice there is an extra character in cells that have a negative value.


Instead of -20 you see '-20


The reason you are seeing the extra character for minus values in your excel reports is due to a potential csv injection/security issue.

Please see the below article that explains what a csv injection is -->

Note this happens only for report characteristics, not key figures. Negative numerical values in characteristics should be a rare use case.


You can manually remove the extra character from the excel report.

However if you work with reports where you frequently have negative values in characteristics, we can activate a backend switch for your system to change the escaping of quotes. This will remove the character.

If you would like to request this, please open an incident and refer to this KBA.

See Also


extra character, inverted comma, CSV, download, report, excel, , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To


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