I have been searching for a while for something to scrape data. I’ve wanted to scrape some football player data and cross-check it against other data. Well, after trying all sorts of php/mysql methods I found the most unbelievably simple way to do this. No programming necessary.
I’ll walk you through a really simple example:
Step one: Go to Google Docs — You need a Gmail account.
Step two: Open a spreadsheet
Step three: In one of the tables add the following:
I know its a lot. It is actually the top NFL passers taken from the NFL.com. See the page here.
The magic is in the =ImportHtml
You can find the Google Functions information about it here.
It’s an amazing tool to pull information from tables or lists.