When exporting user data as described in Exporting User Accounts, you may wish to see the exported columns in a different format. This can be accomplished by manipulating the data in Excel or LibreOffice.
...
After opening your csv file in Excel or LibreOffice, use the following command in a new column. Cell S2 is assumed to be the checkbox cell.
Info Excel or LibreOffice
=IF(S2 = 0, "False", "True")
Use Autocomplete to populate the rest of the column.
...
Tip title Tip You can also replace "False" and "True" from the command above with "No" and "Yes" depending on your preference.
Use Autocomplete to populate the rest of the column.
...
Date:
Date field's are stored in UNIX time. Follow these steps 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.
Info Excel or LibreOffice
=(((T2/60)/60/24)+DATE(1970,1,1))
Use Autocomplete to populate the rest of the column.
...