How to Convert All URLs in Google Sheets to Hyperlink

Whether you're managing data, organizing research, or preparing reports, Google Sheets is a powerful tool. One common task is working with URLs, but sometimes, long URLs can clutter your sheet.

In this blog post, we'll explore using a script & formula to convert all URLs in your Google Sheet to a simple, cleaner display text like "Test Link."

Why Convert URLs to "HyperLink"?

Long URLs can be cumbersome and distract from the data's main focus. Converting them to "Link" not only makes your sheet look cleaner but also improves readability and usability. This method is especially useful when sharing sheets with others or presenting data professionally.

Linking in a Google Doc or Spreadsheet

In Google Docs or Google Sheets, you can insert hyperlinks directly without using Google Apps Script. Here's how:

• Google Docs: Highlight the text you want to link, right-click, and select "Link." Then, paste the URL you want to link to.

• Google Sheets: Click on the cell where you want the hyperlink, then go to Insert > Link and paste the URL.

HYPERLINK("https://www.makeinfo.co","Test Link")

Syntax

HYPERLINK(url, [link_label])