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)