Convert Unix Timestamps to Google Sheets Dates

by

Certain APIs and datasets accept or display data in Unix timestamps, which are not natively recognized by Google Sheets and can therefore not be used for calculations or other data transformations.

These timestamps can be converted as follows, substituting in your date cell where you see A1.

Convert regular date to UNIX timestamp

=(A2 - DATE(1970, 1, 1))*86400
date-to-unix

Convert UNIX timestamp to regular date

=A2/ 86400 + DATE(1970, 1, 1)

2 thoughts on “Convert Unix Timestamps to Google Sheets Dates”

Leave a Comment