How to convert UNIX timestamp to readable date

Last published at: 2023-06-23 14:52:47 UTC

This article has been archived as nowadays dates are exported in ISO 8601 format instead of as a UNIX timestamp.

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, enter this formula =R2/86400000+DATE(1970;1;1) , where R2 is the date cell that you want to convert, and press Enter.
  2. Select the cell that uses the formula, and in the Ribbon change the format from General or Scientific to Short Date.

Now the cell is in a readable date.