Scrape data from the web in Excel
Scraping data from websites is useful for research and analysis of all kinds. However, do you have to resort to special tools or coding?
The short answer is no. Excel offers a quick and convenient way of extracting content from the Web to dump in Excel.
In the video example, we scrape fixtures and results data for the forthcoming 2023/24 Premier League football season.
The process is as follows:
1️⃣ In a web browser, go to https://fixturedownload.com/results/e....
2️⃣ In Excel, on the Data tab, select From Web.
3️⃣ Copy the URL from Step 1 and paste it into the field.
4️⃣ Select OK.
5️⃣ Select Table 0 from the list.
6️⃣ Select Load.
The query loads the data from the website and plants it in the worksheet.
It doesn't matter if you edit anything or delete any of the table rows. A simple click of the Refresh button on the Query contextual tab dynamically updates the table to retrieve the latest data from the website.
This is also ideal, given the results and fixture dates will update throughout the season.
Try adapting the instructions for a website you want to scrape.
#exceleration #excel #microsoftexcel #excelformulas #exceltips #exceltricks #globalexcelsummit
---
The Global Excel Summit is the world's largest gathering of Microsoft Excel users and experts.
Learn more at https://globalexcelsummit.com/.
Find us on:
👔 LinkedIn: / global-excel-summit
🐤 Twitter: / excelsummit
🟦 Facebook: / globalexcelsummit
📸 Instagram: / globalexcelsummit
🤳 TikTok: / globalexcelsummit