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
Download the Excel file: www.dropbox.com/s/v1pd0vsk9af...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzbin.info...
#Excel #ExcelTips #ExcelTutorial #SumitBansal

[@andriikulishov3371]

Great video and explanations, thank you Sumit 👍👍

[@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!

[@WekomVideos]

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

[@trumpexcel]

Thank you... Glad you found the video helpful 🙂

[@sravankumar4860]

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

[@trumpexcel]

Ok.. Noted. Will add more PQ and M code videos in the future videos

[@user-fn4xy4hb3y]

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.

[@willianb.1720]

Awesome, keep doing that. good job.

[@mojo8598]

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)

[@cherianiype]

good stuff Sumit! Thanks for doing this!

[@neerajlohia1115]

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

[@karimallahwala7022]

Great Video thank very much

[@ebinmolloy7596]

Great stuff, thank you!

[@trumpexcel]

Thanks Ebin 🙂

[@Satwant2463]

Thank you so much 🙏🏼

[@required.]

wow ,excellent

[@ChetanSharma-kv5us]

Hi Sumit, Not getting table no.12. Only showing till table no.10. there is no option of suggested table in my wokring sheet

[@jitendrachaturvedi8308]

Good

[@user-nd6lj4my4g]

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.

[@trumpexcel]

Can you give me the URL you used and I will try on my system. I tried for one of the airports (Heathrow) and it was able to fetch 12 pages (120 reviews)

[@user-nd6lj4my4g]

I can see the comments on the web page as per your tutorial. Maybe it's to do with the excel version I use, mine is office 2019.

[@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. 🤔

[@trumpexcel]

Coz I want the change type step to be before I invoke the function. This way, when the function is used, it uses the number value input as text. If I invoke the function and then have the change type step, I would still get the error (coz of wrong data type)

[@benosborne413]

Hi, I have an Excel workbook with multiple worksheets. On worksheet One, I want to add buttons to click that will take me to the other worksheets. How can I do that? Thanks

[@trumpexcel]

You can do that using hyperlinks. Have a look at this - trumpexcel.com/hyperlinks/#Create-a-Hyperlink-to-a-Worksheet-in-the-Same-Workbook

[@benosborne413]

Thanks

[@benosborne413]

Thanks

[@rtrbs8383]

Thank you very much,...🤩 Very much Interested on M CODE and PQ........🤩 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.

[@trumpexcel]

You can do that by creating separate queries, as one query can only load to one table as far as I know. So you will need to have 5 different queries if you want to get the data from 5 different pages

[@wongpeggy4363]

Power query if I have some rows and column have space how?

[@trumpexcel]

Not sure I understand the issue... can you please explain a little more

[@wongpeggy4363]

@trumpexcel my aging report. There is some space how to combine

[@xeeshanahmad8757]

❤

[@manjunathkb9795]

Hey Sumit. I am getting only 10 pages, page 12 is not availbale in powerquery as you showed in the video...!!!

[@trumpexcel]

I just tried and it's giving me 120 reviews when I ask for 12 pages. One thing to check would be to make sure that there are 12 pages for the airport you have chosen

[@wongpeggy4363]

Sumit, I have problem here

[@wongpeggy4363]

Hi