![Cartoon with a guy scraping a screen](https://daveberesford.co.uk/wp-content/uploads/2019/02/data-scraping-960x594.png)
Sounds revolting, but apparently it’s a jargon term for taking some data from a web page and putting it into an Excel spreadsheet.
In fact, that process is pretty easy.
1. Visit the web page of interest…
Start on a web page that contains some data that you want to import to Excel (maybe for analysis work, for example).
![Web page example - wikipedia page](https://daveberesford.co.uk/wp-content/uploads/2019/02/scrape1.png)
2. Copy the URL
Highlight the web address (Or URL, to use the proper jargon), right-click and choose Copy. (Press CTRL & C if you’re a keyboard bod).
![Copying the URL of a web page](https://daveberesford.co.uk/wp-content/uploads/2019/02/scrape2-960x310.png)
3. In Excel, select Data – From Web
![Selecting the Excel command Data - From Web](https://daveberesford.co.uk/wp-content/uploads/2019/02/scrape3.png)
4. Paste the URL
Use either CTRL & V to paste the URL you got earlier or right-click and choose “Paste“…
![Pasting a URL to the From Web window](https://daveberesford.co.uk/wp-content/uploads/2019/02/scrape4.png)
Then click OK.
5. Select the relevant table…
It will show any tables that are detected on that page. You need to click on the one you’re interested in…
![Highlight the data table you want to load](https://daveberesford.co.uk/wp-content/uploads/2019/02/scrape5.png)
Then click the Load button.
6. The table is loaded into Excel…
It shows as a Data Table and so has filters already enabled for to start analysing.
![Data Table created from a web page](https://daveberesford.co.uk/wp-content/uploads/2019/02/scrape6-960x735.png)
This short video shows you the full process…