Scrape Yellow Pages and websites for business details - GPs - output to Excel

This project was successfully completed by Joshua777 for $100 AUD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
$30 - $250 AUD
Completed In
3 days
Total Bids
Project Description

I am looking for someone to scrape results from Yellow Pages Australia ([url removed, login to view]) and cross reference the business listings with their websites to obtain additional details.

[url removed, login to view]
Business type or name: general practitioners
Street, Suburb or Postcode: Gold Coast, QLD
(Produces: 871 results for general practitioners in Gold Coast, QLD and/or nearby areas)

From each result obtained from Yellow Pages, find the Company's website and fill in the following fields in the attached Excel spreadsheet template.

Company Name> Business Name as listed on Yellow Pages
Company- Phone Number> Primary phone number as listed on Yellow Pages/Website
Company- Fax Number> Primary fax number as listed on Yellow Pages/Website

Company- Site Name: Postal Address
Company- Address - Line 1, Address - Line 2, Company- City, Company- State and Company- Country> The POSTAL ADDRESS/MAILING ADDRESS of the Company obtained from their Website

Company- Website URL> Company Website URL
Company- Annual Revenue> Leave Blank
Company- Number of employees> If the company lists their employees on their website, enter the total number of employees listed here
Company- SIC Code> Leave Blank
Company- Account> Leave Blank
Company- Note> Enter the number of Doctors
Company- Member ID> Leave Blank

Obtain the Practice Managers details from the Company Website. If the Practice Manager is not listed use the Managers details. If the Manager is not listed, use the Directors or Owners details. If the Director is not listed, use the Primary Doctors details.
Contact- First Name>
Contact- Last Name>
Contact- Job Title> The Job Title of the individual you listed
Contact- Direct Phone> If listed on website, otherwise leave blank
Contact- Direct Extension> If listed on website, otherwise leave blank
Contact- Email Address> If listed on website, otherwise whatever email is listed on the website, otherwise leave blank
Contact- Home Phone> Leave blank
Contact- Cell Phone> If mobile/cell phone is listed on website, otherwise leave blank

For all other fields leave blank

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