
Zillow Explorer
Pricing
$30.00/month + usage

Zillow Explorer
💫 Scrape Zillow.com Homes
0.0 (0)
Pricing
$30.00/month + usage
11
Monthly users
22
Runs succeeded
98%
Last modified
6 months ago
Last Sold date not Working
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!
Pricing
Pricing model
RentalTo 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