In Progress

Scraping Yellow Pages. Harvesting Yellow Pages to Excel

This work needs to be completed in a two step process to complete this project:

Step 1:

I need to scrape (harvest) Yellow Pages for the search term: "Painting Contractors" for every state in the U.S and export it to excel.

Here are examples of search results:

Texas: 7370 search results.

Missouri: 2104 search results

Kansas: 526 search results

Florida: 8461 search results

California: 11654 search results.

As you can see, these five (5) states have roughly 29,000 search results. I need to have this done for EVERY state. So there should be roughly 200,000-300,000 results.

Here are the fields I need:

Company name

Address

City

State

Phone Number

Company Fax: (if provided)

Website (if provided)

Email (if provided)

Step 2:

I need to format the excel sheet so that we can list the columns/rows by city and state. Example, if I want to pick only painters in Missouri, I should just have to click on state, and MO for the drop down. Then within MO, I should be able to pick a specific city. PLEASE SEE THE ATTACHED IMAGE as a reference.

NOTES: I know there are a lot of harvesting and scraping tools out there that will extract the data from Yellow Book with ease. However, I don't have the time right now to do it and I am not good enough in excel to to format it the way we need it.

Please bid on time it will take you, cost you require, and add a note whether you've have harvested or scraped before. I tried posting this project early last week but the person I was awarding the project only have 15,000 results which isn't nearly enough.

This project should have 200K - 300K results in excel that can be broken down by state and city.

Looking forward to awarding the project within 48 hours.

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

See more: export yellow pages excel, yellow pages excel, yellow pages export excel, yellow pages excel format, harvesting data excel, excel format yellow pages, extract yellow pages data, export results yellow pages, texas data entry, texas book company, data entry tools excel, data entry florida, export excel yellow pages, yellow, yellow pages, texas book, painting company, mo, kansas, image format excel, harvest, good contractors list, extract phone number, excel tools, email harvesting

About the Employer:
( 1 review ) St. Louis, United States

Project ID: #1286476

Awarded to:

NishantBamb

Hello, I am an expert data extractor. Please refer your Inbox for my experiences and more details. Thank you.

$150 USD in 5 days
(135 Reviews)
6.9

26 freelancers are bidding on average $147 for this job

greggfletcher

Hello, an expert at web scraping here. Regards.

$250 USD in 3 days
(60 Reviews)
6.4
inzaghi2006

I'm expert in scraping data projects and I've done scraping yellow page before

$250 USD in 7 days
(62 Reviews)
5.8
phpXpertbd

I can take care of this project. Please check my private message. Thanks

$150 USD in 7 days
(17 Reviews)
5.7
DataSOS

Hi, We have produced a sample for you. Please check PM for the same. - DataSOS

$250 USD in 10 days
(16 Reviews)
5.1
stacross

We'd like to bid on your "Scraping Yellow Pages. Harvesting Yellow Pages to Excel" project. Have a look at PM.

$90 USD in 0 days
(30 Reviews)
4.8
mjxone

Hi sir, I am interested in this project. Kindly check PM for further details. Thank you.

$200 USD in 3 days
(22 Reviews)
4.5
KGMNA

Dear sir, Fully understood all the requirements of the project. My sincerity and hard working will give u satisfaction. Please give me the task get it done with 100% accuracy. Please check private message for more info More

$250 USD in 2 days
(13 Reviews)
4.0
jkumarsanson

Please refer my inbox

$30 USD in 1 day
(11 Reviews)
3.5
ashashenoyg

Hi, Please check PM for details. Thanks, Asha

$120 USD in 30 days
(3 Reviews)
2.8
nhanng

Hi, Sir this job is "Scraping Yellow Pages" and export to Excel. please see PM and my attached file.

$80 USD in 4 days
(1 Review)
2.4
razchy

Dear sir, I am new free lancer & have a good typing speed data entry and excel expert and good hand on internet. Please consider me for this job. I will try my level best to provide you a quality work. The time I menti More

$200 USD in 7 days
(3 Reviews)
2.1
blackfox87

***Your search ends here*** I Am an Excel and research Expert with 3+ years Experienced professional in Research and data entry projects.Expect 100% quality in time.I will deliver 100% guaranteed result on what you ex More

$200 USD in 5 days
(1 Review)
1.0
avis009

count me in, i will do the work

$250 USD in 2 days
(1 Review)
1.0
xtianx76

ready to work. check attachment.

$30 USD in 5 days
(1 Review)
1.0
sonal2810

Hello Sir/Madam Please check your PMB. Thanks Dinesh

$30 USD in 2 days
(0 Reviews)
1.6
uzzal1605

Dear sir i am ready to do this work, Please send me in PM

$30 USD in 7 days
(0 Reviews)
0.0
Sagheerahmad075

I am excellent command on Microsoft Office specially excel as i have to use it frequently for my job tasks.

$200 USD in 5 days
(0 Reviews)
0.0
Tamal7

I committed that I should do this work accurately in time.

$200 USD in 7 days
(0 Reviews)
0.0
ralicmm

I'm expert in scraping data projects and I've done scraping yellow page before

$140 USD in 5 days
(0 Reviews)
0.0
ehsanali2326

Dear Sir, please check your PM. Regards, Thanks!

$30 USD in 10 days
(0 Reviews)
0.0