change the column header of when a report is exported to CSV

bree1
Kilo Contributor

Is it possible to change the column header of when a report is exported to CSV. By default the column header is the table field name when a report is exported to CSV. So for end users, the field names are not usable to them. They are more interested to see common lay mans term as column headers.

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Bree,

 

I don't think this is possible. You may have to check the out of box export functionality.

 

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Bree,

Any update on this?
Can you mark my answer as correct, helpful and hit like if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Sakshi14
Giga Expert

Hi Bree,

While we cannot yet add custom headers to a CSV export, we can now definitely enable Column labels to be displayed as header instead of the column names. You just need to set the property 'glide.export.csv.column_header_label' to true. This property is available starting Madrid release.

Hope this helps!

Thanks
Sakshi

John Francis
Tera Expert

Is there a way to set this property on a report-by-report basis?  I'd like to use labels for new reports exported, but there are several scheduled CSV exports that are ingested by other systems and they are using the field names.  

Thanks in advance for any replies.