SAP Knowledge Base Article - Public

3170343 - Pivot excel export cell format is text


When exporting a pivot table to excel, the cell format is always text.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Create a Pivot table in Canvas report
  2. Export in Excel
  3. Fields are in text format


This is working as designed.


It is expected that the cell format in the exported excel file from a pivot table is text. So, e.g., if you export a pivot table where you used a date field, it will in text format by default:


Pivot, export, text, format, date field, field, cell, cell format, excel, xls, xlsx, canvas , KBA , LOD-SF-ANA-ORD , Online Report Designer , How To


SAP SuccessFactors HCM suite all versions