Zillow Explorer avatar
Zillow Explorer

Pricing

$30.00/month + usage

Go to Store
Zillow Explorer

Zillow Explorer

jupri/zillow-scraper

Developed by

cat

Maintained by Community

💫 Scrape Zillow.com Homes

0.0 (0)

Pricing

$30.00/month + usage

11

Monthly users

22

Runs succeeded

98%

Last modified

6 months ago

NO

Last Sold date not Working

Closed
NoUturns opened this issue
a year ago

When downloading recent sales, the "LastSoldDate" comes back as a 13 digit number and Excel doesn't seem to know how to translate it back to a date.

Is it possible to get this to output a useable date? Or something Excel can convert?

Jupri avatar

cat (Jupri)

a year ago

Hello, sorry for the inconvenience, it is 13 digit UNIX timestamp (in microsecond)

in excel you can convert to DATE using formula : = ( TIMESTAMP / 1000 / 86400 ) + DATE(1970,1,1)

NO

NoUturns

a year ago

Excellent, thank you for getting back to me so quickly.

Jupri avatar

cat (Jupri)

a year ago

additional info

the formula also work on google sheet

on javascript/node the formula is : new Date(TIMESTAMP)

👌cheers

NO

NoUturns

a year ago

Thank you Cat!

Pricing

Pricing model

Rental 

To use this Actor, you have to pay a monthly rental fee to the developer. The rent is subtracted from your prepaid usage every month after the free trial period. You also pay for the Apify platform usage.

Free trial

7 days

Price

$30.00