Scrape Data From Multiple Web Pages into Excel (with Power Query)

In today's video, I will show you how to use Power Query to connect to multiple pages in one go, get all the data into the Power Query editor, clean the data, and get it in Excel.

00:00 Intro
00:27 Scrape Data from One WebPage with Power Query
04:19 Changing URL to Get Data from New Page
05:38 Import Data from Multiple Web Pages using Power Query

#Excel #ExcelTips #ExcelTutorial #SumitBansal

[tomasarguelles]

More power query and M languaje please. Thx for your videos, you´re awesome

[sravankumar]

Yes we want more power query and M language videos. Thanks Sumit for all the videos ur doing.😊

[DimaSofiyuk]

Really useful video on using Power Query with multiple pages! It's great to see how to streamline data extraction into Excel. I also use Plerdy for free on my site to monitor user interactions, which helps enhance our data-driven decisions without needing complex setups. 👍 Excited to apply these tricks to our analytics tasks!

[andriikulishov]

Great video and explanations, thank you Sumit 👍👍

[WekomVideos]

This is brilliant, it's given me an idea how to speed up a task I do daily manually. Thank you so much!

[fnxyhby]

Thank you Sumit. Very interesting! Please do add more of such content using power query. For example how to login and extract account balances from multiple accounts from brokerages' web pages.

[Lohia]

Yes, would love if you can release videos on advance power query and M language❤

[mohdarhamqamar]

Make more videos on PQ and M code..it really helpful..and your way of explaining is 🔥

[kalikumarm]

Nice video!! 🎉thankx for valuable video

[cherianiype]

good stuff Sumit! Thanks for doing this!

[lamaosaily]

Great content 👍🏻 can you make tutorial on scraping aspx (all
text in one big page, but many drop down menues, no tables!) is this doable in excel power query??

[mojo]

Hi, this is great tutorials.

it would be better if you also add how to get the data until "end of page" e.g. page 103 (or whatever it is)

[andreastjahja]

Thank you, so clear..how if the table in the page is using a dropdown to control the data view (default is 10 data), i want to transport "all" view

[rezaahmadyieh]

Thanks, dear Sumit it was a very nice and informative video.
But there is something that I did not see anybody talk about in the comments.
No matter how many pages you are scraping, all the dates are getting collected wrong. I mean scraped dates are not identical with the relevant dates on the website itself. This issue can be seen in your video too
Please advise on this issue.

Thanks a gain

[alexbarbucristi]

Love your work!

Why do you delete the latest step just to update the Change Type step?

You can do that without that latest step being deleted.

I know you already know this. Just wondering why are you using that method. 🤔

[rtrbs]

Thank you very much, ...🤩 Very much Interested on M CODE and
One question - if I want to load these table page by page to excel instead of combining all together in one page, is there anyway we can achive that.

[ndljmyg]

Thanks Sumit, really useful. I tried this myself, for some reason it doesn't show the tables 12 and upwards, it only shows the tables up to 10 which doesn't have the comments. I use exactly the same URL as you were using.

[Lerxsty]

Sometimes hard to follow because you're terribly fast but very helpful. Thanks.

[eGFcodjumper]

How would you do this if the site I'm using has a dropdown menu that requires you to navigate to another report? I copied the link, but the only data that's displayed is the first page. The URLs don't change when navigating to the report I need.

[JagadeshRaoThalur]

how to do the whole text in the webpage into a cell, and whole text in the webpage of another url in the next cell?