Automated data scraping from websites into Excel
- Published on Nov 3, 2012
- Our Excel training videos on RU-clip cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
You can scrape, pull or get data from websites into Excel by performing a few simple steps.
1. record a macro to find out how one or many tables or data can be scraped from the website
2. Study the code carefully
3. Create an Excel sheet containing the links that get you the data from the appropriate web pages
4. Automate the process using a loop that creates
a) New worksheets
b) Automatically changes the link to the web pages that have the required data
You can view the complete Excel VBA code here:
Get the book Excel 2016 Power Programming with VBA: amzn.to/2kDP35V
If you are from India you can get this book here: amzn.to/2jzJGqU