Practice free

Web functions

Web functions encode text for URLs, call web services and read XML. Some are not available in every edition of Excel.

3 functions in this category.

Start here

All web functions

FunctionWhat it doesLevelSinceSpills?
ENCODEURL Turns spaces and symbols into URL-safe codes, so you can build query strings for web requests. Intermediate 2013 No
FILTERXML Digs values out of XML, usually the response from WEBSERVICE. Advanced 2013 Yes
WEBSERVICE Calls a web address and returns the raw response text, often fed into FILTERXML. Advanced 2013 No

Other categories