Zillow Explorer avatar

Zillow Explorer

Try for free

7 days trial then $30.00/month - No credit card required now

Go to Store
Zillow Explorer

Zillow Explorer

jupri/zillow-scraper
Try for free

7 days trial then $30.00/month - No credit card required now

💫 Scrape Zillow.com Homes

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!

Developer
Maintained by Community

Actor Metrics

  • 16 monthly users

  • 7 stars

  • >99% runs succeeded

  • 3.6 hours response time

  • Created in Jul 2022

  • Modified 2 months ago

Categories