Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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.

share|improve this answer

If you're trying to grab data that's stored in a list or table, you should use =ImportHTML(URL,Type,Index).

Where Type is "List" or "Table" and index is which # table/list you want to import.

Documentation: https://support.google.com/docs/answer/3093339

share|improve this answer

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/

share|improve this answer
    
The referred code project is broken according to a announcement on the code project homepage. – Rubén Jun 12 at 2:51

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.