Zillow Data by Address in Google Sheets: Value 25 Homes Fast
Turn a column of addresses into Zestimate, rent Zestimate, tax value, last sold price and agent phone for every home with =ZILLOWHOME(), then rank deals by rent against price. 9 scraping credits per home.
Phil Nguyen · 5 min read

=ZILLOWHOME() looks up a list of street addresses or Zillow home links and writes one row per property into Google Sheets, with the Zestimate, rent Zestimate, tax assessed value, last sold price, beds, baths and listing agent. You get every home on one sortable tab, so you can rank deals by rent against price instead of opening 25 Zillow pages one by one.
Picture an investor with 25 off-market addresses from a driving-for-dollars run. Looking each one up on Zillow and copying the Zestimate, rent estimate, tax value and beds and baths into a sheet takes about 4 minutes a home, so 25 homes is 100 minutes before any analysis. One formula does the lookups, and 25 homes cost 225 scraping credits (9 per home).
How do I look up Zillow data for a list of addresses?
ZILLOWHOME takes three arguments:
=ZILLOWHOME(urls, addresses, maxResults)
- urls: Zillow home-detail links, one per home.
- addresses: plain street addresses. Include the city and state, and the ZIP when you have it, so Zillow resolves the right property.
- maxResults: the most homes to return. The default is 10, so set it when your list is longer.
Put the addresses in A2:A26 and leave the first argument empty:
=ZILLOWHOME(, A2:A26, 25)
If you have Zillow links instead, put them in the first argument:
=ZILLOWHOME(B2:B26, , 25)
The cell shows ⏳ Scraping... straight away while the lookups run in the background.
What does each property row include?
The rows land on a new tab called Zillow Property Results. The first column, Source, holds the cell of the formula that fetched them. The main columns are:
Address, City, State, ZIP, Price, Status, Home Type, Beds, Baths, Living Area (sqft), Lot Size, Days On Zillow, Zestimate, Rent Zestimate, Tax Assessed Value, Last Sold Price, Agent, Brokerage.
Further along you also get Price per Sqft, Annual Tax, Tax Rate %, Garage Spaces, Schools, Agent Phone, Brokerage Phone, the ZPID, County, MLS ID and the Zillow URL. The listing Description is cut to 500 characters.
Here is the shape of the output, with made-up values for illustration:
| Address | City | Price | Status | Beds | Zestimate | Rent Zestimate | Tax Assessed Value |
|---|---|---|---|---|---|---|---|
| 12 Example St | Greenville | 245000 | FOR_SALE | 3 | 251000 | 1850 | 198000 |
| 48 Sample Ave | Greenville | 189000 | FOR_SALE | 2 | 184000 | 1500 | 160000 |
The Status column shows the home's actual status on Zillow, so read it rather than assuming every address is for sale.
What can you do with the property data?
- Rank rental yield and skip weak deals. Add a column that divides Rent Zestimate times 12 by Price (or by Zestimate for a home that is not listed) and sort it high to low. On 25 homes that turns 100 minutes of tab-hopping into one sort, and you spend your time on the top five instead of all 25.
- Spot listings priced well above the record. Put Price next to Tax Assessed Value and Zestimate. A home asking far more than both is one to question before you write an offer, not after.
- Call listing agents the same day. Agent and Agent Phone are columns, so the homes that pass your yield filter already have a name and a number next to them.
- Estimate carrying costs. Annual Tax gives you the tax line of a holding-cost estimate without opening a county site for each address.
How is this different from ZILLOWSEARCH?
ZILLOWSEARCH takes one Zillow search-results URL and returns the many listings that match it, which is the right tool when you want to find homes in an area. ZILLOWHOME is a lookup for homes you can already name: one URL or one address in, one full property row out. It cannot search a city or ZIP for listings. For the search side, see Zillow listings to Google Sheets.
What does it cost?
Each home costs 9 scraping credits. A 25-home list is 225 credits. For comparison, Solo includes 10,000 scraping credits a month, Growth 45,000 and Scale 115,000, and the Free plan comes with 100, enough to try about 11 homes. A run that finds no rows bills nothing. See web scraping in Google Sheets for how the other scrapers are priced.
What are the common pitfalls?
- Leaving out city and state. A bare street name can miss or match the wrong property. Write "17 Example Dr, Greenville, SC 29617", not "17 Example Dr".
- Forgetting maxResults. The default is 10 homes. Pass 25 for a 25-address list, or the run stops at 10.
- Looking for the results under the formula. Results go to the Zillow Property Results tab, not the cells below. With Keep Formula on, which is the default, the formula cell is kept as text so it does not re-run on its own.
- Pointing at a blank range. If every address and URL is empty, the cell shows #ERROR: empty input and no job runs.
- Multi-unit buildings. A building URL returns the building as one row, not a row per apartment.
Once the rows are in, the usual sheet tools take over. Data analysis in Google Sheets covers sorting, filtering and summarizing a table like this one.
Text and scraping formulas run on the free allowance. Install from the Google Workspace Marketplace, no card, no expiry.
Install free for Google SheetsAbout the author
Phil NguyenPhil builds SheetMagic, the Google Sheets add-on that brings AI and web scraping into the spreadsheet, used by 6,000+ people. He writes these guides from the formulas he runs on his own sheets.
