I was working with a shared Google Sheet at work and ran into this:
![An excerpt of a Google Sheet. Each row contains a cell with a hyperlink labeled Link](https://osric.com/chris/accidental-developer/wp-content/uploads/2024/04/google_sheet_links.png)
I get it, URLs can be long and messy. We want narrow columns that look clean, not cluttered. But I wanted to analyze the URLs and search for certain content and patterns, which were hidden from me behind the link text.
How can I extract all the URLs?
Continue reading Extracting links from Google Sheets