How to automatically export a daily report into an excel spreadsheet

[Cris P]

I have set up a spreadsheet which we currently use to display our Service Desk stats on: Incidents Resolved, Incidents Updated, etc.

I have daily scheduled reports which run from SNOW, but currently, I have to receive the report, then update excel manually with the figures.

I was wondering if there is any way that when the report runs it exports straight into a specific excel spreadsheet (the one i created), maybe in a raw data sheet? So then I can set formulas to populate the fields automatically?

I'm fine with setting up the formulas, but have no idea how I would import the reports directly into a raw data sheet so I can use that data to populate the fields which I currently populate manually.

Any ideas or advice?

Thanks for reading

[chirag_bagdai]

Hi Cristian,

Can you elaborate your requirement with some example for screenshot ?

However, I would say you can convert your all excel manual task to automate through ServiceNow.

You can create your custom table and use "Scheduled Job" scripts to update the data based on your calculation at your scheduled date/time.

[Pradeep Sharma]

Hello Cristian,

You may find the below blog helpful.

Attaching an Excel file of a report to an email notification

[Shishir Srivast]

Hi Cristian,

You can configure to get the report in excel in your email using schedule job.

Create one Report (Reports -> View/Run) template and save it as List type, for example : My Incident List

Now go to scheduled job (System Definition->Scheduled Job) and create a job, while creating the schedule job please select your saved report and Type as Excel (as highlighted below).

Please Note: Report saved with type List (as shown in above screenshot) will only give you an option to get the report in excel format.

Result:

[Rekha3]

Where i will get this option "System Definition->Scheduled Job"