How to Extract URLs from Hyperlinks in Google Sheets

Transform your data analysis: Support here for direct consults and premium content: https://ko-fi.com/hashalinz

In this Google Sheets tutorial I'll be showing you two main types of hyperlinks in Google Sheets and how to extract links from both types. This includes creating and using a custom function with Google Apps Script to extract URLs, even when you have multiple hyperlinks within a single cell.

In this video, we'll first learn how to create hyperlinks using the HYPERLINK formula and directly within a cell (Ctrl+K). Then, I will guide you through the nuances of these two methods and demonstrate how to extract URL data from both using the FORMULATEXT function and a custom script.

The script I've shared here is one I've seen used online from here: https://www.oksheets.com/extract-hype..., but I noticed it could us some improvements. The initial script had issues with case-sensitivity and required you to completely rewrite the formula in case of an error. I've improved the script to handle these issues more efficiently, and you can see the improved results in the video.

Finally, I take it a step further by showing how to extract multiple links from a single cell, a unique feature of Google Sheets. You'll also see how to modify the script to transpose the URLs into a row. Here's the final script: https://script.google.com/d/1-RxfEgtF...

Make sure to let me know in the comments if this video has been helpful and give it a like. Your feedback helps me improve and deliver more useful content.

----------------------------------------------------------------------------------------------------
⏳ TIMESTAMPS
----------------------------------------------------------------------------------------------------
0:00 The two types of links in Google Sheets
0:31 Extracting links from the HYPERLINK function
1:43 Original script I found online (link in description)
3:03 Problem #1: Case Sensitivity
3:43 Fixing the first problem
5:15 Problem #2: Multiple links
6:11 Fixing the second problem
7:40 How to transpose in Google Apps Script
8:07 Final result

----------------------------------------------------------------------------------------------------

💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓