How to pull data from a website into Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-pull-data-from-a-website-into-Excel.png)
In Excel, it is possible to link data from external sources such as other files, databases, applications, and websites. Instead of copying and pasting the data into an Excel sheet, a link can be created to the data source so that the data can be kept up-to-date. It is important to do this when the data in the source changes frequently.
Step 1 – Get the data
![](https://spreadcheaters.com/wp-content/uploads/Step-1-–-How-to-pull-data-from-a-website-into-Excel.png)
– Select the cell where the data is to be inserted
– Go to Data > Get & Transform Data
– Click From Web
Step 2 – Enter the URL
![](https://spreadcheaters.com/wp-content/uploads/Step-2-–-How-to-pull-data-from-a-website-into-Excel.png)
– Paste the URL of the website
– Click OK
Step 3 – Access Web content
![](https://spreadcheaters.com/wp-content/uploads/Step-3-–-How-to-pull-data-from-a-website-into-Excel.png)
– Select Anonymous as the mode to access the web
– Click Connect
Step 4 – Select the data
![](https://spreadcheaters.com/wp-content/uploads/Step-4-–-How-to-pull-data-from-a-website-into-Excel.png)
– Select the element of the website to be loaded
– Click Load
Step 5 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Step-5-–-How-to-pull-data-from-a-website-into-Excel.png)
– The data is loaded onto the sheet