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

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:

=REGEXEXTRACT(FORMULATEXT(A1),"\"(.+)\"")

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.

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 Bardeen.ai/download.