For questions specifically about the Google Sheets function: ImportHTML()

Use this tag if your question is specifically about the ImportHTML() function in Google Sheets.

From the Google Support page for ImportHTML:


Imports data from a table or list within an HTML page.

Sample Usage




IMPORTHTML(url, query, index)

  • url - The URL of the page to examine, including protocol (e.g. http://).

    • The value for url must either be enclosed in quotation marks or be a reference to a cell containing the appropriate text.
  • query - Either "list" or "table" depending on what type of structure contains the desired data.

  • index - The index, starting at 1, which identifies which table or list as defined in the HTML source should be returned.

    • The indices for lists and tables are maintained separately, so there may be both a list and a table with index 1 if both types of elements exist on the HTML page.