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

janestone
Kilo Contributor

This is great for a List report, but is there anyway to export one of the chart type reports, complete with its data set to Excel?


Hi Jane!!
|
All the reports which are not in List format cannot be exported into Excel. If you want to perform a scheduled job and in-order to get an excel file the chart needs to be in "list" format


dpatti
Kilo Contributor

Hi, everyone.   Just a quick update on this. Using Kingston. I have a Mac w/Chrome and FireFox and this does NOT work on either of those. Right mouse click does NOT display the correct menu.



I had to switch over to Windows 10 with Internet Explorer. I assume most recent versions of windows will work.


Hi, i am facing the same issue with Kingston. Only the thing is that i am using it on Windows 10 in IE, but still option to export report is not visible.

 

Have you found any solution for this ?

sheilaroy
Kilo Explorer

Does anyone know what security is needed to see the Export > Excel functionality? The only options when using the right click is Bar Chart, Pie Chart, Launch Interactive Analysis.

find_real_file.png