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, locale)
-
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.
- The value for
-
xpath_query
- The XPath query to run on the structured data.- For more information on XPath, see http://w3schools.com/xml/xpath_intro.asp.
locale
- A language and region locale code to use when parsing the data. If unspecified, the document locale is used.
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.