Create a VBA app (macro) in Excel 2013 to scrape a manufacturer's website

I need a VBA app (macro) to read the SKU in the ProdInfo sheet and for each value, go to the manufacturer's website, find the product listing on their site and extract the product data. The data will include the following:

Product Description

Product Specifications

Product Image(s)

Weight (if available)

Size (if available)

Category or subcategory (if available)

Meta Keywords

To keep it simple, the drop down box needs to be populated with the Manufacturer's name to be chosen at run time. The data in the ProdInfo sheet will always have the SKU in the first column and there will always be a title in the first row.

The program will then loop through the values, open the webpage, search for the SKU and then extract the data into a new worksheet. All superfluous html will need to be removed saving only <p></p> for paragraphs and <ul></ul> for lists. No other formatting is to be saved.

I have updated the excel file with other examples of the data to be gathered. The SKUs will be cleaned by me before running executing the macro. Not every site may be able to be scraped. Review the URLs and determine which sites can be scraped and which cannot.

Skills: Excel, HTML, Software Architecture, Visual Basic

See more: iphone excel vba app, screen scrape excel vba, excel vba automate macro add ins, excel vba allocation macro, excel vba delay macro, excel vba solver macro, excel vba inventory macro, excel vba app, software write mq4, software write chip epson, useful software write book, excel web app macro, excel vba vlookup macro, software write web specs, writing excel vba permutation macro, excel vba rename macro, free software write user guide, software write edid, free software write company profile, software write websites idea

About the Employer:
( 8 reviews ) Maryland Heights, United States

Project ID: #13372175

Awarded to:


Hello This is Sourabh Gupta from New Delhi. I am advanced Excel VBA programmer and specialize in creating customized workbooks for businesses and people to meet all their needs efficiently and effectively. Cur More

$155 USD in 3 days
(41 Reviews)

21 freelancers are bidding on average $163 for this job


Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on and have been featured by the freelancer community ( More

$200 USD in 3 days
(562 Reviews)

Hi, I am good at Web scraping Excel and building useful scripts for my clients. Plz provide me the details of the site to be scrped and excel file. I just checked the description you have provided regarding the p More

$250 USD in 2 days
(655 Reviews)

Hi Sir/Madam. Ready to start. Thanks. Our slogan :  ** What we do, you can find elsewhere ** ** How we do it, makes all the difference **

$155 USD in 3 days
(455 Reviews)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

$155 USD in 3 days
(231 Reviews)

Hi I am Excel Expert and VBA Programmer I can write a scraping macro for you If interested, contact me Thanks & Regards

$222 USD in 2 days
(165 Reviews)

I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scri More

$200 USD in 3 days
(200 Reviews)

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$150 USD in 3 days
(235 Reviews)

Hi: Please share the details of the website. I can develop the scraper in Python or VBA for this task. I have developed several scripts for scrapping. Please note that I have ~100% completion rate and ~5-star feedback More

$150 USD in 4 days
(162 Reviews)

Hi, I have more than 14 years of web scarping using Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Please look at the fee More

$150 USD in 3 days
(158 Reviews)

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More

$155 USD in 3 days
(68 Reviews)

Hi I have a team of 7 members, expert in web scraping manual& automatic data collection & excel work. I understand the requirements of your project and I can assure you of completion with desired quality of work. I ha More

$70 USD in 1 day
(150 Reviews)

I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Built a hotel price comparison system that pulls data using the More

$150 USD in 3 days
(42 Reviews)

I have 7 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I More

$166 USD in 4 days
(57 Reviews)

Hello, I am working with Excel for a long time and I can create complex formulas and macros. I can complete the web scraper for you. If you are interested please open a chat with me. Kind regards, Sorin

$155 USD in 5 days
(34 Reviews)

Hello, sir! (First Bidder to offer this) I hope I will be awarded from you. ************I agree for any price you will set ** You can test me over chat before you award me! give it a try over chat before you awar More

$88 USD in 1 day
(18 Reviews)

Dear Sir/Madam, I am good in VBA/Macro in excel. I have done this type of projects in past. Regards, Mastor

$155 USD in 3 days
(10 Reviews)

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, 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, format More

$250 USD in 3 days
(25 Reviews)

Hi I can do it for you. Recently I did similar thing on MAC even. I am bidding that high as each of your sites will need separate automation to collect data. Your sites are AJAX based which needs automation via Browser More

$300 USD in 10 days
(10 Reviews)

We are team of VBA experts with 5 years of experience. Kindly share the details with us. Looking for your response

$30 USD in 1 day
(18 Reviews)

Hi there, I'm interested in the job and can help get it well done with good quality on time. Feel free to contact me and discuss more details. I'm looking forward to hearing from you soon. Best Regards, VL

$120 USD in 2 days
(11 Reviews)