The WEBSERVICE function is only available in Excel 2013 and later for Windows.

A web service uses a protocol like HTTP to retrieve data in a machine-readable format like XML or JSON.

In the example above, WEBSERVICE is used to fetch breaking news from NASA.

Sample rss in xml format

In the example shown, this is how the data and title of each article is extracted.

ENCODEURL Function

The Excel ENCODEURL function returns a URL-encoded string composed of US-ASCII characters.

ENCODEURL is only available in Excel 2013 and later on Windows.

Sample rss in xml format

Sample rss in xml format

Sample rss in xml format

Sample rss in xml format

Excel FILTERXML function

Excel ENCODEURL function

Sample rss in xml format