How to convert Unix timestamps in CSV exports

Converting a Timestamp in Excel

Some time-based parameters in CSV exports might show as a long number (Unix timestamp) rather than a readable time format. To convert this into an HH:MM:SS format, please follow the steps below:

1. Copy this formula: "=(((Cell Name With Timestamp/60)/60/24)+DATE(1970,1,1))", then press the Enter key.
2. Then right click on the cell that contained the formula and select Format Cell.
3. Select Time and choose the desired time format.
4. The time will now show in a readable HH:MM:SS time format and can easily be applied to the remaining cells by dragging the formula down.