WEBSERVICE function
data from a web service.This function is not available in Excel for the web.
Web · Excel 2013+ · Guided Excel example
Where can you use it?
Teams bringing external data into Excel. Check the connection and Excel platform required by the example when a report depends on a URL or other external data.
Scenario in the workbook
Retrieve HTTPS responses in desktop Excel for Windows. The server and connection settings determine the output.
A worked example from the workbook
| Row | A |
|---|---|
| 6 | Input |
| 7 | https://example.com/ |
| 8 | https://example.org/ |
| 9 | https://example.net/ |
Record 1
=WEBSERVICE(A7)Illustrative outputResponse text if reachable
See the inputs and instructions for all 3 examplesSyntax
WEBSERVICE(url)
Worked examples
Retrieve HTTPS responses in desktop Excel for Windows. The server and connection settings determine the output.
Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.
| Row | A |
|---|---|
| 6 | Input |
| 7 | https://example.com/ |
| 8 | https://example.org/ |
| 9 | https://example.net/ |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =WEBSERVICE(A7) |
Response text if reachable |
| Record 2 | =WEBSERVICE(A8) |
Response text if reachable |
| Record 3 | =WEBSERVICE(A9) |
Response text if reachable |