Google Sheets web functions
Web functions in Google Sheets, explained with live examples.
8 web functions in Google Sheets — 0 documented in depth so far, the rest indexed below and landing every week.
All Google Sheets web functions
The full set — deep dives on the way.
- ENCODEURL
- Encodes a string of text for the purpose of using in a URL query. .
- HYPERLINK
- Creates a hyperlink inside a cell.
- IMPORTDATA
- Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.
- IMPORTFEED
- Imports a RSS or ATOM feed.
- IMPORTHTML
- Imports data from a table or list within an HTML page.
- IMPORTRANGE
- Imports a range of cells from a specified spreadsheet.
- IMPORTXML
- Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
- ISURL
- Checks whether a value is a valid URL.
More Google Sheets function categories