Pulling data from an external website to an Excel spread sheet can be easy with Excel Web Queries. Web Queries fetches html tables from the web page that you specify and lets you select the ones containing data you want to put into your worksheet.
Web scraping without writing c0de that is!!
More Illustrations Here