Excel Power Query

Budget

$36.00HOURLY

Client

Ross Wells Estonia

Status

OpenJan 31, 2019
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 Required

Microsoft Excel 

Offer to work on this project closes in 189 days!

Submit A Proposal

Share this project with your friends



Freelancers You May Hire


Here are our top professional picks for you to hire



Similar Projects

Data Visualization - Tableau Pro ne...

Responsibilities:

We're looking for a Tableau expert to redesign a series of marketing reports. We would provide you with the existing workbooks and data source extract to work with.
read more

Hourly, $28.00

Sales Analysis of an Ecommerce busi...

Sales analysis data from QB data
1) Churn rate
2) Customer acquisition cost
3) Sales / % increase MOM (Month on Month) + Graph
4) Average basket size
5) Transactions / % increase...read more

Hourly, $36.00

MS office and communication configu...

Someone who can work patiently with a skilled individual consultant working from home

Hourly, $16.00

Business analyst needed to create a...

TASK:
Provide a company overview for AbbVie covering the following information:
- Introduction and short synopsis of company: background, reasons for success, public perception (1 slide)
-...read more

Fixed, $40.00

Financial analytics on hostel perfo...

This is an ongoing role for a data analyst to provide reports on a monthly basis that will help us determine and track financial KPIs for our team of 3 hostels and various other events and projects ru...read more

Hourly, $18.00