How to pull data from a website into Excel

You can watch a video tutorial here.

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

– Select the cell where the data is to be inserted
– Go to Data > Get & Transform Data
– Click From Web

Step 2 – Enter the URL

– Paste the URL of the website
– Click OK

Step 3 – Access Web content

– Select Anonymous as the mode to access the web
– Click Connect

Step 4 – Select the data

– Select the element of the website to be loaded
– Click Load

Step 5 – Check the result

– The data is loaded onto the sheet