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.See AlsoExtract data from smart chips in your Google SheetsImportXML, ImportHTML and ImportFEED in Google SheetsImport XML SEO Formula to Save Time & Increase EfficiencyHow to use Imports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds. Learn more in Google Sheets - Guide- For more information on XPath, see http://www.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.
Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.