Manage Analytics Data
      Back to home
      1. Help center
      2. Analytics
      3. Manage Analytics Data

      Export a CSV of your Environmental Data

      Conserv has an easy export process that allows you to download a CSV of your environmental data.

      Table of Contents

      Step-by-step Instructions on How to Export Your Environmental Data

      If you need to download raw data for analysis, follow these instructions:

      1. Click the Import/Export button at the base of the left navigation menu.
        Screenshot 2024-11-13 at 3.12.15 PM
      2. Click the EXPORT tab
        Screenshot 2024-11-13 at 3.15.30 PM
      3. Click on the search bar "Location / Space / Sensor" to select the sensor you want to export. Find your sensor by expanding the hierarchical view and selecting the correct sensor or start typing the name of the sensor in the search bar. At this time, you can only download data for one sensor at a time.
      4. Select the time period you'd like for the data. This can be one of our pre-selections or you can click, "Custom Date Range," to identify specific dates.
      5. Once your sensor and date range are selected, the button on the right to EXPORT DATA will activate.
        Screenshot 2024-11-13 at 3.19.23 PM
      6. Click EXPORT DATA. A message should pop up letting you know that we are generating your file and will email it to you. You may close this message at any time. The email will come from noreply@conserv.io. Check your spam folder and whitelist Conserv emails to ensure delivery. The email will contain a link to retrieve your CSV file.
        Screenshot 2024-11-13 at 3.22.25 PM
      7. Click the DOWNLOAD CSV button in the email. It should take you back into the web application and the file should start downloading automatically. If the download window does not open, check your pop-up blocker, and disable it if necessary.

      Video Instructions on How to Export Your Environmental Data

      Review this short video to walk you through the steps laid out above:

      Using the exported data

      Why Timestamps Use UTC

      Exported files from Conserv display timestamps in UTC (Coordinated Universal Time) using ISO 8601 format.

      For example:2025-04-05T04:09:44.580Z

      Using this standard format ensures that timestamps are consistent across time zones and systems.

      Download the Preconfigured Excel File

      To help you convert these timestamps into your local time zone, we provide a macro-enabled Excel file.

      This file includes a built-in button that performs the conversion automatically.

      Use the Conversion Tool

      1. Open the macro-enabled Excel file you downloaded.

      2. Copy and paste your exported data into the spreadsheet.

      3. Click the Convert UTC to Local Time button at the top of the sheet.

      4. When prompted, select the header cell of your timestamp column.
        Most of the time, this will be cell A1.
        A new column will appear with the converted local times. The column header will include “(Local Time)” for easy reference. You will see a confirmation message telling you how many timestamps were converted.

      Support

      If you are still experiencing issues, please contact the Support Team.