Google Sheets web functions
Web functions in Google Sheets, explained with live examples.
8 web functions in Google Sheets — 8 documented in depth so far, the rest indexed below and landing every week.
Documented web functions
Syntax, examples, and the equivalent — ready now.
- ENCODEURLEncodes a string of text for the purpose of using in a URL query. .WebExcel
- HYPERLINKCreates a hyperlink inside a cell.WebExcel
- IMPORTDATAImports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.WebNo Excel equivalent
- IMPORTFEEDImports a RSS or ATOM feed.WebNo Excel equivalent
- IMPORTHTMLImports data from a table or list within an HTML page.WebNo Excel equivalent
- IMPORTRANGEImports a range of cells from a specified spreadsheet.WebNo Excel equivalent
- IMPORTXMLImports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.WebNo Excel equivalent
- ISURLChecks whether a value is a valid URL.WebNo Excel equivalent
More Google Sheets function categories