How to convert UNIX timestamp to readable date

The Duplicate Check Job Export feature is available in our Advanced and Premium edition.
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.

 

Having trouble?

Our support agents are ready to help you !