Skip to main content
Rank 4
November 23, 2022
Completed

"Export to csv" feature for usage data of the online account

Related products:Online account
  • November 23, 2022
  • 47 replies
  • 1720 views

A “save to csv” button option in the usage pages.

  • Choose electricity or gas
  • Choose a date range (could be one day, or up to 6 months)
  • Choose granularity (by day, or by half-hour period)

A simple-format csv file is produced that contains the data, with days in rows.
There would be a single column on LHS with the date in standard excel-compatible numeric code.

If you asked for “by day” granularity then there would just be a single 2nd column, with kWh per day.

If you asked for “half-hour” granularity then there would be 48 columns to the right of the datecode (so a total of 49 columns), showing  kWh usage for each half-hour period for each day.

 

This links to the following old thread:

… and also this recent chat in the Power Move trial …

 

47 replies

Tim_OVO
OVO Staff
OVO Forum Legend
January 30, 2024

Follow this link to post this as a new topic thread, a discussion rather than an idea:

 

 

Carbon neutral - we need a community to get there! My green tech: Aclara SGM 1411-B smart meter, Chameleon IHD6
Rank 2
January 30, 2024

Ah I see - I can do that if you want.

Something like that.
Newcomer
October 8, 2025

Hi all, I appreciate this is a very old thread, however it still pops up as the top result on google when searching for getting the raw CSV data as it’s not available on the OVO website still.

I wondered if the information here is still accurate?

 

I ask because:

  1. When trying to access the raw JSON data through the links suggested by ​@Firedog here https://smartpaymapi.ovoenergy.com/orex/api/meter-readings/3198692 and here  https://smartpaymapi.ovoenergy.com/rlc/rac-public-api/api/v5/supplypoints/electricity/{MPAN}/meters/{MSN}/readings I just get the response

message    "OAuth plugin - No refresh_token present"

  1. Guy Lipman’s site for Smart Meter Data is no longer active, although the source for it is available on GitHub, I wondered if there was anywhere else that had a simliar easy access way to get this?

Many thanks!

Firedog
Super User
Super User
October 8, 2025

  

… this is a very old thread,
  ​​​​

@X10 You said it! 
    

message    "OAuth plugin - No refresh_token present"
 

On the other hand, that is a very new feature of OVO’s APIs and the subject of the last few posts in this thread:

 

It’s also a long time since Guy Lipman’s handy page was taken down. I still use his source (data.n3rgy.com) for my own data, though, but it’s not so straightforward. You may want to follow the thread I referred to: some have cracked the new authorization code, and I hope ​@MikeWilliams is on the verge of releasing his updated utility. Watch that space!

 

Noel | I have no official status; I'm just a volunteer who comes here to help other customers. My gear: Aclara SGM 1416-B Electricity-only E7 meter; Chameleon IHD3-PPMID-AAA | It may look as if I know what I’m talking about, but don’t let that fool you. |
MikeWilliams
Newcomer
Newcomer
October 8, 2025

I have just finished the changes to my app for the new login and authentication methods.

I have some more testing to do before I release it.

I have today downloaded all of my data, which goes back to 2017 in a single pass.

Newcomer
October 9, 2025

@Firedog - Thanks for that. Yes it seems that depending on the question you ask Google this old thread is the most relevant result. Having said that, while doing some more rabbit-holing I discovered the other thread you just mentioned and saw Mike's link to GitHub and his most recent post shortly after he posted it.

@MikeWilliams - Thank you for the update and your work on this project.

 

Thanks both!

 

MikeWilliams
Newcomer
Newcomer
October 9, 2025

I have just released V1.0.4

You can download a copy of it at
https://github.com/MikeWilliams-UK/My-Ovo-Data/releases

 

Regards

Mike Williams