The UNIX timestamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970. In Excel, you can convert UNIX timestamp to readable date.
Convert Timestamp to Date
To easily convert UNIX timestamp to date in the .csv file, do the following:
- In a blank cell next to your timestamp list and type this formula =R2/86400000+DATE(1970,1,1), press Enter key.
- Select the cell that uses the formula and in the Ribbon change format from
General to Short Date.
Now the cell is in a readable date.