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.
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.