ISURL
Unsupported (not recognized)Category: Web · Last tested 2026-09-01
Real compatibility results for the ISURL function: executed in Excel for the web, Google Sheets and LibreOffice Calc, measured against Google’s published documentation. Excel does not document ISURL, so this page makes no claim about Excel. Syntax and links to that documentation are below.
Support matrix
| Engine | Documented | Live-tested | Verdict |
|---|---|---|---|
| Excel (desktop) | No | n/a (not an Excel function) | n/a |
| Excel for the web | — | Yes (recalc, 2026-09-01) | Unsupported (not recognized) |
| Google Sheets | Yes | Yes (Drive import, 2026-09-01) | Supported, behaves as documented |
| LibreOffice Calc | No | Yes (25.8.7.3, 2026-09-01) | Unsupported (not recognized) |
LibreOffice version history
We executed the same test cases under each LibreOffice release to show exactly when ISURL’s support changed — not documentation claims, real results.
| LibreOffice version | Verdict | Tested |
|---|---|---|
| 24.2.0.3 | Unsupported (not recognized) | 2026-09-01 |
| 24.8.7.2 | Unsupported (not recognized) | 2026-09-01 |
| 25.2.0.3 | Unsupported (not recognized) | 2026-09-01 |
| 25.8.7.3 | Unsupported (not recognized) | 2026-09-01 |
Why isn't ISURL working in LibreOffice?
LibreOffice Calc does not implement ISURL as of 25.8.7.3 — in our
executed tests it returns a #NAME? (unrecognized function) error. This is not a typo or a
settings problem, and saving the file as .xlsx does not change it: the function simply isn’t
available yet.
Watch the LibreOffice version support page —
we re-run every test on each new release, so it will flip to Supported here as soon as it lands.
Discovered quirks
-
=ISURL("http://www.google.com") on
Excel for the web returned
#NAME?, but the documented/expected
result is True.
Provenance
ISURL's page prints four Sample Usage formulas and NO results, but unlike ISEMAIL it does carry a real Notes section, and the Notes are the authority for this file: "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases."; "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim."; "If a URL is flagged as 'False', it may use a top-level domain that isn't on our list." That last bullet means the page itself declines to define the boundary, so this corpus asserts only inputs the Notes settle. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("www.google.com") on
Excel for the web returned
#NAME?, but the documented/expected
result is True.
Provenance
DERIVED from the Notes bullet "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases", applied to the page's own second sample input. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("google.com") on
Excel for the web returned
#NAME?, but the documented/expected
result is True.
Provenance
The same Notes bullet at its limit -- this is the sample that makes the bullet mean something, since it has neither of the two things the bullet says are not needed. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("www.abc.xyz") on
Excel for the web returned
#NAME?, but the documented/expected
result is True.
Provenance
The page's fourth sample input. It pairs with the Notes bullet about an unlisted top-level domain: Google never publishes the list, so .xyz is asserted TRUE only because the page prints it as a sample of the function. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("mailto:someone@example.com") on
Excel for the web returned
#NAME?, but the documented/expected
result is True.
Provenance
DERIVED from the Notes bullet "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim." mailto is on that list and is the least URL-looking member of it, which is what makes it worth executing. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("not a url") on
Excel for the web returned
#NAME?, but the documented/expected
result is False.
Provenance
DERIVED, and deliberately far from the boundary: the Notes make clear the page will not say where the boundary is, so the only FALSE this corpus asserts is one no protocol or top-level-domain list could rescue. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected False, got '#NAME?'
-
=ISURL("http://www.google.com") on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is True.
Provenance
ISURL's page prints four Sample Usage formulas and NO results, but unlike ISEMAIL it does carry a real Notes section, and the Notes are the authority for this file: "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases."; "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim."; "If a URL is flagged as 'False', it may use a top-level domain that isn't on our list." That last bullet means the page itself declines to define the boundary, so this corpus asserts only inputs the Notes settle. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("www.google.com") on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is True.
Provenance
DERIVED from the Notes bullet "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases", applied to the page's own second sample input. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("google.com") on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is True.
Provenance
The same Notes bullet at its limit -- this is the sample that makes the bullet mean something, since it has neither of the two things the bullet says are not needed. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("www.abc.xyz") on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is True.
Provenance
The page's fourth sample input. It pairs with the Notes bullet about an unlisted top-level domain: Google never publishes the list, so .xyz is asserted TRUE only because the page prints it as a sample of the function. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("mailto:someone@example.com") on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is True.
Provenance
DERIVED from the Notes bullet "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim." mailto is on that list and is the least URL-looking member of it, which is what makes it worth executing. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected True, got '#NAME?'
-
=ISURL("not a url") on
LibreOffice Calc returned
#NAME?, but the documented/expected
result is False.
Provenance
DERIVED, and deliberately far from the boundary: the Notes make clear the page will not say where the boundary is, so the only FALSE this corpus asserts is one no protocol or top-level-domain list could rescue. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501.; MISMATCH vs expected: expected False, got '#NAME?'
Executed test cases
Excel for the web (executed 2026-09-01 via OneDrive recalculation)
These values come from Excel for the web, not from desktop Excel. They are two different implementations of the calculation engine, and this run measured only the web one: the corpus was uploaded to OneDrive as .xlsx, recalculated by Excel for the web on open, and downloaded again for readback. Excel for the web is a rolling service with no pinnable version, so the run is identified by its date. Where a value here disagrees with the Expected column — which is Microsoft’s documentation of the desktop product — we cannot tell you whether the web engine diverges from the desktop one or the documentation is wrong about both, because we do not run desktop Excel.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =ISURL("http://www.google.com") | The page's first Sample Usage line: scheme and www both present | #NAME? | TrueProvenanceISURL's page prints four Sample Usage formulas and NO results, but unlike ISEMAIL it does carry a real Notes section, and the Notes are the authority for this file: "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases."; "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim."; "If a URL is flagged as 'False', it may use a top-level domain that isn't on our list." That last bullet means the page itself declines to define the boundary, so this corpus asserts only inputs the Notes settle. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence. |
Mismatch |
| =ISURL("www.google.com") | The page's second sample: www but no scheme | #NAME? | TrueProvenanceDERIVED from the Notes bullet "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases", applied to the page's own second sample input. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
| =ISURL("google.com") | The page's third sample: neither scheme nor www | #NAME? | TrueProvenanceThe same Notes bullet at its limit -- this is the sample that makes the bullet mean something, since it has neither of the two things the bullet says are not needed. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
| =ISURL("www.abc.xyz") | The page's fourth sample, on a non-.com top-level domain | #NAME? | TrueProvenanceThe page's fourth sample input. It pairs with the Notes bullet about an unlisted top-level domain: Google never publishes the list, so .xyz is asserted TRUE only because the page prints it as a sample of the function. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
| =ISURL("mailto:someone@example.com") | A protocol from the page's explicit list of valid protocols | #NAME? | TrueProvenanceDERIVED from the Notes bullet "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim." mailto is on that list and is the least URL-looking member of it, which is what makes it worth executing. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
| =ISURL("not a url") | A string of words with spaces, no scheme and no dot | #NAME? | FalseProvenanceDERIVED, and deliberately far from the boundary: the Notes make clear the page will not say where the boundary is, so the only FALSE this corpus asserts is one no protocol or top-level-domain list could rescue. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
Google Sheets (executed 2026-09-01 via Drive import)
Google Sheets is a rolling service with no pinnable version, so this run is identified by its date. The corpus was imported to Drive as .xlsx, recalculated by Sheets, and exported back for readback.
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =ISURL("http://www.google.com") | The page's first Sample Usage line: scheme and www both present | True | TrueProvenanceISURL's page prints four Sample Usage formulas and NO results, but unlike ISEMAIL it does carry a real Notes section, and the Notes are the authority for this file: "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases."; "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim."; "If a URL is flagged as 'False', it may use a top-level domain that isn't on our list." That last bullet means the page itself declines to define the boundary, so this corpus asserts only inputs the Notes settle. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence. |
Matched |
| =ISURL("www.google.com") | The page's second sample: www but no scheme | True | TrueProvenanceDERIVED from the Notes bullet "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases", applied to the page's own second sample input. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Matched |
| =ISURL("google.com") | The page's third sample: neither scheme nor www | True | TrueProvenanceThe same Notes bullet at its limit -- this is the sample that makes the bullet mean something, since it has neither of the two things the bullet says are not needed. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Matched |
| =ISURL("www.abc.xyz") | The page's fourth sample, on a non-.com top-level domain | True | TrueProvenanceThe page's fourth sample input. It pairs with the Notes bullet about an unlisted top-level domain: Google never publishes the list, so .xyz is asserted TRUE only because the page prints it as a sample of the function. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Matched |
| =ISURL("mailto:someone@example.com") | A protocol from the page's explicit list of valid protocols | True | TrueProvenanceDERIVED from the Notes bullet "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim." mailto is on that list and is the least URL-looking member of it, which is what makes it worth executing. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Matched |
| =ISURL("not a url") | A string of words with spaces, no scheme and no dot | False | FalseProvenanceDERIVED, and deliberately far from the boundary: the Notes make clear the page will not say where the boundary is, so the only FALSE this corpus asserts is one no protocol or top-level-domain list could rescue. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Matched |
LibreOffice Calc 25.8.7.3 (tested 2026-09-01)
| Formula | Description | Result | Expected | Verdict |
|---|---|---|---|---|
| =ISURL("http://www.google.com") | The page's first Sample Usage line: scheme and www both present | #NAME? | TrueProvenanceISURL's page prints four Sample Usage formulas and NO results, but unlike ISEMAIL it does carry a real Notes section, and the Notes are the authority for this file: "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases."; "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim."; "If a URL is flagged as 'False', it may use a top-level domain that isn't on our list." That last bullet means the page itself declines to define the boundary, so this corpus asserts only inputs the Notes settle. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. BATCH PROVENANCE (batch H, the first Sheets/LibreOffice-only batch). Every function in this batch has x == false in docs/data/compat.json: it is a Google Sheets function that Microsoft does not document at all, so this corpus makes NO claim about it in that engine and nothing here is measured against that vendor's documentation. The authority is Google's own support.google.com function page, cited by full URL and by the date it was read -- Google publishes no version number for these pages, so a bare URL dates nothing. WHAT GOOGLE ACTUALLY PRINTS, WHICH IS LESS THAN IT LOOKS: most of these pages carry a 'Sample Usage' block of FORMULAS WITH NO RESULTS. Where a value below is Google's own published output the note says so; where it is derived from the page's stated semantics the note says that instead, and says from which sentence. No value in this batch was taken from a search snippet, a blog or a mirror. LIBREOFFICE: probed on all four pinned builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) in five storage spellings -- plain, _xlfn., COM.MICROSOFT., ORG.OPENOFFICE. and _xlfn.ORG.OPENOFFICE. -- and #NAME? under every one of them, so the expected values below describe Google Sheets and the LibreOffice column records absence. |
Mismatch |
| =ISURL("www.google.com") | The page's second sample: www but no scheme | #NAME? | TrueProvenanceDERIVED from the Notes bullet "A fully qualified URL is not required. In other words, 'http' and 'www' are not needed in all cases", applied to the page's own second sample input. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
| =ISURL("google.com") | The page's third sample: neither scheme nor www | #NAME? | TrueProvenanceThe same Notes bullet at its limit -- this is the sample that makes the bullet mean something, since it has neither of the two things the bullet says are not needed. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
| =ISURL("www.abc.xyz") | The page's fourth sample, on a non-.com top-level domain | #NAME? | TrueProvenanceThe page's fourth sample input. It pairs with the Notes bullet about an unlisted top-level domain: Google never publishes the list, so .xyz is asserted TRUE only because the page prints it as a sample of the function. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
| =ISURL("mailto:someone@example.com") | A protocol from the page's explicit list of valid protocols | #NAME? | TrueProvenanceDERIVED from the Notes bullet "Valid protocols include ftp, http, https, gopher, mailto, news, telnet, and aim." mailto is on that list and is the least URL-looking member of it, which is what makes it worth executing. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
| =ISURL("not a url") | A string of words with spaces, no scheme and no dot | #NAME? | FalseProvenanceDERIVED, and deliberately far from the boundary: the Notes make clear the page will not say where the boundary is, so the only FALSE this corpus asserts is one no protocol or top-level-domain list could rescue. Google's ISURL page, read live on 2026-08-31 at https://support.google.com/docs/answer/3256501. |
Mismatch |
Docs & syntax
- Google Sheets: official documentation
Where ISURL behaves differently
- Google-only functions: what ports to Excel and LibreOffice, and what does not
Executed: 47 functions Google documents and neither Microsoft nor LibreOffice does, 189 cases, 183 of them #NAME? in LibreOffice on all four pinned builds after five- and nine-spelling probes. QUERY and ARRAYFORMULA do not port; the operator functions do exactly; REGEXMATCH, REGEXTEST and REGEX are three different functions with three regex flavours.