Better Sheets

How to Use ISURL() in Google Sheets

Description

Checks whether a value is a valid URL.

How To Actually Use ISURL() in Sheets

ISURL(value)

Try ISURL yourself

In the range A1:A10, enter various text values. Use the ISURL formula in cell B1 to check if the value in A1 is a valid URL. Drag the formula down to B10 to check all values in the range.

Your formula

Hints (2)

Locale Separator ,

Official Docs

Better Sheets Tutorial

Data Validation with Formulas

The issues you might run into validating data and 4 formulas you can use to create workflows or processes in sheets. Covering: ISBLANK, ISFORMULA, ISURL, ISTEXT formulas.

Intermediate

IF() ISBLANK() ISFORMULA() ISTEXT() ISURL()

10 Things I Hate About Your Spreadsheets

10 Things I Hate About Your Spreadsheets and how to fix them. Here is a list of 10 things you can do today to make your sheets more lovable.

The 10 Things I Hate about your Sheets

Squeezed Rows
Garbage Data
Looks The Same
Crazy Column Width
Where’s Waldo
Of Results
Too Many Clicks
Instructions Unclear
Eye Strain and Headaches
Lazy Conditional Formatting
Too Many Cells

Conditional Formatting Data validation Beginner

IF() ISBLANK() ISEMAIL() ISURL()

Transcript-matched member videos for ISURL(). Click through to watch.

Watch more tutorials

Creating a Custom URL Link for Your Spreadsheet

Create an apps script function that gets the url of your spreadsheet int...

CONCAT() HYPERLINK()

Embed a Number in a Website from a Google Sheet

Ever wanted to display some data from a google sheet on your site? Witho...

Advanced

Advanced Coding in Google Sheets for Programmers

Add a Custom Menu Create Native-like Functions Get URL and Sheet ID's vi...

Advanced Intermediate

Enter Google Drive File Name Get URL

Create a simple automation with an installable trigger that allows you t...

Intermediate

Unlock these tutorials

Learn more about the ISURL() formula:

Generate a ISURL() formula for your needs

Describe your task in plain English and get a paste-ready formula that uses ISURL(). 2 free AI generations, no signup. Members get unlimited use.

Generate a ISURL() formula