WEBSERVICE function. Get data by specifying a URL.(Microsoft Excel)


Japanese version.

This function is used to retrieve data by specifying a URL.

This function is mainly used for web pages, files on the web, and Web APIs.

Data to be retrieved can be in text format, such as JSON, XML, or HTML.

How it works

URLRequired argument.
URL to retrieve data.


The data is obtained in HTML format with the URL specified in the example.

If it exceeds 32767 characters, it returns a #VALUE error.

Any information can be retrieved by specifying the FILTERXML function for the retrieved HTML or XML formatted data.

It is safer to convert URL parameters with the ENCODEURL function.


If you specify the argument "URL" the cell range, it will be Spil.



Microsoft Excel Functions Web