Scrape Data From Multiple Web Pages into Excel (with Power Query)
15 هزار بار بازدید -
5 ماه پیش
-
In today's video, I will
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.
https://www.seevid.ir/fa/w/6coVzIt93vk Intro
https://www.seevid.ir/fa/w/6coVzIt93vk Scrape Data from One WebPage with Power Query
https://www.seevid.ir/fa/w/6coVzIt93vk Changing URL to Get Data from New Page
https://www.seevid.ir/fa/w/6coVzIt93vk Import Data from Multiple Web Pages using Power Query
Download the Excel file: https://www.dropbox.com/s/v1pd0vsk9aftq5k/Scrape%20Multiple%20Webpage%20Power%20Query%20-%20Example%20File.xlsx?dl=1
☕ 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-course
✅ 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:
#Excel #ExcelTips #ExcelTutorial #SumitBansal
5 ماه پیش
در تاریخ 1403/02/12 منتشر شده
است.
15,030
بـار بازدید شده