- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2021 09:58 PM
Hi Team,
We are exploring a way to change column header names while downloading a report/exporting
data through excel/CSV we are having two cases
1.can we change column headers to different names while downloading? Is this possible through a view?
2.Can we change data from the table to uppercase and download it in excel?
use case: we have a system developed in SAP they were using different columns and data formats earlier where they got data from SharePoint and share point is being replaced by ServiceNow.
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2021 10:52 PM
Hi,
There is one option available via data base view. Follow the steps:
1) Create a database view
2) You can add only one table to database view. Add your table with some variable prefix. Remember this prefix. Refer screenshot1 below
3) Goto System Definition > Language File and create a new language file with following details
- Table = your database view created
- Label = The name you want in the export
- Plural = Plural form of label
- Element = The field in database that need to be renamed. You have to prefix the variable prefix used in database view (from step 2). I gave inc as variable prefix in database view. So, I used inc_short_description to refer short_description field. Refer screenshot2
And the output is below. You can use the Database View for export
Palani
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2021 10:05 PM
You can explore the Export controls
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2021 10:09 PM
Hi,
You can check the link mentioned by Pranesh but I doubt for the file name you can change or not
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2021 10:12 PM
Hi Ankur,
2.Can we change data from the table to uppercase and download it in excel?
we have ids created in a column and the data is in lowercase/upper case can we change it to uppercase in the downloaded file?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-15-2021 10:18 PM
Hi,
2.Can we change data from the table to uppercase and download it in excel? -> I doubt for this
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader