Better Sheets

Share this post

Extract URLs from Google Sheets

bettersheets.substack.com

Extract URLs from Google Sheets

Alea
Jan 31, 2023
Share
Extract URLs from Google Sheets

Today’s post is going to go into extracting URLs, which is a pretty interesting thing you might be frustrated doing by hand.

What if you’re a VA, you have a VA, or you have other people working for you in Google Sheets? We want to get links in there because we want to make our Sheets interactive.

We want to include a link. And that’s what I’m here for, to help you make better Google Sheets.  Now let’s get started!

In your Google Sheet, what if you’re getting a bunch of text and websites in, but we want to keep our information dense. So you might have a column for name or title, and another column for website (a URL). But sometimes, we want to kill that URL column because we’re just going to end up with a list of links all the way down. We don’t really want to see that. What we want is this: Give the title a URL.

Read it all:

https://blog.bettersheets.co/extract-urls-from-google-sheets/

Share
Comments
Top
New
Community

No posts

Ready for more?

© 2023 Andrew
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great writing