When exporting user data as described in Exporting User Accounts, you may wish to see the dates in readable format instead of the UNIX time. This can be accomplished by manipulating the data in Excel.
Step-by-step guide
To convert a date field:
- After opening your csv file in Excel or LibreOffice, use the following command in a new column. Cell T2 is assumed to be the date cell.
Excel or LibreOffice
=(((T2/60)/60/24)+DATE(1970,1,1))
- Next, use Excel'ls autocomplete function to populate the date fields for all rows.