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

    • Site24x7 Real User Monitoring (RUM) - Data Collection

      When you include Site24x7 RUM beacon script in your web pages, the following data is collected. All data that's being collected is in accordance with GDPR compliance. Performance details of web page load time - Metrics like response time of web page ...