Parse HTML through Google Spreadsheet using scripting

Question

I'm trying to speed up the process of getting values from an HTML page to a Google Docs Spreadsheet through scripting.

I remember Microsoft Excel had the import data function, but I don't own a copy of that.

Is it possible to do this through Google Docs?

Answer 1

You might want something like the importXML or importHtml functions? These will let you import an HTML page and use XPath to process the content.

Answer 2

Take a look at google commandline tools. You should be able to interact with google docs from a script easily with that.

http://code.google.com/p/googlecl/