IMPORTXMLImports data from any of various structured data types including XML, HTML, CSV, TSV, and RSS and ATOM XML feeds.
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.
For more information on XPath, see http://www.w3schools.com/xml/xpath_intro.asp.
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.