Skip to main content

How to Export IoT Data

Export sensor data from your IoT devices for reporting, analysis, or compliance documentation.

Quick Summary

Go to Settings gear → Export Data, select an IoT device type or specific devices, choose properties and date range, then click Export.

Before You Begin​

Requirements
  • You must be an Organization Owner or Admin
  • Your plan must include the Export Data feature
  • You need IoT devices registered with sensor data

Step-by-Step Guide​

Step 1: Open Export Data​

  1. Click the Settings gear () at the bottom of the sidebar
  2. Select Export Data

Step 2: Select Data Type​

Choose how you want to export data:

OptionDescriptionBest For
IoT Devices → ModelExport all devices of a specific typeBulk exports, compliance reports
IoT Devices → Asset nameExport specific devices by nameTargeted analysis, troubleshooting

Step 3: Choose the Model (Asset Type)​

  1. Click the Model dropdown
  2. Select the IoT device type (e.g., "Temperature Sensor", "Humidity Monitor")
  3. Only IoT-enabled asset types appear in this list

Step 4: Select Specific Assets (Optional)​

If you chose Asset name in Step 2:

  1. Click the Asset name dropdown
  2. Select one or more specific devices
  3. Use the search to find devices by name

Step 5: Choose Properties​

  1. Click the Property dropdown
  2. Select which sensor readings to include
  3. Available properties depend on the asset type

Common properties:

  • Temperature
  • Humidity
  • Battery level
  • Signal strength

Step 6: Set Date Range​

  1. Click Start Date and select the beginning of your date range
  2. Click End Date and select the end of your date range
Date Range Limit

The maximum date range is 92 days. For longer periods, run multiple exports.

Time Zone

Exported timestamps are in UTC+0, not your local time zone. Keep this in mind when analyzing the data.

Step 7: Choose Export Format​

FormatDescriptionBest For
CSV (Excel)Comma-separated valuesExcel analysis, spreadsheets
JSONJavaScript Object NotationSystem integrations, programming

Step 8: Export​

  1. Review your selections
  2. Click the Export button
  3. The file downloads automatically

Real-World Examples​

Example 1: Export Monthly Temperature Data for Compliance​

Situation: You need temperature records from your cold storage sensors for a food safety audit.

Solution:

  1. Go to Settings gear → Export Data
  2. Select IoT Devices → Model
  3. Choose Model: Cold Storage Sensor
  4. Select Property: Temperature
  5. Set Start Date: First day of last month
  6. Set End Date: Last day of last month
  7. Choose CSV (Excel) format
  8. Click Export

Result: You receive a CSV file with all temperature readings from your cold storage sensors for the month, ready for the auditor.

Example 2: Troubleshoot a Specific Sensor​

Situation: One of your humidity sensors in the server room seems to be showing erratic readings. You want to analyze its data.

Solution:

  1. Go to Settings gear → Export Data
  2. Select IoT Devices → Asset name
  3. Choose Model: Humidity Sensor
  4. Select Asset name: "Server Room - Humidity 01"
  5. Select Property: Humidity, Battery Level
  6. Set date range for the past week
  7. Choose CSV (Excel) format
  8. Click Export

Result: You can review the data in Excel to identify patterns or anomalies in the sensor readings.

Example 3: Export Data for Sustainability Reporting​

Situation: Your ESG team needs energy consumption data from smart meters for the quarterly sustainability report.

Solution:

  1. Go to Settings gear → Export Data
  2. Select IoT Devices → Model
  3. Choose Model: Smart Power Meter
  4. Select Property: Energy (kWh), Power Factor
  5. Set Start Date: First day of quarter
  6. Set End Date: Last day of quarter
  7. Choose JSON format (for import into reporting system)
  8. Click Export

Result: Energy data is exported in JSON format, ready for the sustainability reporting platform.

Understanding Your Export File​

CSV Format​

The exported CSV includes columns for:

ColumnDescription
TimestampDate and time of reading (UTC)
Asset NameName of the device
Asset IDUnique device identifier
[Property Name]Value for each selected property

JSON Format​

JSON exports follow this structure:

{
  "data": [
    {
      "timestamp": "2024-01-15T10:30:00Z",
      "assetName": "Temp Sensor 01",
      "assetId": "abc-123",
      "temperature": 22.5
    }
  ]
}

Troubleshooting​

Can't Access Export Data​

IssueCauseSolution
Page is blurred/lockedInsufficient permissionsContact your organization owner or admin
"Feature not available"Plan doesn't include exportUpgrade your subscription plan

No Data in Export​

IssueCauseSolution
Empty fileNo data in date rangeCheck date range, ensure devices were active
Missing devicesWrong asset type selectedVerify the correct model is selected
Missing propertiesProperties not configuredCheck asset type has properties defined

Date Range Error​

IssueCauseSolution
"End Date must be greater than Start Date"Dates reversedSwitch start and end dates
"Range must be less than 92 days"Range too longSplit into multiple exports

Tips for Data Export​

For Compliance Reporting​

  • Export monthly to maintain regular records
  • Include all relevant properties for complete documentation
  • Save exports with clear naming: SensorType_YYYY-MM.csv

For Analysis​

  • Use CSV for Excel pivot tables and charts
  • Use JSON for importing into analytics tools
  • Include battery level to identify unreliable readings

For Large Data Sets​

  • Break exports into smaller date ranges
  • Export by asset type rather than all devices
  • Schedule exports during off-peak hours

Need help? Contact Infodeck Support

Was this page helpful?