Webscraping and Excel

This project is only for Karthik S.

Webscraping and excel expert that can produce high quality results!

1. Scrape 4 different websites for Sku, Price, Sale Price, and Product-url´s.

From 5.000 - 20.000 products from each site.

2. Compare the SKU´s from all scraped sites against a Supplier DataFeed.

3. Remove the SKU´s (products) with no match in the Supplier DataFeed.

4. Create an excel file with 4 tabs/windows with SKU´s and Product-urls, from each scraped website where unmatched SKU´s is removed. Keep these files like this and move on to the next step.

5. For every similar scraped SKU from the 4 websites, keep the second highest "Price"

and the second lowest "Sale Price".

6. Reduce the Price with 1 and reduce the Sale Price with 1 for every SKU.

7. Update the Supplier DataFeed with the new Prices.

8. Update the Supplier DataFeed with the new Sale Prices, but NOT if it is lower than the RRP (the price that already exist in the file).

Skills: Data Entry, Data Mining, Data Processing, Excel, Web Scraping

See more: automated data scraping from websites into excel, scraping data from web into excel using vba, excel scraper, vba code examples for excel web scraping, how to pull data from a website into excel macro, how to extract data from website to excel automatically, excel scrape html add-in, extract data from website to excel vba, excel 2007 vba fuzzy match, excel 2007 cell remove password, excel spreadsheet automated data search create tables, league match create php, remove watermak create pdfsharp, excel macro find records match criteria, create tabs homepage, wordpress create tabs, remove login create account oscommerce, excel macro formatting cut paste across tabs, vtiger remove quick create, excel script active directory user create

About the Employer:
( 47 reviews ) GJØVIK, Norway

Project ID: #15461148

Awarded to:


Thank you for your invite. please award the project I ll accept the project morning

$125 USD in 10 days
(187 Reviews)

11 freelancers are bidding on average $172 for this job


If your developer not ready. I can provide a MUlti-threads desktop that fetches data from the 4 sites and do the comparison per your request. Final program can be delivered in less than 1 day.

$277 USD in 0 days
(67 Reviews)

Dear Sir, I'm very much delighted to let you know that i did data scraping with PHP-cURL, PhantomJS, Node.js, Selenium from many sites. I just scraped the data from web site and then wrote the data in mysql database More

$200 USD in 8 days
(54 Reviews)

Hello, I will scrap all product information from 4 different websites for Sku, Price, Sale Price, and product URLs etc. Please ask me the sample for your selected website. Thank you

$250 USD in 10 days
(194 Reviews)
$250 USD in 3 days
(117 Reviews)

!!! Dear Honor !!! We Can Help You Make That Happen !!!  Let's discuss............. ..............................

$200 USD in 2 days
(61 Reviews)

Hello, I read your requirements very-well and i will provide you best Webscraping and Excel according to your requirements. Thank you

$150 USD in 2 days
(32 Reviews)
$155 USD in 3 days
(22 Reviews)

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo More

$100 USD in 5 days
(13 Reviews)
$155 USD in 3 days
(3 Reviews)

i hope you are well so please message me and then i will try give 100% done...................................................................

$35 USD in 3 days
(4 Reviews)