Google Sheets: Convert Unix Epoch Timestamp to Date

July 18, 2019

Using Formula

Show UTC Date

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

With Timezone (+8 GMT)

=1563418200/86400 + DATE(1970,1,1) + 8/24

Using Custom Function

At Google Sheets, click Tools -> Script Editor.

Edit the script and click Save.

function TIMESTAMP_TO_DATE(value) {
  return new Date(value * 1000);
}

Now you can use this custom function / formula in Google Sheets.

=TIMESTAMP_TO_LOCAL(1563247671)
This work is licensed under a
Creative Commons Attribution-NonCommercial 4.0 International License.