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 · Accepted solution]

Hello @Vijay Kumar4 ,

This can only be achieved using an Excel formula.

Add a new column, e.g. "Link", to the Excel sheet and put the following formula in the second row:

=HYPERLINK("https://<yourinstancename>.service-now.com/sc_request.do?sys_id="&A2, A2)

Then apply this formula to all rows.

I don't have Excel so I cannot test it. If it does not work please consult the Excel documentation for the HYPERLINK function.

I also think you need to hold the CTRL key while clicking on the cell that contains the link.

Regards,

Robert

[Vijay Kumar4]

Thanks @Robert H, for your response.

So, for the above method, we need to include the sys_id field in the list view, correct?

Also, is there a way to achieve this directly within ServiceNow without updating the Excel file?

[Robert H]

Hello @Vijay Kumar4 ,

No, you don't need the sys_id. The Number of the task record is sufficient.

No, as mentioned before, this can only be achieved using an Excel formula.

Regards,

Robert

[Vijay Kumar4]

The url is not redirecting me to the request