Cerrado

wael kamal roshdy

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.

Habilidades: Entrada de datos, Procesamiento de datos, Excel, Extracción de datos web

Ver más: texas data entry, texas book company, data entry tools in excel, data entry florida, data scraping tools, texas book, scrape data from yellow pages, painting company, kansas, kamal, good contractors list, email harvesting, data harvest, want know cost data entry, yellow pages entry work, extract image website, excel extract phone list, Scraping Tools, reference book data entry, yellow pages export excel format

Información del empleador:
( 0 comentarios ) Egypt

Nº del proyecto: #7513117

11 freelancers están ofertando el promedio de $146 para este trabajo

DataHome

A proposal has not yet been provided

$147 USD en 3 días
(52 comentarios)
8.4
Kamalkishover

Hi WE have done similar project, We have expert team. Will provide you quality work as per your requirement. Ready to start immediately. Thanks

$147 USD en 3 días
(246 comentarios)
6.7
sid0

Hi sir, we have read your requirement and we are really interested in this project, can we discuss project on chat, we will wait for your response Please check our work [login to view URL] [login to view URL] Más

$136 USD en 3 días
(4 comentarios)
2.8
redouaneaberdin

hi sir, I am very interested in your project. I am proficient in Excel, Word, Power Point, data entry, web search, PDF, HTML, Java, ... I await your response. thank you in advance.

$250 USD en 30 días
(3 comentarios)
1.8
speedoking007

we are a group of software and electronics engineers and administrative work person. we have 10 resource persons now in our group all have more than 5 years of Experience in their fields. we all are working in a resear Más

$127 USD en 7 días
(1 comentario)
1.2
bhuveshgoyal

A proposal has not yet been provided

$155 USD en 3 días
(0 comentarios)
0.0
srini1887

A proposal has not yet been provided

$111 USD en 2 días
(0 comentarios)
0.0
rajansingh31

Hello sir I have sample ready for you i had scraped California rest will do after your reply I am newbie here but can do you work and will give you quality work Please help me start a new carrier here Hoping Más

$100 USD en 3 días
(0 comentarios)
0.0
dhariwal27

i understand the project and can complete it on time Hire me and i will complete it asap thanks......

$80 USD en 3 días
(0 comentarios)
0.0
Mosharefhussain

Dear Sir, I am the best candidate for this project. I can finish it within 2 days. If you give me this job you can trust me. I can give whole list for Painting Contractors in USA. please trust me. Regards, Más

$155 USD en 3 días
(0 comentarios)
0.0
ciyrus

Hi. Im currently scraping data for the project https://www.freelancer.com/jobs/Data-Processing/Hire-Virtual-Assistant-7550071/ So i can do this job also. i can find the details from [login to view URL] Sam Más

$200 USD en 3 días
(0 comentarios)
0.0