This reference lists 5 Excel web functions, ordered by frequency of use, with high-frequency functions marked ⭐. Each function includes its syntax and an example.
| Function | Description | Example |
|---|---|---|
ENCODEURL |
Returns a URL-encoded string | =ENCODEURL("Excel tutorial") — Encodes text into URL format — Chinese, spaces etc. become %XX sequences |
FILTERXML |
Returns specific data from the XML content by using the specified XPath | =FILTERXML(xml,"//book/title") — Extracts specific node data from an XML string via an XPath |
IMAGE |
Returns an image from a given source | =IMAGE("https://example.com/image.jpg") — Displays the image at a URL inside a cell, with sizing and alt text support |
URLPARSE |
Extracts the components (scheme, host, path, etc.) of a URL | =URLPARSE(url,"scheme") — Extracts components such as scheme, host and path from a URL |
WEBSERVICE |
Returns data from a web service | =WEBSERVICE("https://api.example.com/data") — Fetches data from a web service, returning XML or text |
From Online Toolbox (www.vba.net)