If you need to extract data from a page or website there are two ways to go about it: you can do it manually or you can use a web scraping tool. There are a lot of good tools out there, some free and some premium, but if you know your way around Microsoft Excel, you don’t need any of them–and you don’t even need to know any code.
There are essentially two ways to use Excel as a scraper: the web queries method and the VBA method. Here is how you use Excel to scrape a website using each.
Excel Proficiency
Scraping web data is by no means the most sophisticated thing you can use Microsoft Excel for, but it does take some knowledge that would be considered “above basic.”
Having superior Excel skills is worth it for its own sake, but if you don’t consider yourself at least at the intermediate-level, consider investing in an Excel Bootcamp to give you the prerequisite knowledge you need to get started.
The Web Queries Method
This is the most straightforward of the two methods and the one that is most friendly and accessible for non-programmers. It involves two simple procedures in Excel but it gives you less customizability and there is still a large manual aspect to it.
Step 1: Creating the Web Queries
In order for Excel to interface with the website, you are trying to scrap ..
Support the originator by clicking the read the rest link below.
