Scrape Multiple Web Pages Dynamically Into Excel With Power Query
I have a list of URLs that are the same each url has a number inside of it that creates a different result. I need to get the price from a website and put this next to each unique URL in excel. The excel document should have a (Column) with all the unique URLs and the next column next to it should have the price from the website for that unique url. I want to learn how to do this in excel as a (web query) or a (power query)
this video is similar to what i need to do
I will share youtube link with you soon
these are blog posts similar to what i need to do https://www.howtoexcel.org/power-query/how-to-extract-data-from-multiple-webpages/
I Already have all the links that i need to retrieve prices from! I just need to learn how to put all these links in one column and retrieve the prices for these unique links into the column next to it.
I need help learning how to set this up, I would like to share my screen with you and have help setting this up. I will need this done within the next few hours.
Please reply to this post if your interested in helping me set this up on excel.
Skills & Expertise RequiredMicrosoft Excel
Offer to work on this project closes in 189 days!Submit A Proposal
Share this project with your friends