Here is the formula to convert epoch or unix time to human readable format.
when the data is in A1,
=(A1/86400)+25569+(+8/24)
The +8/24 is for the timezone correction as epoch time is in GMT.
http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/
Keywords: epoch unix time excel spread sheet conversion