Download your data
Beware! This feature is for data nerds only. Every half hour your electricity meter records how much power you’re using. This allows us to display your usage each day, week, or month in the Octopus Energy App, and to calculate your bill.
The data is yours, and if you're the sort of person who likes to dig into these details, we make it available for you to download.
Why download your data?
For most of us, the charts in our app give us enough information to see how much electricity we’re using, when, and what it costs.
But, if you’re that way inclined, there's more to learn from your usage data. For example you can understand the impact of shifting usage from Peak to Off-Peak and Night rates.
You can download your data from the Usage & Rates screen of the Octopus Energy mobile app by scrolling down and pressing the Request Data button.
This displays the date range, which you can adjust, and a Download button.
You can download up to 12 months of data at a time.
If you’re wanting the date range to start more than 12 months ago, the easiest way is to delete the end date (ignore the warning messages), then type your desired start date into the start date field and press the TAB key. Trying to set an earlier date range by clicking on the calendars is a painful experience - we’re working to improve that in coming releases.
The data will be supplied in CSV format.
Open the file with Google Sheets, Excel or your preferred spreadsheet app and dive right in.
Your data file includes:
your account number
your ICP Number (the service point identification number unique to your smart meter location)
your meter serial number
the meter channel
your usage
whether the reading is estimated or actual
Here’s a glossary of the terms you’ll find in the spreadsheet so you can decode them:
icp_number | Your Installation Control Point (ICP) is the unique identifier for your electricity connection
serial_number | The serial number of your electricity meter
energy_direction | Shows if this channel records import or export. Import is electricity you consume. Export is electricity you export to the grid e.g. solar.
register_content_code | Signifies the type of register (e.g. CN = Controlled, UN = Uncontrolled, D = Day, N = Night, IN = Inclusive, EG = Export)
channel_number | Most meters have multiple channels. Often you can differentiate them by the register content code. But some meters might have, for example, two UN (uncontrolled) channels. In this case the channel number is how you can tell them apart.
period_of_availability | How many hours per day this register is available, and recording
read_start | Date and time of start of the reading period.
read_end | Date and time of end of reading period (30 minutes after the read_start).
quality | Whether this is an Actual or an Estimated Read. Estimated reads are where we don’t have data from your meter for that time. Us or the metering company estimate the reading based on your prior usage. If we get read data later, we replace the Estimate with the Actual reading.
kwh | The quantity of kilowatt hours (kWh) used or exported in this half hour period.
Consumption information is unique to each consumer, so the data allows for tailored analysis rather than analysis based on a standard profile.
It shows you how much electricity you use as an individual consumer and when you use it.
You can download a maximum period of one year's consumption data at a time.
