How to Convert Epoch Time to Date in Excel

If you are looking to convert epoch time to regular readable time, here’s a quick and easy tutorial to get you started.

Example Timestamp

Let’s say you have this timestamp: 1750750930

Steps to Convert:

  1. Open your Excel file with the timestamp.
  2. In the next empty column, add this formula:
    3. =(((A2/60)/60)/24)+DATE(1970,1,1)
  3. Or this formula =(A2 / 86400) + DATE(1970,1,1) where 86400 is number of seconds in a day, Replace A2 with the cell where your timestamp is.
  4. Format the result cell as Date & Time.
  5. Done! Below you can see the excel sheet where i used this formula.
Excel Epoch to Date Example

For large datasets, drag the formula down to apply it to all rows.

Common Issue:

If you get a #VALUE! error, make sure the cell format is set to General first.

← Back to Articles