Solved

How do I export my OVO usage data?


I'd like to be able to export my usage data, so I can have access to it even if I leave OVO (etc). I've never seen a function do do this. Does it exist?
icon

Best answer by Tim_OVO 8 December 2020, 10:38

View original

19 replies

Userlevel 6
Badge +1

I’m told that you can ask for a manual export but it’s a bit slow and not always ideal.

FWIW, I had cause to ask for this a little while back (prior to moving out/closing another account) and received 6 months’ worth of CSV data by email within a few minutes of asking.

But I was told that it’s only ever the most recent 6 months’ data that are available this way. I was sufficiently motivated to get the download-it-yourself-using-the-existing-but-undocumented-OVO-api option to work, and I now have a local copy of all the usage that can be displayed in My Ovo, right back to when my account(s) opened.

Good luck.

Userlevel 7
Badge +4

Heya @ajr !

Thanks for the bump. :)

I’d definitely recommend getting the Support Team to investigate that comms issue, but there’s not been much news otherwise recently. I’m told that you can ask for a manual export but it’s a bit slow and not always ideal.

However, I did recently make a code change to the OVO Energy integration with Home Assistant that makes it less spammy on the API while still getting usable data. While it’s not officially supported by OVO, it is technically one way of doing it.

Let me see if @Tim_OVO knows more about this as well.

Bump!

Still waiting. In the meantime, since 26th May I think my meter has been unable to communicate data to OVO because even the OVO plots show rubbish/missing data in my daily usage charts. But that’s a separate issue!

Bump!

 

7th Jan 2021

We’re sorry but you can’t download your energy use data online yet – we’re working on making this happen. If you’d like a copy for your records, the only way to do this is copy and paste the data or to print the screen from your browser.

Userlevel 7

Updated on 08/01/20:

 

Thanks for chasing up this outcome, @ajr @Blastoise186 

 

As you mentioned, our Help Centre article confirms:
 

Download energy use data

 

We’re sorry but you can’t download your energy use data online yet – we’re working on making this happen. If you’d like a copy for your records, the only way to do this is copy and paste the data or to print the screen from your browser.

 

Our online account and billing platform has been built in house. It’s constantly being worked on. This is one of the features on that list.

 

Another that’s on the list is the publishing of a public API and its documentation. More on that soon, but in the meantime, please see this topic:

 

 

Some members of this community have created a workaround to allow usage data to be downloaded. @Jequinlan is best placed to advise if you have any questions, it was his friend who build this!  

Userlevel 7
Badge +4

Hi @ajr ,

I can understand you there. I’d also love to be able to do this myself. I’m currently chasing up on this with Tim and hopefully I can provide some news within the next day or two at most. I’ll definitely let you know when I hear back.

Hi Blastoise,

 

Thanks for replying.

I’m hoping the request isn’t lost, because if you go to the main Ovo website and click on the obvious “Help” link and then “Meters, readings and usage”, the first question is “Download energy use data” and the answer is given here:

https://help.ovoenergy.com/article/e0079b94-ea2a-4139-a4ae-82fbcd3ee720-web

Download energy use data

We’re sorry but you can’t download your energy use data online yet – we’re working on making this happen. If you’d like a copy for your records, the only way to do this is copy and paste the data or to print the screen from your browser.

So either OVO is actually “working to make this happen”! or they’re lying!

Honestly, being able to downloading your own data was something I just assumed would be the obvious outcome of having a smart meter installed. Its the most basic function that anyone with a PC and a copy of Excel (or a better tool) would expect to be available with a smart meter installed. If you make any small behavioural changes on particular dates (which is what it’s meant to be about, right?) then you can only really determine if there have been any positive results by doing an analysis which the onscreen Ovo analysis just doesn’t give you.

 

Userlevel 7
Badge +4

Good evening @ajr ,

Sorry for the wait, this forum is mainly volunteer led and I didn’t manage to catch up with the threads until just now.

Unfortunately, I don’t have the ability to mark a thread as “unsolved”, since my own permissions only allow me to mark something as a Best Answer. It may be worth noting that the “Solved” tag is not necessarily used because a question has been solved as such, but because it has an answer that is considered good enough to answer the question that has been asked. It can be updated though with new information later on.

It also looks like this feature request may have gotten lost somehow. I will have a chat with @Tim_OVO for an update when I get chance, since Amy and Eva aren’t available right now.

Half-Hourly Variable Rate Tariffs are available from one or two suppliers, but there’s very few options for these and they are all highly experimental at this time. There’s no guarantee that you’ll be able to get one.

Clearly this is not solved. Can someone please change its status back to “unsolved”?

 

I agreed to have a smart meter because I assumed it would give me access to this data. I am staggered that I now have this dumb “smart” meter which neither allows me to access my own usage in any format that I can process (csv, or excel, whatever), nor offers me any tariffs with prices that vary by time of day/week.

 

It looks like I’ll still be reading my meter manually and typing the numbers into a spreadsheet as I always used to do.

 

Thanks Amy
Userlevel 6
Thanks for the update, @ferka, all valid point's that I'll feed back!

Thank you!
Hello,

I can provide an update:

  • There is NO way of doing this by yourself.
  • You DO have the right to your data.
  • To find out the above, one has to dredge through a load of legislation. No answers are automatically provided by companies such as OVO, nor easily accessible from the government.
  • OVO told me that they only store 180 days of info on their servers due to storage restrictions. I find this to be an unconvincing reply as the data is not huge.
  • OVO responded to my email within a month with two data files in PDF format (gas and electric, I've yet to try and extract the data). They both contain 2 years of data and are about 6 MB each.
My suggestions to OVO,

  • Store All the data. 6 MB per year per client per energy type is not a lot. It would also be smaller in raw data.
  • Make the data available via automatic online request form. Reduce the friction.
Why not be a step ahead of the rest?

All the best

Fergus
Userlevel 6
We had a similar query about this, @Summertime, take a look at this topic for more info.
Hi and with our smart meter, there doesn’t seem to be any way of downloading the screen data onto Excel. Any ideas?
Update. According to what I found in the EU report 'My Energy Data' (p66, which you can find here), I have the right to request two years of my detailed data. I also think this is necessary to comply with GDPR (also mentioned in the report)?

I therefore would like to request that data. Could you let me know how I should do this?

I note from further searching that this question has been asked before, and although marked 'solved' it's certainly not.

https://forum.ovoenergy.com/understanding-your-smart-meter-65/how-do-i-get-access-to-the-usage-data-from-my-smart-meter-312

I'd like to add two extra question

  1. Who owns our smart meter data
  2. What legal rights do we have to request that data.
It's remarkably hard to find answers to those questions.
Thank you. This would be very useful/welcome for a few reasons.
  1. Data ownership. I think as a principle we deserve ownership and access to our own data.
  2. Backup. I don't trust any organisation to look after my data.
  3. Flexibility. With access to our own data, we can do things that the OVO website does not do. We can do our own comparisons, our own correlations and such like.
Userlevel 6
Hi @ferka and @ITGeek123,

You're right it's not possible at the moment but I will pass this on!

Cheers
Userlevel 7
Badge +2
Hello @ferka

I do not believe this exists at the moment but could be fantastic feedback to provide to the team. 👍

@Nancy_OVO Is it possible to provide this to the team?

Reply