Export formats
CSV Export supports the following standard formats.
Meter readings (space level)
This format provides meter readings at space level, including location hierarchy and device identifiers.
By default, this export provides the last reading per day for each meter (one row per meter per day). If you require interval reads (for example, half-hourly), please confirm this during onboarding.
site_name,building_name,floor_number,space_name,device_identifier,meter_number,measured_on,metric_type,value
Hamilton,Bothwell Bridge,1,Kitchen,313330145B406844,856406844,2023-08-01T19:00:00Z,ElectricityKwh,9787.554
Hamilton,Bothwell Bridge,1,Kitchen,313330145B406844,856406844,2023-08-01T20:00:00Z,ElectricityKwh,9791.98
Hamilton,Bothwell Bridge,1,Kitchen,6664542IL0911,72953663,2023-08-01T19:00:00Z,WaterVolumeM3,38.2014
Hamilton,Bothwell Bridge,1,Utility Cupboard,ABC22453114,22453114,2023-08-01T19:00:00Z,GasVolumeM3,1.799
| Column | Description |
|---|---|
site_name | Name of the site |
building_name | Name of the building |
floor_number | Floor number |
space_name | Name of the space (apartment, office, common area, etc.) |
device_identifier | Unique identifier for the device |
meter_number | Meter serial number |
measured_on | Timestamp of the reading in ISO 8601 format |
metric_type | Type of measurement (see Metric types) |
value | Meter reading in the appropriate unit |
Aggregated consumption (building or site level)
This format provides daily consumption data aggregated at building or site level, grouped by meter category and metric type. It is ideal for ESG reporting platforms and portfolio-level analysis.
external_identifier,site,building,meter_category,meter_type,day,metric_type,unit,consumption
a7ef67512989a8457ee5959a13849075,Site Name,Block A,Resident,Electricity,2025-10-01T00:00:00.000Z,ElectricityKwh,kWh,33.3
a7ef67512989a8457ee5959a13849075,Site Name,Block A,Resident,Electricity,2025-10-02T00:00:00.000Z,ElectricityKwh,kWh,28.1
| Column | Description |
|---|---|
external_identifier | Unique hash of building ID (or site ID) + meter category + metric type (consistent across exports) |
site | Name of the site |
building | Name of the building (blank for site-level aggregation) |
meter_category | Category of meters included (for example, Resident, Commercial, Landlord) |
meter_type | Type of meter (for example, Electricity, Water, Gas, Heating, Cooling, HeatingCooling) |
day | Date of the consumption period |
metric_type | Type of measurement |
unit | Unit of measurement |
consumption | Total consumption for the period |