In Google Sheets, I have a column with ~17,000 rows each containing text and a hyperlink. The link was not created using a formula and is only displayed when you hover over the cell.

I need to copy ONLY the links from the first column to the neighboring column. It would take years to do this manually and I can't find a quick solution on the internet.

How do I extract the URLs from the links?

Link to Sample Spreadsheet

  • Do you need to do this in Sheets? I think it might only be possible with Google Apps Script if so. Otherwise, I could give you a solution involving copying/pasting into other webapps, which I think could be done in less than 5 minutes. Obviously, this means that you would have to update it manually if more rows were added to the sheet.
    – Laurel
    Commented Feb 1 at 18:01

1 Answer 1


Use a custom function such as my RichTextLinks. Use it like this:

=RichTextLinks("A1:A1000", A1:A1000)

I maintain the code at the Stack link above, so you can always refer to it to get the latest version.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.