Importing table-formatted data from web pages is a very handy feature of Microsoft Excel, and probably not very well known. To demonstrate the steps, I made two short videos covering both Windows and Mac versions of Microsoft Excel:
Microsoft Excel – Importing HTML tables
Microsoft Excel for Mac – Importing HTML tables
Note: If you want to see my original screencasts for this technique, see this blog post from 2006: Microsoft Excel Web Queries (Screencast). Side note: I can’t believe that was 7 years ago :)