Add separate date and time columns in exported CSV

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.

Step 1
Open the downloaded CSV file and choose Date (MDY) from the Column type drop-down. Then click OK.
Combined date-time column in exported CSV
Step 2
  1. In the new page that opens, select the combined date-time column and navigate to Data on the title bar of the page. 
  2. 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. 
  3. 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.