timestamper.online

Excel Unix Timestamp to Date

Use these copy‑paste Excel formulas to convert Unix timestamp (epoch) to human‑readable date and time. Supports seconds, milliseconds, and timezone offsets.

Quick Start
Seconds → Date/Time
excel
A1 contains Unix timestamp in seconds

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

Then format the cell as a Date/Time. Tip: Select the result cell → Ctrl+1 (Format Cells) → Date (or Custom) → yyyy-mm-dd hh:mm:ss.

Milliseconds → Date/Time
13‑digit epoch
excel
A1 contains Unix timestamp in milliseconds

= A1/1000/86400 + DATE(1970,1,1)

Excel stores days as serials. Divide milliseconds by 1000, then by 86400.

Timezone Offset
Example: UTC+8
excel
A1 contains Unix timestamp in seconds, convert to UTC+8

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

Add/subtract hours ÷ 24 to apply timezone offset. For UTC−5 use −5/24.

Formatting & Common Pitfalls
Avoid off‑by‑days and time drift
  • Use yyyy-mm-dd hh:mm:ss custom format for precise display.
  • If your value is 13 digits, it is milliseconds — divide by 1000 first.
  • Excel’s date serial starts at 1900‑01‑00 (with a legacy leap‑year quirk); using DATE(1970,1,1) handles the base correctly.
  • Unix timestamp is UTC. Add/subtract timezone offset only for display purposes.
Related
More tools and guides
Online ConverterSeconds vs MillisecondsTimezones & DSTGenerate Epoch Time in Excel