Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get last row in mixed data with blanks in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Two-column Lookup in Excel
  • How to get first row number in range in Excel
  • Create hyperlink with VLOOKUP in Excel

Data Analysis Examples

  • How to sum a total in multiple Excel tables
  • How to add Trendline to a chart in Excel
  • How To Filter Data in Excel
  • How to calculate current stock or inventory in Excel
  • How to Create Gantt Chart in Excel

Data Validation Examples

  • Excel Data validation with conditional list
  • How To Create Drop-down List in Excel
  • Excel Data validation specific characters only
  • Prevent invalid data entering in specific cells
  • Excel Data validation unique values only

WEBSERVICE function: Description, Usage, Syntax, Examples and Explanation

by

What is WEBSERVICE function in Excel?

WEBSERVICE function is one of Web functions in Microsoft Excel that returns data from a web service on the Internet or Intranet.

Notes:

  • Microsoft introduced three new functions in Excel 2013 that will return data from a webservice.
  • The WEBSERVICE function is only available in Excel 2013 and Excel 2016 for Windows.
  • NOTE: This function may appear in the function gallery in Excel for Mac, but it relies on features of the Windows operating system, so it will not return results on Mac.

Syntax of WEBSERVICE function

WEBSERVICE(url)The WEBSERVICE function syntax has the following arguments.

  • Url    Required. The URL of the web service.

WEBSERVICE formula explanation

  • If arguments are unable to return the data, WEBSERVICE returns the #VALUE! error value.
  • If arguments result in a string that is not valid or that contains more than the allowable cell limit of 32767 characters, WEBSERVICE returns the #VALUE! error value.
  • If url is a string that contains more than the 2048 characters that are allowed for a GET request, WEBSERVICE returns the #VALUE! error value.
  • For protocols that aren’t supported, such as ftp:// or file://, WEBSERVICE returns the #VALUE! error value.

Example of WEBSERVICE function

To see illustrated example of WEBSERVICE function visit: 

1. https://www.microsoft.com/en-us/microsoft-365/blog/2013/03/21/use-webservice-functions-to-automatically-update-excel-2013-spreadsheets-with-online-data/
2. https://analystcave.com/excel-webservice-filterxml-functions/

Post navigation

Previous Post:

FILTERXML function: Description, Usage, Syntax, Examples and Explanation

Next Post:

ENCODEURL function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

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

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • PROPER function: Description, Usage, Syntax, Examples and Explanation
  • How to extract last two words from text string in Excel
  • How to extract substring in Excel
  • Remove last characters from right in a cell in Excel
  • How to count specific characters in a range in Excel
  • Convert decimal hours to Excel time
  • NOW function: Description, Usage, Syntax, Examples and Explanation
  • YEAR function: Description, Usage, Syntax, Examples and Explanation
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • Add decimal minutes to time in Excel
  • How to calculate present value of annuity in excel
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • Calculate interest for given period in Excel
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles