Excel web functions

Web functions in Excel, explained with live examples.

3 web functions in Excel — 3 documented in depth so far, the rest indexed below and landing every week.

Documented web functions

Syntax, examples, and the equivalent — ready now.

ENCODEURLReturns a URL-encoded stringThis function is not available in Excel for the web.WebGoogle Sheets
FILTERXMLReturns specific data from the XML content by using the specified XPathThis function is not available in Excel for the web.WebNo Google Sheets equivalent
WEBSERVICEReturns data from a web service.This function is not available in Excel for the web.WebNo Google Sheets equivalent

More Excel function categories