Extract URLs from Google Sheets

Pesky hyperlinked text gets in our way when we want a URL. Here's how to fix it.

🕰️ Time Saving Tips, Tricks and Techniques

🤖 Add AI to Your Sheets

🚀 Tools and Templates For YOU:

Generate Google Sheets Formulas:

100 Free Business Ideas - Lead Magnet, product, and business ideas you can make in a Google Sheet to validate your business ideas.

Tiny Sheets - Easily delete unnecessary rows and columns

Sheet Styles - Change your spreadsheets style to match your mood.

Atomic Sheets - 100 Spreadsheet elements you can add to your spreadsheets immediately.

Generate REGEXMATCH formulas to clean data

Generate SPARKLINE formulas to make cool charts inside of cells.

😎 Most Popular Tips and Tricks

Extract Urls from Google Sheets

⚙️Automate Your Sheets:

Spreadsheet Automation 101, get started making your sheets work for you, while you sleep

Learn to Code in Sheets - A quick course to get you started on Apps Script. Coding in sheets makes automating your sheets so much easier!

📺Step-by-Step Tutorials

Disclaimer: Some of these links go to one of my websites and some are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you.

[alisazphotovideo]

I spent the whole day trying to batch extract individual image links from Dropbox files for over 1000 images by using all these fancy automation tools, looked through dozens of videos and YOU are the only one who brought me straight to the solution! THANK YOU! <3

[rocioocana]

Thank you so much! This is a lifesaver! I would just suggest you add the formulas so they're ready to copy and paste.

[plantahiperactiva]

It's almost 1 AM and this tutorial saved my night!!

[PQBHD]

Thank you for sharing the video! I had heard of this script a while ago but was never able to get it working because I don't know how to use scripts. Your video showed me clearly what to do and it's working!

[jimbeattieexperience]

I'd been on that page for ages, couldn't make it work - thanks so much for the walkthough <3

[viessemondo]

HI
Is it possible to transport a value into a variable via the URL and print it on the other page? Thank you

[shamanthrajreddy]

Thank you so much, It is working for me,
And Im really curious to know is there any way to extract these hyperlinks using python in an IDE

[AshishSrivastava]

This was very very useful. Thank You and Tyler

[tomasjarvis]

just save my evening with this!!, thank you and thank you for sharering Tyler Robertson's work

[sonofsamson]

sweet, first time using app script in gsheets and this worked!

[hollow_grimm]

Do you have to run the code first? Cause i am getting an “Error Exception: Argument cannot be null: a1Notation” when I run the code. The formula also is not working

[vineetjamwal]

Thank you for sharing this...much help!!

[Kidsanimation]

Hey can you please highlight video of website scraping using good sheets?

[everythingbya.r]

Thanks alot my friend, awesome, else i have to write all the links hardcode for my students

[shontrashi]

thank you . even chatGPT couldn't give me this code. u saved me so much time.

[martvainu]

You rock! Straight to the point and great presentation.

[ketchup]

Thank you so much! This is exactly what I was looking for.

[DiegoKersjes-xmln]

I always get TypeError: Cannot read properties of null (reading 'getLinkUrl') (line 5). Why is that?

Am using the formula =GETLINK(CELL("Address";R2))

[pickleballist]

BRILLIANT!! Thanks for taking the time to share this!

[diduschannel]

thank you so much for such a quick and effective solution!