Mixed Analytics Blog Google Sheets: Convert Unix Timestamps to Dates

Certain APIs and datasets accept or display data in Unix epoch 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 A2. Array formulas are also provided for converting ... Read moreSource