The StatCrunchThis bookmarklet allows you to analyze data sets on any Web page. Simply save the link below to your bookmarks or favorites folder. On a Mac, grab the link and drag it to your bookmarks bar. On Windows and Linux, right-click the link and choose the Add to Favorites option. Note this only has to be done once.

StatCrunchThis

When you find a data table on a Web page, choose the StatCrunchThis option under Favorites/Bookmarks, and the data table will be loaded into StatCrunch. Some examples of Web pages with data sets are listed below. Make sure you sign in to StatCrunch before using StatCrunchThis. Otherwise, the data will be loaded without menus for analyzing it.

StatCrunchThis scours each Web page for Google spreadsheets and HTML tables. To see how StatCrunchThis works, consider the Google spreadsheet and the HTML table below, which both contain a simple data listing.

Google Spreadsheet		HTML Table
		x y 1 4 2 5 3 6

Both data sets will be loaded into StatCrunch if you click the StatCrunchThis link above or when you use the StatCrunchThis bookmarklet. The HTML format for the table looks like:

<TABLE BORDER=1 CELLPADDING=2 ALIGN=LEFT> <TR><TH>x</TH><TH>y</TH></TR> <TR><TD>1</TD><TD>4</TD></TR> <TR><TD>2</TD><TD>5</TD></TR> <TR><TD>3</TD><TD>6</TD></TR> </TABLE>

Include similar code or follow the simple instructions for publishing a Google spreadsheet, and browsers can use StatCrunchThis to analyze data on your Web page. When using StatCrunchThis at the Google Docs site, make sure you save your data before using StatCrunchThis since the data is read from the Google server and not from what is being displayed on the page. For this reason, it is a very good idea to turn on the auto save feature for Google spreadsheets when working with StatCrunchThis.

Do you have Web pages with data sets? Place the StatCrunchThis link shown below on your pages so that browsers can analyze the data even with out installing StatCrunchThis as a bookmarklet!

Here are a few more pages containing data sets to get you started:

Google spreadsheet example
This page contains the spreadsheet example shown above in its original form on the Google Docs site.

An embedded Google spreadsheet
This page contains an embedded Google spreadsheet that loads into StatCrunch perfectly.

List of teams with the most victories in NCAA Division I men's college basketball
This page contains one simple table that loads into StatCrunch perfectly.

NCAA passing leaders
This page has a table with a complicated header spanning several rows. The data loads nicely into StatCrunch with the headers appended to one another in a nice fashion. StatCrunchThis will order the resulting tables according to the number of entries.

Tax rates of Europe
This page contains one simple table with some entries that have a mix of text and numbers. Note that percentages like "25%" are read into StatCrunch as numbers, but percentages with trailing text like "5% Federal ..." are not.

Fast Food Restaurants & Nutrition Facts Compared
This page contains lots of tables and all of them are loaded into StatCrunch when you use the StatCrunchThis bookmarklet. The tables are sorted in terms of the number of elements in a descending fashion.

Beer Calories, Beer Alcohol, Beer Carb Content
This page contains one large table. Some of the rows in the table contain advertisements, but when analyzing the data only the first column will be impacted. These problematic cells can be deleted after the data is loaded into StatCrunch. Simply click in the cell and hit the Delete key (Command-Delete on a Mac).

Top 250 movies as voted by IMDB users
This page contains one simple table that loads into StatCrunch perfectly.

MLB hitting leaders
This page has a table with a complicated header spanning several rows. The data loads nicely into StatCrunch with the headers appended to one another in a nice fashion.

Fuel economy reports for the 2009 Toyota Prius
This page contains a simple table that loads perfectly into StatCrunch. The tricky part with this table is that it contains a number of empty cells and one row without any header information.

This program works pretty well for most web pages, but always double check the output to make sure it matches the original data. Be very careful with pages that contain tables with very complicated header information.