
Zillow Explorer
Pricing
$30.00/month + usage

Zillow Explorer
💫 Scrape Zillow.com Homes
0.0 (0)
Pricing
$30.00/month + usage
12
Total users
529
Monthly users
26
Runs succeeded
>99%
Issues response
8.5 hours
Last modified
4 hours ago
Last Sold date not Working
Closed
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?

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)
NoUturns
Excellent, thank you for getting back to me so quickly.

additional info
the formula also work on google sheet
on javascript/node the formula is :
new Date(TIMESTAMP)
👌cheers
NoUturns
Thank you Cat!