Upload consumption and production data

Data Requirements


To ensure a seamless setup of your environment in the Granular Energy platform, please follow the dataset requirements outlined below when preparing your Excel/CSV files:

  • The following columns are required: metering_point, period_start and quantity
    • Metering point names are case-sensitive and must match metering points for existing production devices or consumers
  • Standardized metering data for generation and consumption
    • We support monthly, hourly, and sub-hourly metering
      • Monthly data should be captured on the first of the month at 00:00:00+zz:zz
    • Data should be provided with a frequency of either 5, 10, 15, 30 or 60 minutes
    • The timestamp should follow the ISO 8601 standard, e.g. 2022-09-30T05:00:00+01:00
  • Quantities should be in kWh, with max. 3 decimal places

Uploading Data

The metering data for both consumption and generation can be uploaded via the "Import data" page under the Portfolio section of the sidebar.

The flow of uploading consumption and production data is as follows.

Step 1: Select "Consumption metering data" or "Production metering data"

Step 2: The data import template works with one or more metering points via a 3-column CSV file as described below

Column name

Format

Description

metering_point

string

Your client reference (set in the metering point description)

period_start

datetime

in ISO 8601 format with timezone included

Timestamp of the measurement (example: 2022-09-30T05:00:00+02:00)

For the avoidance of doubt, the timestamp refers to the start time of the measurement step.

Data can be provided with a frequency of either 5, 10, 15, 30, or 60 minutes.

quantity

float

The quantity of energy in kWh, with a maximum of 3 decimal places (Wh precision).

Step 3: Select your prepared CSV file by either selecting the file from your computer folders or with drag-and-drop

Step 4: Click "Continue". The status of your file upload can be monitored on the screen. Any errors found in the CSV will pop up at the top. 



Important to note

  • The platform supports files with different granularities (e.g., sub-hourly, hourly, daily, monthly) and automatically checks the granularity of the data you're uploading.
  • Re-uploading the dataset will rewrite the existing data only if the granularity matches the previously uploaded data for that metering point. If the granularity doesn’t match, you must adjust your data file or consult support@granular-energy.com for guidance.