Closed

look up data based on UPC and add data to Excel document

This project received 24 bids from talented freelancers with an average bid price of $72 USD.

Get free quotes for a project like this
Employer working
Project Budget
N/A
Total Bids
24
Project Description

I have an Excel document with about 1000 rows of data. Each cell in the second column (column B) contains a UPC number. I want a script or macro or something that will go through my Excel document, use each UPC # to search [url removed, login to view], and get 2 pieces of data from that there and add it in 2 new columns in the same Excel document.

For example, Column B, row 2, contains "634991151023". searching [url removed, login to view] brings up this page: [url removed, login to view]

from there the main price displayed is "Price: $6.78". I want that added as a new column, column C, in the Excel spreadsheet, e.g. column C row 2 should read "6.78". I also want another piece of information, the sales rank, added in a second new column. in this case it is "Amazon Best Sellers Rank: #168,028". "168028" should be added to column D row 2. the process would repeat with each cell in column B until all cells in column B have been checked.

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