so the formula to convert unix time to date/time in excel is =(($D2+7200)/86400)+DATE(1970,1,1) and in order to display the date and time, format the column to have a custom format “dd/mm/jjjj uu:mm” Note I added 7200 seconds in order to compensate for the right time zone. You might want to add/subtract according to your time zone.