Step 2: Exploring the data in Google Spreadsheets

Scraper Wiki gives us the option to download our dataset, or explore it as an online Google Spreadsheet.

By opening up the document as a Google Spreadsheet we can:

  • Sort and filter the data;
  • Clean up any rows which contain errors;
  • Use the google chart features to perform basic visualisation of the data

Google Spreadsheets also provide an easy way to publish data on the web. If we had the original data in a structured format we could have uploaded it as a Google Spreadsheet straight away – removing the need to screen scrape data.

Using the sharing settings in Google Spreadsheets we can make our data available for others to access (read-only, or with permission to edit it) and we can publish it back onto a website.

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>