Import Multiple Pages from Web with One Query in Excel

In this video, we import multiple pages of data from a website with one Excel query using Power Query.

We create a table of URL's that can automatically update on a sheet, import data from the web and then turn it into a function with some M code.

We then create a custom column to use this function and feed it the URLs from the table to import as many pages as we want.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[Xack]

Not only this is incredibly useful, but is also wonderfully explained. Thanks man!

[cruzinsweetsntreats]

This video tutorial is now about 16 months old, but it's going to help me in pulling in the needed data from my UberEats Deliveries. I realized I needed to automate the data to help maximize my taxes, and the Power Query as a function to bring in multiple pages is really what I need. So thank you very much. I look forward to getting it implemented, so that I can link the Excel files in MS Access for further data analysis.

[kurtl]

You, sir, ARE A LEGEND. Searched for ages to accomplish what this allows me and came up empty. When I landed on you, I was home free. Thank YOU!!!

[scaponyx]

I am also REALLY happy as it helped me with the following use case.
I have addresses I want to scrape off web. They are nicely in a table but there is hiearchy as such: umbrella company -> daugther companies -> branch addresses. I got url's from a sitemap and needed to load everything at once...and this helped me to do exactly that. Hopefully it helps someone else too!

[isparoz]

Become one of my top instructors and youtube channels with only one single video! thanks a million!

[ishthaish]

Searched for this all over . This has been the best example I've seen and very well explained. Thank you very much

[kennethvela]

This is gold man, thank you, I was able to fetch currencies from last 7 years from xe site and they love me now. I was also able to get data from steamships lines and so, thank you so much Manz God bless you

[nevermind]

I can't thank you enough, Computergaga! My work project just became a breeze.

[amarnadhgunakala]

you make my date on time when looking for immediate resolution.Thanks

[GoodlyRogue]

I'm overwhelmed by the incredible level of clarity this tutorial displays! Kudos

[ytlfv]

I can't thank you enough for this detailed video (step by step). Its 3 years old but still valid and valuable. God Bless you!

[DKthegameboy]

I never see videos with this many views that have 0 dislikes but after trying this solution, I understand why. Great video!

[ivzxejn]

Hello.
I had difficulty in self-study because there were not many Korean books that taught me about power query editing or parameters.
Thanks to your video, I have integrated multiple APIs into a single query.
I clicked Like and Subscribe.
Have a nice day!!

[bradleybeauclair]

This was my first fx table. Thank you so much. Please follow this video up with a 5min time intelligence table video if you want. I'm going to watch your other videos.

[JohannAltmann-hucx]

This Video is still the best when it comes to Excel Web Scraping! For me it was a breakthrough. Many thanks!

[paulbate]

Thank you very much, just spent hours trying to get this to work on other sites.

[couchpotato]

Awesome Video! Seriously Days of searching and then you explained everything I needed in 12 minutes!
To Fix "Expression.Error" - If you're pulling a lot of dates, or websites, and maybe some of them don't exist or don't exist yet you'll get this error and it'll mess up everything:
Solution: @9:20 in the video simply right click your FetchMovie equivalent column header and select Remove Errors.

[gcanelon]

Excellent video. I used it to download 150 tabs of info on the WSJ website with all public companies listed in USA and it worked like a charm. Thanks a lot.

[dongee]

Youtubers should look to this to see how to do it

[amimh]

Dude these steps still works until now and easy to understand. Thanks man!