Fill in an Excel spreadsheet with data captured from a website -- 2
$10-30 USD
Paid on delivery
This is a programming job. Manual input of data is not allowed. It is a plus if you can get the data back to me in the next couple of days.
An Excel spreadsheet contains a list of thousands of products sold by Amazon. The link to each product page on Amazon is provided. A product code is also provided (please keep it, I will use it as a key). There are two steps in this project: (1) to collect data directly from the Amazon webpage itself and (2) [EXTRA STEP] jump to CamelCamelCamel to collect additional data from the same product.
Step 1: Data from Amazon [REQUIRED]
==============================
For each product on the spreadsheet, you will get, from its Amazon webpage:
1) Product Name
2) Price
3) Date first available on Amazon
4) ASIN
5) Item Model Number
6) Average Customer Rating (I prefer you provide the percentage. For instance, if it is 4.0 out of 5, then you will provide .80)
7) Number of Customer Reviews
In addition, each product has at least one ranking at a specific category. I am asking you to collect the ranking (it is a number) and the category (it should be a text). However, some products have rankings at multiple categories. When there are multiple rankings, I am asking you to provide at most three rankings with their associated categories.
Step 2: Data from CamelCamelCamel [DESIRED BUT NOT REQUIRED - THIS IS A PLUS]
==============================
For each product on the spreadsheet, you will plug in its respective webpage (also provided on the spreadsheet) on the search bar at CamelCamelCamel.com. CamelCamelCamel will return 12 historic prices for each product: current, highest, lowest, and average at (1) Amazon, (2) in mint condition at a third-party seller, and (3) in used condition at a third-party seller. In some cases, some prices (usually the prices for used products at a third-party seller) may not be provided.
Your job at the second step is to get the 12 historic prices for each product at CamelCamelCamel and input those values back into the provided Excel spreadsheet. When prices are not available at CamelCamelCamel, you will return NULL values.
I am providing a sample spreadsheet with a few dozen products, so that you can practice and show me your work for me to evaluate. The actual spreadsheet contains over 40.000 thousand products.
Project ID: #9052422
About the project
Awarded to:
29 freelancers are bidding on average $45 for this job
Hello, I am ready to extract data from amazon to excel. I'm using python/scrapy/django for amazon extraction. I writes scripts for data scraping including file downloading if requires (images,pdf etc.) and database More
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
Dear Sir/Ma'am, I am a Web research and Data Entry expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from differen More
Hello. I am Proficient in web scraping, data mining and web research having experience of more then 5 years. I am very interested to do your task. lets discuss further. Looking forward to hear from you. Thanks
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
Hello there Sir, I am an expert in excel programming. And I would like to see what I can do about your requirement. Let us talk further Waiting ......
Sir, I reviewed your job description and am very interested to work with you. I can complete with fast and accurately. Please consider my bid. Thanks........Shariful
Dear sir, I have good experience in data entry, excel, spreadsheet, data processing, data gathering, web research, web search, info collection, eCommerce site, copy typing, Google documents and many more. I have more More
Hi, Please give me a chance to make your work done in time accordingly as desired. Besides this my expertise in MS Office, Presentations, Data Entries, Designing, PDF document, Google Spreadsheet, VBA, Macros and Typi More
how many data should be extracted ? and can you please tell me the specification , looking forward to hear regards asgor
I am interested for this task. I can do this work. Please give me chance for do this task. I am waiting for your reply . Thank you.
Dear Sir, I am an expert in in Fill in an Excel spreadsheet with data captured from a website. I have great skill in this job. I will do my best for you project. Thank you
Very good with Microsoft office products especially Excel calculation and formulas and preparing presentations with high quality. Hard working and dedicated to do the job with high quality and to deliver on time. G More
just completed similar job just now. just give me 5 hour i'll make it done. so you can have faith on me can provide you demo right now.