Skip to content
×
PRO
Pro Members Get Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. Cancel anytime
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Real Estate Technology
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated over 1 year ago, 06/20/2023

User Stats

6
Posts
2
Votes
Brendan Carroll
  • Ottawa, ON
2
Votes |
6
Posts

Anyone making use of the Zillow API with Excel?

Brendan Carroll
  • Ottawa, ON
Posted

First post!

I really hope I haven't missed a discussion on this, I've tried doing a search on it here, and it mostly leads to discussions about how inaccurate Zillow is. :) Be that as it may, I am interested in using Zillow Zestimates, "Last Sold" values, and the most recent property tax assessment values, in a property analysis spreadsheet I am trying to put together.

Input: Homepath bulk .csv file
Output: Same file with the above Zillow information added.

I have come across a site that does this automatically, but the rates seem steep for what you get out of it. zim.ca. "Zestimates In Minutes".

I see a number of similar projects have been posted on freelancer.com, so I may just contact someone there to whip something up for me.

Looking forward to taking part in the BP community.

User Stats

21
Posts
10
Votes
David M.
  • Investor
  • Ravensdale, WA
10
Votes |
21
Posts
David M.
  • Investor
  • Ravensdale, WA
Replied

Here is a link to a similar project: http://johnmann.me/excel-zillow-api-extraction/

I am looking for a similar tool. Interested to see what others have come up with.

User Stats

2
Posts
0
Votes
Scott Purser
  • Barnesville, GA
0
Votes |
2
Posts
Scott Purser
  • Barnesville, GA
Replied

Is there still any interest in this? I think it would be very useful to programmatically sort through listings based on whether they hit financial targets like CoC or cap rate. If there aren't any tools already available, I was thinking about making one.

NREIG  logo
NREIG
|
Sponsored
Customizable insurance coverage with a program that’s easy to use Add, edit, and remove properties from your account any time with no minimum-earned premiums.
Account Closed
  • Investor
  • Memphis, TN
68
Votes |
105
Posts
Account Closed
  • Investor
  • Memphis, TN
Replied

Y'all, google spreadsheets can do this.  

User Stats

1,033
Posts
783
Votes
James Mc Ree
  • Rental Property Investor
  • Malvern, PA
783
Votes |
1,033
Posts
James Mc Ree
  • Rental Property Investor
  • Malvern, PA
Replied

I tinkered with the API after getting my ZWS ID and am getting an error in Excel.  Any ideas on this?

A URL I am using to call the API is below (need to put in your ZWS-ID).  This works fine when called from a browser.

http://www.zillow.com/webservice/GetUpdatedPropertyDetails.htm?zws-id=<ZWS-ID>&zpid=48749425

The URL above is the value of cell A1 in Excel.  I enter into cell B1:

=webservice(A1)

which should invoke the URL which returns XML and put the return value into B1.  Instead, I get a "#VALUE!" error and haven't found any clues as to what I am doing wrong in this very basic example.  Any ideas?

User Stats

8
Posts
3
Votes
Carl Scott
  • Williamsburg, VA
3
Votes |
8
Posts
Carl Scott
  • Williamsburg, VA
Replied

Interesting thread here, any traction on any of this yet?

I built a tool that I use personally for doing quick location analysis/property estimations which I'd be happy to share, though it's pretty catered to my own needs right now!

User Stats

1,033
Posts
783
Votes
James Mc Ree
  • Rental Property Investor
  • Malvern, PA
783
Votes |
1,033
Posts
James Mc Ree
  • Rental Property Investor
  • Malvern, PA
Replied

I was able to get the APIs working from home, but not at the office.  They don't work if there is a proxy server involved if you are calling from Excel.

Ultimately, I gave up.  Two of the critical pieces of data I wanted were current price and listing status.  They seem to be unavailable due to legal restriction according to the message I was getting back.  I was able to get the basic property data.  I don't know if they have a fee on the API for current price and listing status - I didn't look.

I gave up for a 2nd reason: some of the data was coming back wrong.  I would look at a Zillow page and it would show the house was built in 1920.  The API data came back as 1950.  I noticed a few other differences and guessed the API is very buggy or has a different data source than the Zillow pages.  That shook my confidence - no point in using the service if I have to manually verify and edit the data.

User Stats

8
Posts
3
Votes
Carl Scott
  • Williamsburg, VA
3
Votes |
8
Posts
Carl Scott
  • Williamsburg, VA
Replied

Thanks for the follow-up.

Wow, well at least you were able to catch it. And I would imagine you would need MLS to get at a reliable listing status/price? Surprised the housing details were off, though; that's unfortunate.

User Stats

2
Posts
0
Votes
Scott Purser
  • Barnesville, GA
0
Votes |
2
Posts
Scott Purser
  • Barnesville, GA
Replied

If anyone is still interested, there's a chrome extension called RE-Helper that pulls data from a listing and runs it through a calculator. Just works on zillow now. 

https://chrome.google.com/webstore/detail/re-helper/bbdlndhhhkfafaeofaecinfhcpafbnpe?hl=en

User Stats

1,033
Posts
783
Votes
James Mc Ree
  • Rental Property Investor
  • Malvern, PA
783
Votes |
1,033
Posts
James Mc Ree
  • Rental Property Investor
  • Malvern, PA
Replied

@Scott Purser It looks like the link is not working.

The webpage at https://chrome.google.com/webstore/detail/re-helper/bbdlndhhhkfafaeofaecinfhcpafbnpe?hl=en might be temporarily down or it may have moved permanently to a new web address.

ERR_TUNNEL_CONNECTION_FAILED

User Stats

8
Posts
2
Votes
Jim Frye
  • Detroit, MI
2
Votes |
8
Posts
Jim Frye
  • Detroit, MI
Replied

Check out https://www.homey-llc.com/

Made this after researching/purchasing rental properties in Nashville. 

It’s basically a tool that works with the Zillow api for price/rent and analyzes a property based on (1) location-specific metrics (appreciation rate, tax rate, insurance) and (2) customary expenses (vacancy, prop mgmt, r&m, capex). Also, all the drivers are adjustable within a downloadable google sheet. 

Can also download to excel if you want to tinker with it offline. 

Let me know what you guys think; would love any feedback from this group!

User Stats

48
Posts
13
Votes
Dana Walker
  • Orlando, FL
13
Votes |
48
Posts
Dana Walker
  • Orlando, FL
Replied

I am a big fan of excel, and use extensive macros and add-ons. You may just want to hire a coder to write a macro in VBA. I have never used Zillow, but it seems like a pretty solid tool.

Account Closed
0
Votes |
3
Posts
Account Closed
Replied

Hi Brendan Carroll,

My name is Edidson, I am new to BiggerPockets. I recently saw an old post by you (a copy of your post at the bottom).

That post catches my attention because I have been looking for a similar tool for my researches.

Question: have you find something like what you asked in your post?

Thanks

“First post!

I really hope I haven't missed a discussion on this, I've tried doing a search on it here, and it mostly leads to discussions about how inaccurate Zillow is. :) Be that as it may, I am interested in using Zillow Zestimates, "Last Sold" values, and the most recent property tax assessment values, in a property analysis spreadsheet I am trying to put together.

Input: Homepath bulk .csv file
Output: Same file with the above Zillow information added.

I have come across a site that does this automatically, but the rates seem steep for what you get out of it. zim.ca. "Zestimates In Minutes".

I see a number of similar projects have been posted on freelancer.com, so I may just contact someone there to whip something up for me.

Looking forward to taking part in the BP community.”

Rent To Retirement logo
Rent To Retirement
|
Sponsored
Turnkey Rentals 12+ States. SFR, MF & New Builds, High ROI! 3.99% rates, 5% down loans, below market prices across the US! Txt REI to 33777

User Stats

9
Posts
2
Votes
Kevin Keck
  • New to Real Estate
  • Anderson, SC
2
Votes |
9
Posts
Kevin Keck
  • New to Real Estate
  • Anderson, SC
Replied

I hate to bust you guys bubble but I just finishing a python program that pulls data from the zillow api...I was getting on here to find out if there are better options because it's not really all that great of info. The differences in numbers between zillow and other sites are scary...

User Stats

7
Posts
1
Votes
Replied

There are many chrome extensions that do this. I've been using this one since it's one of the cheaper ones and gets the job done.