How to convert UNIX timestamp to readable date

Last published at: 2021-12-21 13:02:49 UTC
Delete

The Duplicate Check Job Export feature is available in the Advanced and Premium editions.

Delete

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.