When I open the CSV file in excel, timestamp shows as a number, not in a date format. How can I convert it?
The timestamp is most likely in unix time. To convert it to a date and time in Excel use the following, where CellWithUnixTime is a link to the cell with the unix timestamp e.g. A2. Remember to also change the cell format to date and time.