Formulas > =HYPERLINK()

How To Use HYPERLINK() Function in Google Sheets


Creates a hyperlink inside a cell.

Common Questions About the HYPERLINK Formula:
- How do I create a HYPERLINK in Google Sheets? You can copy paste a hyperlink into a cell, or construct one with CONCATENATE or JOIN, and wrap it with the HYPERLINK formula.
- What is the difference between Hyperlink, Link, and URL? a URL is an address, a link is something you can click on to go to another site or part of another site. a hyperlink is a link.
- How do I link to a website in a spreadsheet cell? You can use the HYPERLINK formula to link to a website, or a spreadsheet file, or a spreadsheet cell.

How Can the HYPERLINK Formula Be Used Appropriately?
- To quickly create hyperlinks to websites, documents, and other online resources.
- To make a sheet easier to navigate as users can click around to different cells/sheets.

How Can the HYPERLINK Formula Be Commonly Mistyped?
Not including the "HYPERLINK(" text in the formula.  Leaving out the leading "http://" or "https://" text of a url. Also can be mistyped as LINK, or HYPRLINK, or HYPERLNK, or HYPELINK.

What are Some Common Ways The HYPERLINK Formula Is Used Inappropriately?
- Linking to a malicious website.
- Not using the “HYPERLINK” formula at all but instead using =IMAGE or =INDIRECT.

What are Some Common Pitfalls When Using The HYPERLINK Formula?
- Not double checking the formatting of the URL provided.
- Not encoding any non-ascii characters (e.g. ü or ☃) in the link properly.

What are Common Mistakes When Using The HYPERLINK Formula?
- Not wrapping the URL in quotes.
- Not correctly linking to the desired location.

What are Common Misconceptions People Might Have With The HYPERLINK Formula?
- That a link must point to a web page.  (It can point to a range of cells in a sheet, or a tab)
- That the link must be live in order to be effective. 
- That the HYPERLINK formula can be used to download files from the web.

How To Actually Use HYPERLINK() in Sheets

HYPERLINK(url, [link_label])

6Better Sheets Tutorials

Send daily emails to yourself to master sales every single day. 100% completely free for Better Sheet members.
We're actually gonna go build the dashboard today.
Create a click Edit: Google changed how the redirect is handled. It no longer automatically goes forward, so you will need to add a link for a user to click on again to go to the forwarded link.
Learn how to make better lead magnets from Google Sheet checklists. Great for marketers and solo operators trying to get more leads, more customers, more clients.
Find out how to turn some data you can copy/paste from the web into a branded lead magnet for yourself.

Check out Josh's Tweet about the sheet.
and check out his Podia.
The video shows the importance of adding personal touches to a Google Sheet to connect better with users. It explains how to analyze the sheet's data to find trends and best practices for website content. Lastly, it discusses ways to share the sheet widely while still giving credit to its creator.

Learn more about the HYPERLINK() formula:

The story behind Sell Daily: How I built a Google Sheet template for powerful words

Here are 366 words to help you sell. These words can be used in tweets, emails, promotions, and even Facebook ads. Sell Daily is a list of words that jumpstarts your promotional muscles. This sheet and this set of words are meant to be used one a day.

Generate a HYPERLINK() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.