Sign-up for a free webinar

Exporting Sensor Data for use in Microsoft Excel

Keywords: exporting sensor data, CSV, Excel, report


The following steps will guide you through the process of exporting your sensor data to a CSV file and help you understand the format of the data file.

Exporting Sensor Data

  1. Click on the sensor name in the "Sensor List" window.
  2. Click the "Export" tab from the sensor details window.
  3. Select the sensor(s) for which you want to export data  (You can export date for the viewed sensor, or choose to include data from all sensors in the sensor network or the entire account).
  4. Select a date range for the data you wish to export.
Export Tab

      5.  Choose which data you would like to export for the sensor(s) selected.

Export Data Fields

       6.  Click the "Export data to CSV file" button.
       7.  The .csv file will be downloaded to your browsers default download directory. You can open this file in any spreadsheet
            editing program such as Microsoft® Excel.

Data File - Column (Field) Definitions

MessageID: Unique identifier of the message in our database.
SensorID: If multiple sensors are exported you can distinguish which reading was from which using this number even if the names for some reason are the same.
Sensor Name: The name you have given the sensor.
Date: The date the message was transmitted from the sensor.
Value: Data presented with transformations applied but without additional labels.
Formatted Value: Data transformed and presented as it is shown in the monitoring portal.
Battery: Estimated life remaining of the battery.
Raw Data: Raw data as it is stored from the sensor.
Sensor State: Binary field represented as an integer containing information about the state or the sensor when the message was transmitted. (See "Sensor State Explained" below).
Gateway ID: The Identifier of the gateway that relayed the data from the sensor.
Alert Sent: Boolean indicating if this reading triggered a notification to be sent from the system.
Signal Strength: Strength of communication signal between the sensor and the gateway, shown as percentage value.
Voltage: Actual voltage measured at the sensor battery used to calculate battery percentage, similar to Received Signal you can use one or the other or both if they help you.

 State (Explained)

The integer presented here is generated from a single byte of stored data. A byte consists of 8 bits of data that we read as Boolean (True (1)/False (0)) fields.

Sensor State Information

Using a temperature sensor as an example.

If the sensor is using factory calibrations the Calibrate Active field is set True (1) so the bit values are 00010000 and it is represented as 16.

If the sensor is outside the Min or Max threshold, the Aware State is set True (1) so the bit values are
00000010 and it is represented as 2.

If the customer has calibrated the sensor this field the Calibrate Active field is set False (0) AND the sensor is operating inside the Min and Max Thresholds, the bits look like 00000000 this is represented as 0.

If the sensor is using factory calibrations and it is outside the threshold the bit values are 00010010 and it is represented as 18 (16 + 2 because both the bit in the 16 value is set and the bit in the 2 value is set).

Note: These two are the only bits that typically observed outside of our testing procedures.

For more information on using Monnit wireless sensors, visit the support section of our website.