Skip to content
Excel functionNot in Google Sheets

WEBSERVICE function in Google Sheets

Google Sheets doesn't have WEBSERVICE — here's what does.

Google Sheets fetches URLs with the IMPORT family — IMPORTDATA for plain text and CSV endpoints.

What WEBSERVICE does in Excel

Returns data from a web service.This function is not available in Excel for the web.

=WEBSERVICE(url)

Convert WEBSERVICE formulas to Google Sheets

Before and after, formula by formula.

  1. Fetch a plain-text endpoint:

    Excel
    =WEBSERVICE("https://api.example.com/rate.txt")
    Google Sheets
    =IMPORTDATA("https://api.example.com/rate.txt")

    IMPORTDATA parses CSV/TSV into cells; a single-value endpoint lands in one cell either way.

Worth knowing

  • For structured sources, Sheets goes further than Excel: IMPORTXML, IMPORTHTML, and IMPORTFEED.

Converting more than one formula? The Excel ↔ Sheets translator rewrites whole workbooks and flags every WEBSERVICE so none slip through silently.

Browse Excel web functions

More conversions to Google Sheets