StatCrunch logo (home)

Sign in below

StatCrunch ID:
Password:
 
Forgot ID/password?
Support
 
Start analyzing data!
 
Learn more about StatCrunch
 
What StatCrunch can do!
 
For classes and bookstores
 
What folks have to say
 
Kudos for StatCrunch
 
The latest and greatest
 
Free mapping tool
 
StatCrunchThis

This bookmarklet allows you to pull data sets contained on many Web pages in various forms directly into StatCrunch for analysis.

1. Installation

To get started, save the link below to your bookmarks or favorites folder.

StatCrunchThis
  • In Chrome or Safari, grab the link above and drag it to your bookmarks bar.
  • In Internet Explorer, right-click the link above and choose the Add to Favorites option.
  • In Firefox, right-click the link above and choose the Bookmark This Link option.

2. Usage

When you find data tables on a Web page, choose the newly added StatCrunchThis option under the Favorites/Bookmarks menu of your browser, and the data tables will be loaded into StatCrunch. The StatCrunchThis bookmarklet injects javascript into the page which scours its contents for HTML tables, embedded Google spreadsheets and links to Excel/Text files. The bookmarklet then submits the contents of these items to StatCrunch for analysis.

To see how this works, consider the Google spreadsheet and the HTML table below, which both contain simple data listings. Both data sets will be loaded into StatCrunch if you click the StatCrunchThis link above or when you use the StatCrunchThis bookmarklet while viewing this page. 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.

Google Spreadsheet     HTML Table
   
xy
14
25
36

3. More Examples

Some examples of Web pages with data sets that play nicely with StatCrunchThis are listed below. Make sure you sign in to StatCrunch before using StatCrunchThis with the pages below.

  • 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 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.

  • Always Learning