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")
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.
...
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
...