Daily Archives: 2013-10-18

Screencast: Importing HTML Tables into Excel

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 :)