Getting your data into Excel can be a chore, but Dr. Kevin Kelly, shows how to “scrape the web” to pull data in from URLs, transform and load it via Power Query to create a table ready for use.
You can follow his methodology to pull in data from many external sources, including PDFs, databases and SaaS platforms.