File format
Your CSV files must meet the following requirements:
- Format: CSV (comma-separated values)
- Device identifier: Each row must include a value matching the
device_identifierconfigured in the platform. This is usually the meter serial number (typically 8 digits for M-Bus meters). If your data logger exports a column labelledDevEUI, this should contain the meter serial number. - Timestamp: Each row must include the date and time of the reading.
- Reading value: Each row must include the meter reading.
Supported units
Readings should be provided in the following units:
| Meter type | Unit |
|---|---|
| Electricity | kWh |
| Heating | kWh |
| Cooling | kWh |
| Gas | m³ |
| Water | m³ |
Utopi format
Our preferred format uses three columns with ISO 8601 timestamps:
measured_on,device_identifier,value
2024-06-11T00:00:00Z,313330145B406844,3200.0000
2024-06-11T00:30:00Z,313330145B406844,3201.0000
2024-06-11T01:00:00Z,313330145B406844,24959.9991
| Column | Description |
|---|---|
measured_on | Timestamp of the reading in ISO 8601 format |
device_identifier | Unique identifier matching the device configured in the platform |
value | Meter reading in the appropriate unit |