Post

Learn how to load CSV files from the web into #Excel using #PowerQuery. 🌐 In this new video, I show 2 ways to connect to a file hosted online: 🟩 Using the specific From Text/CSV connector, or 🟩 Using the more general From Web connector. Check it out here: www.youtube.com/watch?v=ISWz...

youtube.comLoading Files from Web into ExcelLearn how to load CSV files from the web into Excel using Power Query. In this video, Ken shows two ways to connect to a file hosted online: using the specific From Text/CSV connector, or using the…

0 reposts0 likes

This is technique useful when you want to connect directly to web-hosted CSV files instead of downloading them manually every time the data changes. Instead, it can be updated with a simple click on Refresh button! 💥