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:


Excel Function Syntax



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


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.