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.
Step-by-step guides
Date fieldCheckbox:
Date field's are stored in UNIX timeCheckboxes are stored as a 1 (for checked) or a 0 (for unchecked). Follow these steps to convert a date field.to TRUE or FALSE
After opening your csv file in Excel or LibreOffice, use the following command in a new column. Cell T2 S2 is assumed to be the date checkbox cell.
Info Excel or LibreOffice
=(((T2/60)/60/24)+DATE(1970,1,1)IF(S2 = 0, "False", "True")
Use Autocomplete to populate the rest of the column.
...
CheckboxDate:
Checkboxes Date field's are stored as a 1 (for checked) or a 0 (for unchecked)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.
...
Related articles
Microsoft Excel cell formatting: Format cells
...