Opportunity, at times, cloaks itself in annoyance. Some real estate agents like to grumble about Zillow and their clients’ propensity to take the Zestimate and other data points as gospel.

However, a website with the level of access and data-gathering power that Zillow has presents a real opportunity. One interesting thing that Zillow does is make its data fully accessible to any end user. The data are all downloadable and available to be used.

Zillow’s data download by city or metro area is a massive series of spreadsheets but provides the best chance at diving deep into their numbers. Below are some basic steps for working with the spreadsheets.

1. Isolate the data sets you need. For each report, you will probably be looking only at a few areas. You will likely be focusing on the area you work in — if you get a great influx of buyers from another city, perhaps that area, too — so you can compare and contrast housing values and make sure you’re comparing apples to apples.

2. Once you isolate the areas you need, also take a look at the time periods you need. You may only want to examine pivotal years that tell the story in your market, or you can put them all into a graph, which could be easier to analyze.

3. Now that you’ve got only the data you want to examine, look at each Zillow spreadsheet. Some relate to Zillow’s housing indices, while others deal directly with sold price and price per square foot.

Using the stats from every single spreadsheet is likely overkill and may overwhelm your end user. Focus on the data that relates to the story you want to tell. Are there time periods of dramatic rise or fall? Which data segments are most relevant to your market? Zillow breaks the data into condos, single-family homes and rentals, as well as dividing up data by housing price and size. Depending on where your market focus lies, you may want to exclude some of the data.

4. Now that you’ve got the data you want, it’s often a good idea to compare them to other data in the marketplace — such as data from your local MLS (multiple listing service) or numbers from other local, statewide and national real estate associations. The numbers often differ, but the trend patterns should be similar and should help you find the story you want to share with your clients. You can also incorporate local economic data to help craft an overall picture.

5. Conveying the data to your clients has two components: words and images. Putting the data in context makes it more than just a flurry of numbers; context makes those numbers relevant to the reader.

Combine your analysis of the data with simple graphics. You don’t have to be a graphic designer to make things visually interesting. You can use an inexpensive service to create simple graphics or create charts right in Excel.

These data can be shared in blog posts, newsletters, email, presentations and conversations. Your analysis can also serve as an introduction, inviting your client to request more information, such as a CMA (comparative market analysis).

Like the Zestimate, these data are not the ultimate authority, but they will hand you another tool to use in the ongoing quest to provide clients with the most comprehensive overview of their real estate world.

And for clients who may already be on Zillow, using data directly from their favorite real estate website may actually bolster their faith in your acumen!

Deidre Woollard was part of the marketing team at realtor.com and is currently the head of communications for Partners Trust, a leading luxury brokerage in Los Angeles.

Email Deidre Woollard.

Show Comments Hide Comments


Sign up for Inman’s Morning Headlines
What you need to know to start your day with all the latest industry developments
By submitting your email address, you agree to receive marketing emails from Inman.
Thank you for subscribing to Morning Headlines.
Back to top
Only 3 days left to register for Inman Connect Las Vegas before prices go up! Don't miss the premier event for real estate pros.Register Now ×
Limited Time Offer: Get 1 year of Inman Select for $199SUBSCRIBE×
Log in
If you created your account with Google or Facebook
Don't have an account?
Forgot your password?
No Problem

Simply enter the email address you used to create your account and click "Reset Password". You will receive additional instructions via email.

Forgot your username? If so please contact customer support at (510) 658-9252

Password Reset Confirmation

Password Reset Instructions have been sent to

Subscribe to The Weekender
Get the week's leading headlines delivered straight to your inbox.
Top headlines from around the real estate industry. Breaking news as it happens.
15 stories covering tech, special reports, video and opinion.
Unique features from hacker profiles to portal watch and video interviews.
Unique features from hacker profiles to portal watch and video interviews.
It looks like you’re already a Select Member!
To subscribe to exclusive newsletters, visit your email preferences in the account settings.
Up-to-the-minute news and interviews in your inbox, ticket discounts for Inman events and more
1-Step CheckoutPay with a credit card
By continuing, you agree to Inman’s Terms of Use and Privacy Policy.

You will be charged . Your subscription will automatically renew for on . For more details on our payment terms and how to cancel, click here.

Interested in a group subscription?
Finish setting up your subscription