"Zestimate" Function in Excel VBA
I've implemented a simple function on VBA for Excel that will extract the Zestimate from Zillow's website. To use it, in any cell of the attached excel spreadsheet, one would enter: =Zestimate(address) See attached screenshot - cell C7 is being edited - to show the contents of the other Zestimate cells. Note: This implementation will fail if zillow changes its website structure. Ideally, one would use zillow's API at http://www.zillow.com/howto/api/APIOverview.htm. I can implement it using that if you have a zillow api ID.