Web Scraping With Google Docs

This past February, at the NICAR Conference in St. Louis, I presented a session on web scraping using Google Docs with my most excellent friend (Bill & Ted’s Excellent Adventure Reference!), Acton Gorton.

Since then, he’s put up a tip sheet and wrote a blog post on the topic:

Here is Acton’s much more articulate explanation of the demonstration:


Google Docs is a suite of easy and powerful applications for the office, and this tip sheet will explain how to import data from sources on the Internet into a spreadsheet.

While Google Docs cannot currently compete with more powerful scripting languages such as Python or Rails, users of all skill levels are attracted to the service for its ease with creating and launching full featured applications.

  • Beginning data workers will find plenty of tutorials within the documentation for adding basic functionality to their spreadsheets and mashing data up in new ways.
  • Experienced users of spreadsheet software such as Microsoft Excel will appreciate the fluid crossover of services and the familiar workings of various spreadsheet functions.
  • Advanced users versed in programming or scripting languages can harness the most powerful features of Google Docs and Apps Scripts for RESTful interaction with websites and creating rapid prototypes of software applications.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s