How to Convert Unix Timestamp in Google Sheets

Published April 2025 · 3 min read

Timestamp (Seconds) to Date

=EPOCHTODATE(A1)

// Or if EPOCHTODATE isn't available:
=(A1/86400)+DATE(1970,1,1)

Timestamp (Milliseconds) to Date

=EPOCHTODATE(A1, 2)

// Or manually:
=(A1/86400000)+DATE(1970,1,1)

Date to Timestamp

=(A1-DATE(1970,1,1))*86400

With Timezone (IST = +5:30)

=(A1/86400)+DATE(1970,1,1)+(5.5/24)

Format the Cell

After the formula, format the cell as Date/Time: Format → Number → Date time

Batch Convert

Put timestamps in column A, formula in B1, then drag down to convert all rows.

Quick Online Convert

Use our Unix Timestamp Converter for instant conversion.

Related