How to enable Hyperlink when exporting report from servicenow to excel

[Vijay Kumar4]

While exporting a ServiceNow table to Excel, the number field is not populating as a hyperlink to the incident, request, or change request. It is showing as a number only. How can I turn those into hyperlinks so clicking on the number will take me to the actual ticket or task?

[Robert H]

Hello @Vijay Kumar4 ,

https://<yourinstancename>.service-now.com/sc_request.do?sys_id=REQ0027477

will definitely take you to that request.

Please press CTRL while clicking on the link in Excel, and check the documentation for the HYPERLINK Excel formula to make sure it generates the link in the above format.

Regards,

Robert

[Vijay Kumar4]

The URL returns 'No record found' because the Request number is being passed instead of the sys_id.

[Robert H]

Hello @Vijay Kumar4 ,

Even though the URL parameter is named "sys_id" it will also accept other unique values, like the number.

I'm not sure why you get this error. I have used this trick for many years and it still works fine in an OOTB Yokohama instance.

Regards,

Robert

[Ankur Bawiskar]

@Vijay Kumar4 

You cannot export the Number field with link in it by default within ServiceNow.

You will have to perform manual manipulation in excel file

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Vijay Kumar4]

How to do that in excel?