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: https://www.dropbox.com/s/v1pd0vsk9af...
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-c...
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexc...
#Excel #ExcelTips #ExcelTutorial #SumitBansal
Watch video Scrape Data From Multiple Web Pages into Excel (with Power Query) online without registration, duration hours minute second in high quality. This video was added by user TrumpExcel 01 May 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 15,197 once and liked it 440 people.