Web
★ 12 · ◉ 5 · Excel 2013
=FILTERXML()
Extracts custom data from an XML text
=FILTERXML(xml, xpath)
Text Manipulation
External Data, Web & Cube
Web
★ 12 · ◉ 3 · Excel 2013
=ENCODEURL()
Converts text to a form that can be used in a web address
=ENCODEURL(text)
External Data, Web & Cube
Web
★ 15 · ◉ 2 · Excel 2013
=WEBSERVICE()
Reads information from a web address and returns it as text in the cell
=WEBSERVICE(url)
External Data, Web & Cube