web functions
fetch and parse data from outside the sheet.
| function | signature | what it does | tests |
|---|---|---|---|
| DECODEURL | DECODEURL(text) | decodes URL-encoded text | 1 |
| ENCODEURL | ENCODEURL(text) | encodes text for use in URLs using percent encoding | 2 |
| QUERY | QUERY(data, query, [headers]) | runs SQL-like query on data range | 1 |