Develop an automated Excel VBA macro to Import zillow values using their API and using website scraping. Convert the ZillowID data of thousands of homes or buildings to Excel and CVS files using a scraping macro to pull the data.
The resulted product will allow me to have a space for a plug-in where I can type-in or paste a URL of the Zillow search that I did and the product that you're going to develop will output a spreadsheet in Excel and CVS formats of the Zillow search result.
A particular example of my search is the following:
Assume for example the following Zillow
[url removed, login to view],mobile,townhouse_type/1-_beds/1-_baths/500000-_price/1863-_mp/36m_days/Pool,-Waterfall_att/globalrelevanceex_sort/34.704364,-116.868439,33.565428,-119.557343_rect/8_zm/
to be converted and display to CVS and Excel files.