How to Automate Excel from Web Data – Any Tips or Tools to Get Started? Alternatively, if you prefer a more

For quick and dirty scraping, the Web Scraper Chrome extension works great.

It’s point-and-click, exports to CSV (which you can open in Excel), and totally free. Not for super complex sites, but perfect for simple tables.

Also, seconding Power Query—it’s the best for Excel integration.