Currently Im getting a data in tabular format , but need it in excel and want to attach it to mail.

[Naveen Bandaru]

I have a requirement where i need to get data from incident table and send the data in excel to mail.
using Mail script I'm getting that data in Tabular format, But need it in excel and attach it to mail.

[AlpUtkuM]

Hi @Naveen Bandaru 

Please check the following link : https://www.servicenow.com/docs/r/platform-administration/time-configuration/schedule-report.html 

[bandarunave]

Thanks for your help @AlpUtkuM 

[Tanushree Maiti]

Hi @Naveen Bandaru 

1. Create a report on your incident records.

2. Mark the sys_id.

3. Under your notification template ->Message HTML section , add following line.

   ${report:reportID:<sys_id_of_report>:xls}

4. Now for testing , generate the notification, you can see your xls report has been attached in the email.

Refer the blog: Attaching an Excel file of a report to an email notification

If you have different data source for incident like data source/transform map, Inbound flow etc

You can follow these articles:

Loading data from an email attachment

Import Excel File from Inbound Email via Flow