Thursday, December 4, 2014

Awesome commands for importing web data to Google Sheets

http://googlesystem.blogspot.com/2007/09/google-spreadsheets-lets-you-import.html

=importXML("URL","XPath expression")
=importXML("http://www.google.com/search?q=live", "//a[@class='l']/@href")



=importHtml(URL, element, index)
=importHTML("http://www.google.com/search?q=define:live", "list", 1)

=importData("URL")
=importData("http://www.nnums.com/api/get/cccccc.n") 


=GoogleReader(URL)  
 

No comments:

Post a Comment