URLs in Query Builder are not clickable in Excel

Modified on Fri, 10 May, 2024 at 8:35 AM


URLs extracted using Query Builder into an Excel spreadsheet are not clickable. This is as a result of the way the Microsoft API that we use for this works, so we can't readily change it. However, there is a simple solution in Excel.


In the Excel report, add a new column next to the URL. Add a new formula after the header row in that column:
=HYPERLINK(A2,A2)   (this assumes the original URL is in column A).
Copy this down to the rest of the rows in the spreadsheet.


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article