Zillow to google sheets. How to get data from Zillow to google sheets

Data from zillow.com can be referenced from Google sheets using some inbuilt functions that Google sheets provide. We will be using two functions for this.

  1. importxml()
  2. index

The importxml will import all elements which are matched in the xpath query. In the example below, we are asking google sheets to get the contents of elements with class value ‘zest-value’. Now this query alone will return two results. We need only the first one. That is why we use the index function and specify the “1” in the end. So the whole formula will look something like this.

=index(importxml(<insert the zillow link here>,“//*[@class=’zest-value’]”),1)

Here is an example.

=index(importxml(“http://www.zillow.com/homedetails/3817-Vista-Verde-Palm-Springs-CA-92262/63316638_zpid/”,“//*[@class=’zest-value’]”),1)

Youtube link showing copy of data from zillow to google sheets

Redfin to google sheets data copy

I tried to copy from Redfin to googlesheets using the same technique after making changes as per the sites source listing. But didn’t have much luck there. If you guys figure out how to do that, please share the same in the comments section.

Leave a Reply