Move over, Power Query! Dynamically scrape all tables from a webpage directly in Excel! 🐍
I love Power Query. It's so powerful. And queryful. Is that a word? It is now.
But now Python in Excel is with us, we have a lot more options.
In this video I show you how to create a dynamic table-viewer directly in the spreadsheet.
[00:00] - Introduction
[00:37] - Web scraping in Power Query
[01:47] - Use PQ to grab the HTML
[02:41] - Using BeautifulSoup to parse the HTML
[07:08] - Setting up the drop-down list
[08:23] - Dynamic table-viewer!
#data #analytics #excel #python #pythoninexcel