Import an HTML table from a live website with Power Query

Описание

This is a quick demonstration of how you can use Excel's Power Query feature to import data from an HTML table of a live website and transform it into clean data. All without macros or VBA.

I made this video after I saw some discussion in a forum on how to use VBA to import an HTML table. While that is a viable approach, after I discovered Power Query's ability to to do it in a WYSIWYG interface, I want more people to see it in action.

Power Query uses the M language, which is what you see in the formula bar.

The Power Query editor is also available in Microsoft Power BI (free download).

If you're looking for another website to test with, try the IMDB Top 250 movie list
https://www.imdb.com/chart/top

Here's the discussion on the DaniWeb site in case you want a reference.
https://www.daniweb.com/programming/web-development/threads/506826/extract-data-from-html-table-using-vba