Extract URLs or Link Text from a Google Sheets Cell

Here’s an advanced trick for Google Sheets. If you have a hyperlink in a cell, there’s an easy way to extract the link text and the URL separately.

To read the full article, visit this link:

[craigecarrollocr]

Apparently, this video is out of date. The script does not work.

[NitishKumar-tbdg]

Doesn't work for me, it says there's a syntax error in line 22. I am not able to figure out though where the syntax is going wrong.

[AnandanKonar]

I got the following error : TypeError: Cannot read property "1" from null. (line 15, file "Code")

[courtneyb]

line 22 is missing the backslash. this is what it should read:
var url =

[VideoNOLA]

A much, much harder challenge is to extract the URL from a hyperlink displayed in a Google Sheet cell, but which was not created using the =HYPERLINK formula (i.e. it was imported or pasted from an HTML anchor, say, in a Web page). I'm wondering if you have any formula- or script-based solution to that!

[marianamccready]

This script is amazing and just saved me about 4 hours of manually opening cells and copy/pasting URLs to the next column :)

[SirJorasminChannel]

got an error :
TypeError: Cannot read property '1' of null (line 15, file "Code"

[MrVijn]

Thanks for the plain text converter..helped me finish my project

[MrBoingts]

I get the TypeError: Cannot read property "1" from null. (line 15, file "Code"), i then dismiss it and when i run it it has an error when loading data

[Kupsko]

No longer works, says there is syntax error on line 22

[ajt]

How do I get multliple links out of one cell?

[granthathaway]

Is there an updated version for Apps Script?
I get the error, "Syntax error: ParseError: Invalid regular expression line: 22 file: linkURL.gs."

[verkooppartner]

Works like a charm, thanks a lot! The "TypeError: You can/should just ignore the "Cannot read property "1" from null." error (given when saving the script). Great script, great tutorial...

[jazzybeat]

Syntax error: ParseError: Invalid regular expression line: 22 file: Code.gs

[tarawiselove]

Error: "Syntax error: ParseError: Invalid regular expression line: 22 file: Code.gs"

Line 22: var url =

[glenngyn]

Hi, thanks a lot for the share.
It did not work for me /

TypeError: Cannot read property "1" from null. (line 15, file "Code")


do you have an idea to resolve it?

[paulhitchman]

ParseError: Invalid regular expression (line 22, file "Code.gs")

[ProgrammingNewbie]

link was used using the "hyperlink" function, naw no thanks I still with scrapy and xpath to extract urls. Yawn

[soporteinformatica]

Gracias, me sirvió de mucha ayuda tu video, me puedes ayudar a insertar la url del archivo en una celda por app script,