Need an application to convert website searched data into Excel sheet
Closed - This job posting has been filled and work has been completed.
Target Website: http://www.propertyguru.com.sg
Retrieve phone numbers of agents listing properties in a specific area.
1) Click "Find Property -> Property for Rent"
2) Refine search: HDB Apartment, Near MRT Woodlands, Price $1,500 to $3,000, 3 Bedrooms, click "Search"
3) Desktop Application must then be able to pull the Agents' names, Contact number, Apartment Block number, and Street name, and place the info into an Excel sheet.
Desktop application should also allow output as either CSV format or Tab Delimited format (Text). Maybe something like a checkbox or a dropdown list to select.
End product: Organised Excel sheet with Agent names, contact number, Apt Block number, street name.
The output should be in this format as attached.
Column 'A' fixed value: 'Agents'
Column 'B': 'Handphone Number'
Column 'C': 'Agent's Name'
Column 'D': 'EMPTY'
Column 'E': 'EMPTY'
Column 'F': 'Block Number'
Column 'G': Street Name'
Keep in mind both Columns 'D' and 'E' are EMPTY. I need it in this format so I can use this for importing to another software.
Note: Some Agents have 2 phone numbers. It would be good if both can be saved into the excel sheet/Tab Delimited text file.