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




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, export yellow pages results excel, scrape yellow pages, scrape data yellow pages, yellow pages excel format, scrape yellow pages example, cost scraping yellow pages data, export list yellow pages excel, export excel list yellow pages, harvesting data excel, excel format yellow pages, extract yellow pages data, scraping yellow pages, can data yellow pages export excel, export results yellow pages, extract data yellow pages excel, extract yellow pages data excel, export yellow pages search results excel, texas data entry, texas book company, data scraping company, data entry tools in excel, data entry florida

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

Project ID: #1286476

Awarded to:


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)

26 freelancers are bidding on average $147 for this job


Hello, an expert at web scraping here. Regards.

$250 USD in 3 days
(60 Reviews)

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

$250 USD in 7 days
(62 Reviews)

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

$150 USD in 7 days
(17 Reviews)

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

$250 USD in 10 days
(16 Reviews)

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)

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

$200 USD in 3 days
(22 Reviews)

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)

Please refer my inbox

$30 USD in 1 day
(11 Reviews)

Hi, Please check PM for details. Thanks, Asha

$120 USD in 30 days
(3 Reviews)

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)

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)

***Your search ends here*** I Am an Excel and research Expert with 3+ years Experienced professional in Research and data entry [url removed, login to view] 100% quality in time.I will deliver 100% guaranteed result on what you ex More

$200 USD in 5 days
(1 Review)

count me in, i will do the work

$250 USD in 2 days
(1 Review)

ready to work. check attachment.

$30 USD in 5 days
(1 Review)

Hello Sir/Madam Please check your PMB. Thanks Dinesh

$30 USD in 2 days
(0 Reviews)

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

$30 USD in 7 days
(0 Reviews)

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)

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

$200 USD in 7 days
(0 Reviews)

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

$140 USD in 5 days
(0 Reviews)

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

$30 USD in 10 days
(0 Reviews)