How to convert UNIX timestamp to readable date
Duplicate Check Job export shows dates as UNIX Timestamps as it follows the Salesforce export format. In this article, we will show you how to convert UNIX timestamp to date.
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:1. | In a blank cell next to your timestamp list and type this formula =R2/86400000+DATE(1970,1,1), press Enter key. ![]() |
2. | Select the cell that uses the formula and in the Ribbon change format from General to Short Date. ![]() |
3. | Now the cell is in a readable date.![]() |