WEBSERVICE and ENCODEURL: Important Web Functions in MS Excel

Microsoft Excel has a few web functions that can be used while dealing with links. In this article we will look at two such functions – WEBSERVICE and ENCODEURL. These functions help one in dealing with data that are related to programming and coding. These functions were available from the Excel 2013 version.

Web Functions – WEBSERVICE

Priya has an URL in her sheet but she wanted to insert an HTTP. WEBSERVICE function can be used to download the HTTP response for an URL.

The difference between the two is that URL is a string of characters that can be used to locate a particular resource while HTTP is a protocol for the exchange of hypertext.

Syntax:

WEBSERVICE(url)

Where, ‘url’ stands for the cell reference containing the URL.

Suppose she has her URL in cell A1, to download the HTTP, she should select the cell and insert the following formula.

=WEBSERVICE(A1)

The HTTP will be downloaded and the result will appear as follows.

web functions 1

Alternatively, she can go to ‘Formulas’ menu, click on the ‘More Functions’ option. A dropdown list will appear. She should now choose ‘Web’ option and click on ‘WEBSERVICE’. The following dialogue box will appear. She can enter the necessary particulars and click ‘OK’.

web functions 2

Web Functions – ENCODEURL

ENCODEURL is a function can be used to insert the code for an URL. By converting an URL into a code, characters like ‘,‘, ‘/’, which have special meanings for themselves, will get replaced.

Syntax:

ENCODEURL(text)

Where, ‘text’ stands for the cell reference containing the URL.

To convert the URL into a code, she should select the cell and insert the following formula.

=ENCODEURL(A1)

The URL will be converted into a code and the result will appear as follows.web functions 3

 

Alternatively, she can go to ‘Formulas’ menu, click on the ‘More Functions’ option. A dropdown list will appear. She should now choose ‘Web’ option and click on ‘ENCODEURL’. The following dialogue box will appear. She can enter the necessary particulars and click ‘OK’.

web functions 4

 

Leave a Comment

Your email address will not be published. Required fields are marked *