Author: Oscar Cronquist Article last updated on April 12, 2018

The WEBSERVICE function gets data from a web service on the Internet or Intranet.

The function returns a #VALUE error if the returned value is above the cell limit of 32767 characters.

Formula in cell B2:

=WEBSERVICE("http://www.google.com")

Excel Function Syntax

WEBSERVICE(url)

Arguments

url Required.  An URL (Uniform Resource allocator) to a webpage on the internet or the intranet.

Comments

HTTP:// and HTTPS:// are supported.

An URL larger than 2048 returns #VALUE error.

Protocols like ftp:// and file:// are not supported, the WEBSERVICE function returns #VALUE error.