Unix Timestamp in Excel

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

Get the current timestamp

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

Timestamp to date

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

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 Excel 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.

NOW uses the computer’s local time. Put the current UTC offset in minutes in A1, such as 540 for UTC+09:00, and format the converted date cell as a date and time.