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

Closed

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.

Skills: Data Processing, Excel, Web Scraping

See more: upc data excel spreadsheet, upc search excel, excel document search upc, upc data excel, www excel, use case amazon, no dp, i dp, go dp, dp number, dp best, best dp, all dp, a dp, rick g, sales excel, row b, price excel, Macro excel, macro e, macro + excel, excel $2-30, data searching, amazon rank, amazon excel

Project ID: #1416449

23 freelancers are bidding on average $73 for this job

NishantBamb

Hello, I am an expert data extractor. Please refer your Inbox for my experiences and more details. Thank you.

$100 USD in 2 days
(146 Reviews)
7.1
srinichal

Ready to deliver the script

$80 USD in 2 days
(29 Reviews)
6.1
ehsankayani

HI, Kindly see details in PMB. Thank you

$150 USD in 1 day
(34 Reviews)
5.9
inzaghi2006

Hi, I've done scraping data from Amazone before. I can finish your project quickly. Please contact me for the best service.thanks

$50 USD in 2 days
(58 Reviews)
5.8
mrbrave

Hi...Experience Amazon scrapper here...Pls see pmb for details..

$80 USD in 2 days
(73 Reviews)
5.3
DataSOS

Hello Sir, We provide excellent web scraping and data services and applications. Please check private message for our proposal. - DataSOS

$75 USD in 1 day
(16 Reviews)
5.1
DrTech76

Hi! Ready to start whenever you make the decision to move forward.

$30 USD in 1 day
(36 Reviews)
5.0
jyothi009

Please View PM

$45 USD in 1 day
(18 Reviews)
5.0
intellisense1

Respected sir, professional web scraping expert here. Please give me honor to work with you. Also check your inbox for sample data. Thanks

$100 USD in 2 days
(22 Reviews)
4.8
allhen

Ready to help you with this.

$45 USD in 1 day
(14 Reviews)
4.6
arnab0143

--Hello Sir, Amazon API expert. Code ready. Please check your pm. Thanks.--

$50 USD in 0 days
(6 Reviews)
4.4
diepbp

I am confident to handle your project. Please check your inbox for details, thank you.

$100 USD in 3 days
(10 Reviews)
4.2
microk

Expert here. Please check pm.

$42 USD in 1 day
(19 Reviews)
4.1
petrovp

I am ready to start working on this project

$30 USD in 3 days
(10 Reviews)
3.2
habayabah

Please read my PM for details of my bid.

$30 USD in 0 days
(3 Reviews)
3.2
viksadodev

This data can be extracted easily and i can show you how.

$80 USD in 1 day
(1 Review)
2.4
deepaknegi18

Hi, please checkout your PM for details about my service regarding this project. Thanks

$30 USD in 1 day
(1 Review)
1.0
Fazlulkarimchou

Dear sir Have a nice day, I am seriously want to get the task. Because I want to built career as a freelancer. I also offer the bid rate low too. Kindly inform me others terms and condition Thank you

$80 USD in 4 days
(0 Reviews)
0.0
senanijayasundar

I'll do in my best.

$30 USD in 2 days
(0 Reviews)
0.0
sheetalvaidya

hi please see pm

$200 USD in 2 days
(0 Reviews)
0.0