Originally Posted by
WendysRox
i use excel 2003 to scrape data from a few sites. Don't know how to do it in newer versions (because I like 2003 the best), but here's how I do it: Go to the "data" menu, then click "import external data", then choose "new web query". It will open a browser window with little yellow boxes next to every table. just click the box next to the table containing the data you want and click "ok" or "import". If you'll then save the spreadsheet, then the next time you open it all you have to do is "data" and "refresh data". I saved mine as "NBA Template" and "NCAAB Template". Every day, I'll open these templates, get the data, then save the updated sheet as "NBA 02-09-2011" or "NCAAB 02-09-2011" or whatever. Works great for me. Good luck!