How to convert the timestamp from the exported .csv into readable date and time

Solution: How to Convert the Timestamp from the Exported .CSV into Readable Date and Time

1. Add a new column next to the "Timestamp" column in your .CSV file.
2. In the first cell of the new column, enter one of the following formulas:
   Option 1 (Detailed):
   =INT(((A2/60)/60)/24)+DATE(1970,1,1)
   Option 2 (Shorter):
   =A2/86400 + 25569
3. For Option 2 format the cells/column to Date format  (e.g. yyyy-mm-dd).
4. After applying the formula, format the cells in this new column as date and time.
5. Drag the formula down to apply it to the entire column.
   
   

This will convert your Unix timestamp into a readable date and time!