Excel Power Query

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.
About the recuiter
Member since Mar 14, 2020
Jianguo Chang
from Razavi Khorasan, Iran

---

---

Offer to work on this project closes in 81 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions