We may be compensated for your purchase of any of the products featured on this page – it helps us keep the lights on :)
Excel tutorial on 2 ways to pull data from a website into Excel without copying it.
Both of the ways we’ll look at will create a connection with the web page you select. You can then choose to leave the connection active so you can refresh the data in the future or disconnect if you don’t plan to refresh the data.
Here are the 2 ways we’ll pull data from a website into Excel:
1. Import from Web Using Get External Data
We’ll first scrape all data from a webpage using the Get External Data option.
Get External Data allows you to scrape everything (except for images) from a webpage or section of a
2. Use Get & Transform / Power Query to Import Data from Website
We’ll then pull specific tables from the same web page by creating a query using Get & Transform (aka, Power Query) to pull the data.
Like the Get External Data option, Get & Transform creates a connection to the web page so you can refresh the data later, if you want. You can also disconnect if you won’t be needing the data again.
What makes Get & Transform stand out is that the data is imported in a Table format. This can make the data easier and more manageable to work with.
For both examples, we use the Wikipedia page for List of Busiest Airports by Passenger Traffic. Here is the website URL if you want to try this for yourself: https://en.wikipedia.org/wiki/List_of_busiest_airports_by_passenger_traffic