IMPORTXML imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.

Sample Usage

IMPORTXML("https://en.wikipedia.org/wiki/Moon_landing", "//a/@href")

IMPORTXML(A2,B2)

Syntax

IMPORTXML(url, xpath_query)

  • 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.
  • xpath_query - The XPath query to run on the structured data.

    • See http://www.w3schools.com/xpath/ for more information on XPath.

Notes

See Also

IMPORTRANGE: Imports a range of cells from a specified spreadsheet.

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

IMPORTFEED: Imports a RSS or ATOM feed.

IMPORTDATA: Imports data at a given url in .csv (comma-separated value) or .tsv (tab-separated value) format.

Examples

Retrieves "Google Shopping" information from specified url.

 

Retrieves financial market information from "YAHOO Finance" url.

 

Retrieves "New York Times" front page information from the specified url.

 

Retrieves customer review information from "Wedding Plan" websites.