Import XML

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

How to use?

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.

PRACTICE SHEET

The below sheet is view only mode, please make a copy to practice.

Copy of ImportXML Function

Make A Copy

Page updated

Google Sites

Report abuse