ISURL in Google Sheets: Screen URL Values and Review Exceptions
Use ISURL in Google Sheets to screen URL values, account for protocol and top-level-domain limits, and distinguish a format check from link accessibility.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =ISURL("google.com") has expected result TRUE under Google’s documented examples. ISURL tests whether a value is recognized as a URL; an explicit https:// prefix is not required in every accepted form.
Syntax and scope
=ISURL(value)
The single value is required, with no optional arguments or defaults. Use a quoted literal or a reference to the cell containing the URL value.
The Google ISURL reference says a fully qualified address is not always necessary. It also warns that a FALSE result can reflect an unrecognized top-level domain. Treat the function as a Sheets recognition check, not a universal definition of all possible internet addresses.
Worked example: review a URL input column
Enter these plain text values in A1:A5:
| Row | A: Submitted value |
|---|---|
| 1 | Submitted value |
| 2 | https://www.google.com |
| 3 | www.google.com |
| 4 | google.com |
| 5 | Review this later |
Enter Recognized URL in B1 and fill this formula from B2 to B5:
=ISURL(A2)
The documentation-based expected results are TRUE, TRUE, TRUE, FALSE. The first three use the recognized Google domain and documented URL forms. The last is ordinary prose rather than an address. These expectations have not been observed in a native Sheets session.
For a review label, use:
=IF(ISURL(A2),"URL-shaped value","Review input")
The first three rows are expected to display URL-shaped value, and the last Review input. This label intentionally avoids claiming that a destination is reachable, safe or authorized.
Accepted protocols are broader than web pages
Google lists ftp, http, https, gopher, mailto, news, telnet and aim among valid protocols. Therefore, a business rule requiring an HTTPS web page is stricter than ISURL’s general purpose.
For example, a URL-like communication address and an HTTPS document address may serve very different purposes. Do not use a general TRUE result as the only gate for a workflow that expects a particular website, protocol or content type. Additional rules should be chosen from the destination system’s requirements.
A missing protocol also deserves a deliberate policy. Recognizing google.com as a URL does not mean it contains the explicit secure prefix that your export or downstream system may require.
Advanced application: preserve raw inputs and separate review stages
For an input tracker, keep four distinct fields:
- The original submitted text, so corrections can be audited.
- The ISURL recognition result.
- A reviewer-approved destination, if correction was needed.
- A separate note about accessibility or intended use.
This structure prevents a false result from automatically deleting a legitimate unfamiliar domain. It also prevents a true result from being mistaken for an access check.
A simple display link can be conditionally produced from the original URL value:
=IF(ISURL(A2),HYPERLINK(A2,"Open reference"),"Review input")
For the first example row, the documentation-based expected display is the label Open reference, linked to https://www.google.com. For the prose row, the expected display is Review input. Google’s HYPERLINK reference supplies the separate link-construction contract. Do not click unknown submissions merely because they pass this test.
Apply the validation to the plain destination field. A friendly label such as “Open reference” is not itself the URL. The reviewed ISURL page does not establish a general mechanism for extracting destinations from rich-text links or multiple links embedded in a cell.
False results and troubleshooting
When a plausible address returns FALSE, inspect it for accidental spaces, truncated text or a mistaken domain. Also consider Google’s documented top-level-domain list limitation. A FALSE result is a reason to review the entry, not conclusive evidence that the internet resource cannot exist.
When a recognized URL cannot be opened, investigate access restrictions, removed content or a destination problem separately. The documented function contract does not promise a request to the website, an HTTP-status check, a malware scan or proof of permission.
The reference does not enumerate a complete native error-token, blank-cell, numeric-input or array behavior matrix. This guide uses individual text values and does not infer coercion behavior from another product. Source errors should be investigated separately from an ordinary FALSE result.
Availability and verification
ISURL is documented for the rolling Google Sheets service. Its recognition can depend on Google’s supported domain list. Original introduction date, first release and last functioning numbered version were not established; no fixed version history or cross-product equivalence is claimed.
NOT_TESTED_IN_GOOGLE_SHEETS. Individual ISURL and HYPERLINK references were inspected on October 17, 2026. URL strings and label branching were independently reviewed. A general-purpose URL parser cannot establish Sheets’ proprietary recognition behavior, so outputs above are explicitly documentation-based expectations, not native test results.