SAP Knowledge Base Article - Public

2545430 - How to download / export Ad Hoc reports in XLSX format?


Ad Hoc report exports and downloads to Excel are currently of file extension XLS.

You would like to change it to XSLX (supported by MS Excel 2007 and later).


SAP SuccessFactors HXM Suite

Reproducing the Issue

    1. Navigate to Ad Hoc Reporting
      Analytics> Reporting > Reports> Ad Hoc Reports

      For instances with Report Center, just navigate to Report Center

    2. Select any Ad Hoc report and Run it.


      For instances with Report Center, select any 'Report Table' and Run it.


    3. Export the Ad Hoc report's output:
      • Run Online and Export:

      • Run offline, choose Excel and download from Scheduled Reports  (My Jobs if Report Center has been enabled)
    4. The downloaded file is in '.xls' format.


Ad Hoc report exports will be in xlsx format only if the corresponding Provisioning switch is enabled.


  1. Login to Provisioning and select the company under concern.
  2. Select Company settings.
  3. Search for and enable the below switch:

    "Generate Excel 2010 Output for Adhoc Reports"


    NOTE FOR CUSTOMERS: Please contact your Implementation partner or create a support incident to have the fix applied in Provisioning


AdHoc, Table report, download, export, XLS, XLSX, Microsoft Excel 2007 format, MS Excel , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Problem


SAP SuccessFactors HXM Suite all versions