Web Scraping a Table of Stanley Cup Champions Using VBA

Have you ever needed data you found online, but when you tried to copy it into Excel it was formatted so poorly it was of no use? Well with the use of VBA we can extract that data straight from the website’s HTML into our Excel Workbook.

For this exercise we will be extracting the Stanley Cup Champions table from Wikipedia, however the same basic procedure can be followed to extract any data from a website.

Step 1: Determine the HTML Code to be Scraped