How to separate the combined date-time column in exported CSVs
Follow the below steps to separate the combined date-time column into two individual date and time columns. The following steps will be applicable for LibreOffice Calc for Linux.
Open the downloaded CSV file and choose
Date (MDY) from the Column type drop-down. Then click
Combined date-time column in exported CSV
- In the new page that opens, select the combined date-time column and navigate to Data on the title bar of the page.
- Select Text to Columns and choose Space for the Separated By field. By default, the Tab option will be enabled for the Separated By field, so you'll need to uncheck that after choosing Space.
- Choose the Collection Time column and then select Date (MDY) from the Column type drop-down. Once you're done, click OK.
Choose the column type as Date(DMY).
Now you'll be able to view the date and time in two separate columns, and you can rename them accordingly.
The above steps work for all combined date-time formats.
Separate date time column.