Closed

VBA Data Scraping - YellowPages, Google & Website

Hi, I need an Excel VBA guru to take the following columns as inputs and conduct web data scraping.

Inputs in Excel:

- Company Name

- Location (e.g. NSW)

VBA Process & Outputs in Excel:

Google Search:

1. Google Search the Company Name

2. Extract information from First Search result (Header, URL, Description)

3. Copy Each into a separate Column

Google Search + Website Scrape:

4. Google Seach 'Company Name' and "About Us"

5. Click on the first result

6. Copy website contents into one cell (potentially grab all <p> Elements)

Yellow Pages Search & Scrape:

7. Search [url removed, login to view] for Company Name & Location

8. Click on First Result

9. Copy (Company Name, Industry Categorisation, Phone Number, Email, Website URL, Physical Address, ABN, About Us) - Some may be missing which is ok to leave blank

10. Paste into separate Columns.

GUI & Code Readability:

Preferably to have all code appropriately commented on what it's doing

Prefer GUI buttons with Run, Pause, Stop.

Skills: Data Mining, Data Scraping, Excel, VBScript, Web Scraping

See more: Data Scraping of Sports Website - Basketball Data -- 2, face fun photoshop editing, data scraping import magento website, data scraping vba code, data scraping google keyword tool, fun photoshop photo editing, fun photoshop editing, fun photoshop, photo fun photoshop, web data scraping vba, google data scraping, website data scraping visual basic, vba data google finance, photoshop projects fun, photoshop fun website, google finance stock data scraping linux, fun projects photoshop, fun pet photoshop projects, design fun photoshop, photoshop template wigs fun, fun interactive banner photoshop, vba data scraping, data scraping website, photoshop fun photograph face, projects photoshop easy fun

About the Employer:
( 11 reviews ) Nundah, Australia

Project ID: #13198827

18 freelancers are bidding on average $116 for this job

mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can do VBA Data Scraping - YellowPages, Google & Website. I have always created a long-term More

$150 AUD in 10 days
(255 Reviews)
7.5
SBITServices

Hello , I have read your project description and understood your requirement. I have 5 years experience in Web scrapping and can complete task within time with 100% accuracy.I will develop a VBA code with GUI buttons a More

$150 AUD in 3 days
(278 Reviews)
7.2
phpXpertbd

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

$277 AUD in 10 days
(56 Reviews)
6.9
$100 AUD in 1 day
(277 Reviews)
6.9
bytessolution

A proposal has not yet been provided

$111 AUD in 2 days
(136 Reviews)
6.1
$50 AUD in 1 day
(133 Reviews)
6.0
sonarkaushik

I am very able to create this script to scrap data - also i have this data all ready to deliver

$99 AUD in 3 days
(61 Reviews)
5.9
Nidhijain123

Hello, I have my own software. I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think More

$88 AUD in 10 days
(70 Reviews)
5.6
usmanhassan123

A proposal has not yet been provided

$150 AUD in 1 day
(22 Reviews)
5.1
Ahmed818

Hello, i am expert in this kind of jobs i finished 10 scraping jobs in this year https://www.freelancer.com/projects/php/Getting-data-from-website-inserted/ https://www.freelancer.com/projects/Data-Entry/web More

$50 AUD in 2 days
(21 Reviews)
4.4
qasimalikgmail

Dear client, I have read the description and can build a scrapper with GUI using Excel VBA. I have previously done such projects and can showcase it to you. Looking forward

$133 AUD in 3 days
(8 Reviews)
3.8
fazila023

Data entry & Web Scraping expert here with fastest speed. PAYMENT AFTER YOU 100% SATISFIED WITH WORK. ready to start your work now and will work with your 100% satisfaction....................... 9 Year Experience i More

$100 AUD in 1 day
(4 Reviews)
3.0
repnikovss

PROFESSIONAL LEAD GENERATOR WITH PREMIUM LINKEDIN Hello. I have rich experience in web researching and data scraping. I'll give you only qualitative data I am keen on using a certain number of tools, like extension More

$166 AUD in 10 days
(6 Reviews)
3.5
$88 AUD in 10 days
(1 Review)
2.7
$88 AUD in 10 days
(1 Review)
1.6
akhileshgandhi

Hello, I have extensive scraping experience. I can complete your work and then you can pay. So that you have zero risks of losing money. Can we have more discussion?

$111 AUD in 1 day
(0 Reviews)
0.0
abhaymshr091

Respected Client , I have read the project description and is willing to work under your budget and on required time. Also , i have worked on project like these before it will be very easy for me to fulfill your ex More

$25 AUD in 10 days
(0 Reviews)
0.0
coolancer12

Hello! I want to work for your project. I'm very interested in your project. I want we discuss your project. I'll give you the best solution of the project for you in time. My giant experience will greatly help More

$150 AUD in 10 days
(0 Reviews)
0.0