Get data from the web into Excel using the new web connector.
This new feature of Excel utilise AI to interpret structures on a web page. In this video, we see two examples of importing unstructured data.
The data on the web page is not in a table, but Excel offers suggested table structures for us to import from. And if that is not enough, a web from examples option to tell Excel what we need.
Web from Examples is Amazing!
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
📺 Related Videos
Import multiple pages from the web in Excel -
https://youtu.be/STjBoS1rQuQ
Import multiple Excel files -
https://youtu.be/7Gy6Y5ghiNc
🔗 URLs used in the video
IMDB Top 250 - https://www.imdb.com/chart/top/?ref_=nv_mv_250
Social Blade top 100 YouTubers - https://socialblade.com/youtube/top/100/mostsubscribed
Find more great free tutorials at;
https://www.computergaga.com
🔗 Connect with me!
LinkedIn ► https://www.linkedin.com/company/18737946/
Instagram ► https://www.instagram.com/computergaga1/
Twitter ► http://www.twitter.com/computergaga1
#excel #powerquery #exceltutorial