Web functions
All 3 functions in this category
WEBSERVICEWEBSERVICE pulls the raw response from a given URL and returns it as a plain‑text string, letting you import live web data into Excel worksheets.FILTERXMLFILTERXML parses a text string containing XML and returns the values that match a supplied XPath query, spilling results into adjacent cells.ENCODEURLENCODEURL converts a text string into a percent-encoded URL component, escaping characters that are illegal in web addresses.