Export your reports to Excel format

Travers M
Mega Guru

I'm fairly sure I already know the answer to this one but maybe someone can tell me they have figured out a way to do this.   It looks like ServiceNow can only export a report in PDF format.   I'd like to have some of these export in Excel as we like the charts and graphs but need to add something else to them or change a number/manipulate data.   Has anyone here been able to have them export to Excel?

1 ACCEPTED SOLUTION

adiddigi
Tera Guru

Creating List Reports - ServiceNow Wiki didn't work for you?


You can export a list report as an Excel spreadsheet by right-clicking any column heading and selecting Export > Excel.


You can schedule a saved list report to export by clicking Schedule and specifying Type as Excel Spreadsheet. Excel displays report duration values in milliseconds, rather than the x days y hours format.


- wiki


View solution in original post

10 REPLIES 10

Swarup Patra
Kilo Guru

Yes, ServiceNow does provide the functionality to export reports in Excel format. Here are the steps to do so: 1. Navigate to the report you want to export. 2. Click on the context menu (three dots) in the top right corner of the report. 3. Select the "Export" option. 4. From the dropdown, select "Excel". Please note that the Excel export option is available for list reports and not for graphical reports. For graphical reports, you can export the underlying data as a list and then export that list to Excel. Here are the steps to export the underlying data of a graphical report: 1. Navigate to the graphical report you want to export. 2. Click on the context menu (three dots) in the top right corner of the report. 3. Select the "View / Run" option. 4. This will open the underlying data of the report in a list format. 5. Now, you can export this list to Excel by clicking on the context menu (three dots) in the top right corner of the list and selecting "Export > Excel". Remember, manipulating data in Excel after exporting it from ServiceNow will not change the data in ServiceNow. If you need to change the data, you should do it in ServiceNow itself. nowKB.com