App Tutorial

Extract URLs & Links from Google Sheets Easily (5 Steps)

Jason Gong
App automation expert
Apps used
Google Sheets
April 15, 2024

Extract URLs or link text from Google Sheets using formulas, Google Apps Script, or add-ons. Methods include using the =REGEXEXTRACT() and =FORMULATEXT() functions for formula-created links, right-click or keyboard shortcuts for opening multiple URLs, and custom scripts for embedded links.

Choose the method that best suits your data and preference.

Streamline your workflow and enhance productivity by automating the extraction process with Bardeen.

Extract URLs or Link Text from a Google Sheets Cell

Extracting URLs or link text from a Google Sheets cell can be accomplished through various methods, including formulas, Google Apps Script, and add-ons. The method you choose depends on the specifics of your data and your personal preference.

Automate the extraction of links and URLs from Google Sheets to save time and enhance productivity with Bardeen.

Google Sheets Extract URLs from Links

For hyperlinks created using the =HYPERLINK() function, you can use the =REGEXEXTRACT() function combined with =FORMULATEXT() to extract the URL. The formula looks like this:


This method works well for extracting URLs from cells where the hyperlink was created with a formula. However, it does not work for links pasted directly into cells.

Open Multiple URLs Google Sheets

To open multiple URLs from Google Sheets, you can select the cells containing the links and use the right-click menu option "Open links" to open them all simultaneously. This method is straightforward and does not require any additional setup or scripts.

Open Multiple URLs from Google Sheets

Another approach to opening multiple URLs is by using keyboard shortcuts. After selecting the cells with the links you wish to open, you can press Alt+Enter on Windows or Option+Enter on Mac. This method allows for a quick way to open several links at once without navigating through menus.

Discover more ways to automate your Google Sheets tasks with Google Sheet automations.

Custom Scripts and Add-ons

For links that are not created with the =HYPERLINK() function, a custom Google Apps Script function can be used to extract URLs. The script accesses the rich text value of the cell to retrieve the URL. Here's an example script:

function GETLINK(input){var sheet = SpreadsheetApp.getActiveSheet();var range = sheet.getRange(input);var value = range.getRichTextValue();var url = value.getLinkUrl();return url;}

After creating this script in the Google Sheets script editor, you can use the custom function =GETLINK("A1") in your sheet to extract a URL from a cell. This method is versatile and can handle various types of links embedded in cells.

Enhance your Google Sheets experience with powerful Google Sheets Add-ons.

Automate Your Google Sheets with Bardeen's Playbooks

Extracting URLs and links from Google Sheets can be a repetitive task, especially when dealing with large datasets. While manual methods are available, automating this process can save a significant amount of time and reduce errors. Bardeen offers a suite of playbooks designed to automate the extraction of links and URLs from Google Sheets, streamlining your workflow and enhancing productivity. Here are some examples of how Bardeen can automate these tasks:

  1. Save links from labeled emails to Google Sheets: This playbook finds emails with a specific tag, extracts all the links from the body text, and saves both links and emails to Google Sheets, simplifying the organization of your digital resources.
  2. Get data from Crunchbase links and save the results to Google Sheets: Automatically retrieve data from a list of CrunchBase links in a Google Sheets document and save the extracted information in a new Google Sheets spreadsheet, making it easier to compile and analyze data.
  3. Find all emails from a list of websites in Google Sheets: Streamline your email outreach by finding all emails from a list of websites directly in Google Sheets, enhancing your communication and networking efforts.

By leveraging Bardeen's automation capabilities, you can focus more on analysis and less on the manual extraction of data. Get started by downloading the Bardeen app at

Other answers for Google Sheets

How to Disable Download Option in Google Sheets

Learn how to disable downloads in Google Sheets by adjusting share permissions and protecting sheets, enhancing data security.

Read more
How to Download Specific Parts of Google Sheets

Learn how to download specific parts of Google Sheets using the sheet's GID for efficient data sharing and analysis. Streamline your workflow today.

Read more
How to Download Images and Charts from Google Sheets

Learn how to download images and charts from Google Sheets directly or from a URL list to Google Drive, including step-by-step instructions.

Read more
How to Convert Google Sheets to Excel

Learn to download Excel from Google Sheets in a few steps, ensuring file compatibility and offline access. Perfect for Excel users.

Read more
Effective Methods to Convert Numeric Dates to Written Months

Learn how to convert numeric dates to written months in Google Sheets using TEXT function, custom formatting, and more for enhanced data presentation.

Read more
Convert Time to Text in Google Sheets

Learn how to convert time to text in Google Sheets using the TEXT function and built-in formatting options for clear data presentation.

Read more
how does bardeen work?

Your proactive teammate — doing the busywork to save you time

Integrate your apps and websites

Use data and events in one app to automate another. Bardeen supports an increasing library of powerful integrations.

Perform tasks & actions

Bardeen completes tasks in apps and websites you use for work, so you don't have to - filling forms, sending messages, or even crafting detailed reports.

Combine it all to create workflows

Workflows are a series of actions triggered by you or a change in a connected app. They automate repetitive tasks you normally perform manually - saving you time.

get bardeen

Don't just connect your apps, automate them.

200,000+ users and counting use Bardeen to eliminate repetitive tasks

Effortless setup
AI powered workflows
Free to use
Reading time
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
By clicking “Accept”, you agree to the storing of cookies. View our Privacy Policy for more information.