- Insert your ten digit unix timestamp in Excel
- Timestamp to date formula
- GMT offset
- Format the cell to date
- Format the cell from number to date
- Result
- Insert your ten digit unix timestamp number in the first cell of your Excel sheet
- Type the following formula in the second or third cell of your Exel sheet:
=(((A2/60)/60)/24)+DATE(1970,1,1)
The formula converts the seconds to days and then add them to January 1, 1970
- Adjusting the formula for the GMT offset.
If you live in France, you need to adjust to offset by 1 (+1) which gives you the following formula
=(((A2/60)/60)/24)+DATE(1970,1,1)+(1/24)
- Right click on the formula cell and click on format cells
- In the "number" tab, select Date
- 10 Digit Unix Timestamp Converted