Export data
✓ EnergyID for BusinessExport the data of the records in your workspace to CSV or Excel, for example to process it further in your own reporting.
Available from the Standard subscription.
Create an export
- In your workspace menu, click Export.
- Under What do you want to export?, choose the type of data.
- Fill in the period and the other fields, choose CSV or Excel and click Export.
The export runs in the background. You then find the file in Export history, at the top right of the export page or in your account menu. You don’t receive an email. The history shows your own exports of the last 30 days; after that the file is deleted.
What can you export?
- Record information: per record the number, name, address, characteristics, labels and your custom fields.
- External records: the same data for the external records, with the reference.
- Invites for external records: the invitations sent, with their activation code.
- Meter information: the meters of your workspace’s records.
- Energy balance in kWh (per day) and Electricity off-take and injection (15-minute values): one file per record (in a zip), or all records together in one file.
- The results of your reports, such as Collective self-consumption and PV performance. You export Solar power settlement with the download icon in the report itself.
- Devices and Campaign deliveries: administrators only.
Which types you see depends on the features enabled in your workspace. The tables of the record list and the reports also have a download icon for an export.
How long can the period be?
- Per quarter hour or per hour: up to 366 days.
- Per day: up to 731 days.
- Per week, month or year: up to 3653 days.
Frequently asked questions
Are external records included in my export?
In exports of measurement data only if their owner gave data consent. See Working with external records.