Type in Google’s function list
Web functions
Functions that take data from the web into a sheet. Google prints 8 Web function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| ENCODEURL | ENCODEURL(text) | Encodes a string of text for the purpose of using in a URL query. |
| HYPERLINK | HYPERLINK(url, [link_label]) | Creates a hyperlink inside a cell. |
| IMPORTDATA | IMPORTDATA(url) | Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format. |
| IMPORTFEED | IMPORTFEED(url, [query], [headers], [num_items]) | Imports a RSS or ATOM feed. |
| IMPORTHTML | IMPORTHTML(url, query, index) | Imports data from a table or list within an HTML page. |
| IMPORTRANGE | IMPORTRANGE(spreadsheet_url, range_string) | Imports a range of cells from a specified spreadsheet. |
| IMPORTXML | IMPORTXML(url, xpath_query) | Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. |
| ISURL | ISURL(value) | Checks whether a value is a valid URL. |
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.