Google Sheets
ISURL function in Google Sheets
Checks whether a value is a valid URL.
=ISURL(value)ISURL syntax and parameters
One argument, one required.
- valueanyRequired
The value to be verified as a URL.
ISURL examples
Formulas you'll actually reuse.
Is the website cell a valid URL?
=ISURL(E2)Result
TRUEOnly make a link when the text is really a URL:
=IF(ISURL(E2), HYPERLINK(E2, "Visit"), "no site")
ISURL in Excel
No direct equivalent — here's the way around.
Try ISURL in the playground
Edit the example — nothing to install.
Preloaded with the ISURL formula from Example 1 — change anything and watch it respond.
Loading the editor…
Related functions
More ways Google Sheets gets this done.
- ENCODEURLEncodes a string of text for the purpose of using in a URL query. .WebExcel
- HYPERLINKCreates a hyperlink inside a cell.WebExcel
- IMPORTDATAImports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.WebNo Excel equivalent
- IMPORTFEEDImports a RSS or ATOM feed.WebNo Excel equivalent
- IMPORTHTMLImports data from a table or list within an HTML page.WebNo Excel equivalent
- IMPORTRANGEImports a range of cells from a specified spreadsheet.WebNo Excel equivalent