Completed

xls web query data scraping solution

This project was successfully completed by Sudris for $120 USD in a day.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$30 - $250 USD
Completed In
1 day
Total Bids
15
Project Description

Need to scrape and save website table data that is constantly being updated online. Webpage is very simple (just table list with two txt columns) and requires no logins, contains no pics, no links, etc.

Target webpage is constantly updated and replaces old table date with new entries with each reload. We need to save and build a complete list of the posted website information (old data + updated data) on a ongoing basis.

A suggested approach may be using an xls web query (with refresh ~10min) to capture data into worksheet and then copy this with a Macro into a second sheet that stores and saves a list of the complete updated information while running. The idea is that each new refresh list of web query data automatically gets added and saved below the previous in the second xls worksheet.

Looking for a Freelancer who can provide this solution using xls concept above (or any other efficient method/program) to accomplish the objective. Have seen partial solutions and variations of this task online in excel forums, but we are not familiar enough with VBA to adapt the requirements for our purposes.
Thanks,

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online