Unix Timestamp in Google Sheets

Look up the current epoch time and convert between Unix seconds and UTC dates in Google Sheets.

Get the current timestamp

=INT(ROUND((NOW()-DATE(1970,1,1))*86400,3))

Timestamp to date

=EPOCHTODATE(1700000000,1)

Date to timestamp

=ROUND((DATE(2023,11,14)+TIME(22,13,20)-DATE(1970,1,1))*86400,0)

Open 1700000000 in the converter

Current Unix time

Seconds—

Milliseconds—

UTC: —
My time zone: —

Official reference ↗

Free to use. Your input stays in this browser.

How to use it

Copy the current-time example into your Google Sheets environment to read Unix seconds.
Run the second example to display 1700000000 as a UTC date.
Run the last example to convert that date back into seconds.

EPOCHTODATE accepts unit 1 for seconds and returns UTC. For NOW(), set the spreadsheet time zone to UTC. The date-to-epoch formula assumes the input is already UTC.