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.
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.
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 research organization and few number of person involve in data entry as their regular duty from research articles and test data of different testing performed also done proofreading for different articles before submission in our organization. furthermore, we also done most of this type of project in our country for several clients as freelancer. we hope you will assign this task to us. negotiation on bid amount is possible kindly message me to discuss.
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 for a response from your side
Thanks
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,
Mosharef