ExcelFlux

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

RowA
6Input
7https://example.com/
8https://example.org/
9https://example.net/
Record 1
=WEBSERVICE(A7)

Illustrative outputResponse text if reachable

See the inputs and instructions for all 3 examples

Syntax

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
Microsoft Excel reference