Web Excel Functions

Retrieve data from web services and URLs

Web data in spreadsheets

  • Fetch URL body → [WEBSERVICE](/functions/webservice/)
  • Parse XML with XPath → [FILTERXML](/functions/filterxml/)
  • Encode query strings → [ENCODEURL](/functions/encodeurl/)
  • Heavier ETL → [Power Query intro](/blog/excel-power-query-introduction/)

Functions in this category

  • ENCODEURL: Returns a URL-encoded string, replacing special characters with percent-encoded equivalents.
  • WEBSERVICE: Returns data from a web service on the internet or intranet.
  • FILTERXML: Returns specific data from XML content using the specified XPath.
  • IMAGE: Inserts an image from a URL into a cell.