In Progress

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, software write book images, software write books, login website via excel vba, software write protection, free software write book

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

Project ID: #13372175

Awarded to:

sourabhg98

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
(36 Reviews)
4.5

22 freelancers are bidding on average $194 for this job

jaylancer43

Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on [url removed, login to view] and have been featured by the freelancer community ([url removed, login to view] More

$200 USD in 3 days
(531 Reviews)
8.1
cgullapalli

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
(628 Reviews)
7.7
hwanghendra

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
(454 Reviews)
7.5
schoudhary1553

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
(214 Reviews)
7.2
cugamelover

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
(198 Reviews)
7.1
P0L

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
(213 Reviews)
6.8
aarifakhtar

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
(158 Reviews)
6.9
dpune

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)
6.5
sandroshubladze

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
(154 Reviews)
6.7
MohsanEijaz

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
(64 Reviews)
5.8
bytessolution

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
(141 Reviews)
5.9
archanaoswal

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
(39 Reviews)
5.3
furqanorpiv

Hi I am Furqan I've reviewed your complete job description, and I fulfill all the qualifications required for this project. I have 8+years experience working in VB macro, Software Development , I have completed More

$833 USD in 10 days
(32 Reviews)
5.8
prabakarm23

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)
5.0
sorinacho88

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
(33 Reviews)
4.8
MarkSalib1511

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
(14 Reviews)
4.4
huongth

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
(24 Reviews)
4.2
kchwistek

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)
4.1
mastor31

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
(7 Reviews)
3.7
Goalaholic

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)
3.8