Closed

Scraping Yellow Pages. Harvesting Yellow Pages to Excel

This project was awarded to NishantBamb for $150 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
N/A
Total Bids
26
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online