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.

 


    • Related Articles

    • Why is my website response time too high from China?

      If your website is hosted outside China and you have chosen China as the location for monitoring, then the website response time will be high. This is because of the Great Firewall policy followed by China wherein, all the data coming from outside ...
    • Response time and its components

      Response time is comprised of five major components namely DNS time, connection time, SSL Handshake Time, first byte and Download time. Let us consider a scenario to further explain these terms: A website zoho.com is monitored by Site24x7. Firstly, ...
    • Response time in Website monitoring

      In website monitoring, response time is calculated as the total time taken to resolve the DNS, complete the TCP hand-shake, negotiate an SSL handshake (for HTTPS) and download the full HTML output from the server. However, it does not include getting ...
    • Why do I observe a spike in my website response time?

      Response time is a combination of DNS time, connection time, SSL Handshake time (for HTTPS) and download time. Spikes in response time could be due to increase in DNS time or connection time or download time. Some factors to consider: In case of ...
    • Real User Monitoring (RUM) Licensing

      RUM licensing is based on Pageviews. Site24x7 includes RUM in all the plans available. The number of Pageviews and Sites provided differs based on the plan. Your RUM license limit is reset at the start of every month. Please check the below list for ...