Configure Custom Headers for XLSX Exports

This article describes how you can customize the headers used in the XLSX exports of reports and dashboards in your workspace. For general information about exporting, see Export Reports and Export File Types.

You can specify headers for each workspace in your domain. By default, the XLSX file has no headers predefined. You can add up to 5 headers (rows) to your XLSX files, each displayed on a separate row.

Configure Headers through Platform Settings


  1. Access the platform settings. For details, see Configure Various Features via Platform Settings.
  2. Scroll down to the bottom of the page to the Config section.
  3. In the Key field, type exporter.ExcelExport.CustomHeader.N where N is a natural number from 0 through 5 and specifies the number of the header row.
  4. In the Value field, type what you want to display in the header. You can use text or macros.
    • If you leave the Value field empty, the header row will be removed.
    • To add an empty row as the header, type an empty space in the Value field.
  5. Click Create config. The header is configured. The page with the details of the newly configured header opens.
  6. Log in to the GoodData Portal and verify that the headers export correctly.

Configure Headers through API

See the API for customizing the headers.

Macro References

You can apply the following macros for XLSX headers. You can use them separately or insert them inline with other text references.

Report Related Macros

%PROJECT_NAMEThe name of the workspace
%REPORT_NAMEThe name of the source report
%REPORT_DESCRIPTIONThe description of the source report

Date and Time Macros

All date and time values indicate when the report was generated. Values in parentheses are examples for March 07, 2018 at 2:04:05 p.m.

%YYYYYear (2018)
%YYYear (18)
%MMMonth with a leading zero (03)
%MMonth (3)
%DDDay of month with leading zero (07)
%DDay of month (7)
%HHHour with leading zero in 24-hour format (14)
%HHour in 24-hour format (14)
%hhHour with leading zero in 12-hour format (02)
%hHour in 12-hour format (2)
%ama.m. or p.m. (p.m.)
%mmMinutes (04)
%ssSeconds (05)
%zGeneral time zone (PST)
%ZRFC 822 time zone (-0800)