Check Sheet Logo
Check Sheet


The ISURL formula is used to check whether a given value is a valid URL. It returns TRUE if the value is a URL, and FALSE otherwise.


Use the ISURL formula with the syntax shown below, it has 1 required parameter:

  1. value (required):
    The value that you want to check for URL format. This can be a cell reference, a string enclosed in quotation marks, or a formula.


Here are a few example use cases that explain how to use the ISURL formula in Google Sheets.

Check if a cell value is a URL

You can use ISURL to quickly determine if a cell value is a valid URL without the need for complex regular expressions or other validation methods.

Filter URLs from a list of values

You can use ISURL in conjunction with other formulas such as FILTER to extract only the URLs from a list of mixed value types.

Validate URLs in a form response

If you are using Google Forms to collect data, you can use ISURL to validate that the URLs entered by respondents are in the correct format.

Common Mistakes

ISURL not working? Here are some common mistakes people make when using the ISURL Google Sheets Formula:

Using non-URL values as input

One common mistake when using ISURL is to use non-URL values as input. This can lead to unexpected results, such as TRUE being returned for values that are not actually valid URLs. To avoid this, make sure that you only use URLs or URL-like values as input.

Forgetting to escape special characters

Another common mistake when using ISURL is to forget to escape special characters in the URL. This can lead to syntax errors or FALSE being returned for valid URLs. To avoid this, make sure that you escape all special characters in the URL using the appropriate escape sequences.

The following functions are similar to ISURL or are often used with it in a formula:


    The REGEXMATCH formula searches for a regular expression pattern within a specified text string, and returns a boolean value of TRUE if the pattern is found, and FALSE if it is not found. This formula is commonly used to check if a string matches a certain pattern or to extract specific information from a text string based on a pattern.


    The HYPERLINK function creates a clickable hyperlink in a cell. It is commonly used to link to external websites, other sheets within the same document, or to specific cells within a sheet.


    The IMPORTXML formula allows you to import data from an XML or HTML document on the web. This can be useful for scraping data from websites or for importing data from APIs that return XML data. The formula takes a URL and an XPath query as inputs and returns the data that matches the query.

Learn More

You can learn more about the ISURL Google Sheets function on Google Support.