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

October 4, 2023

This seems to only allow me to download the current view of the data. To get half hourly figures for a month (for Power Move monitoring) I would have to download a separate file for each day.

 

Please can we have one click to get half hourly data for the month to date. 

Tim_OVO
OVO Staff
OVO Forum Legend
October 5, 2023

Interesting this, @Simon 1402. Is that the same for others e.g @Matt 4567? Once confirmed, @Simon 1402 it might be good to get this set up as a separate feature idea. Let’s just confirm it’s a feature limitation and not an issue first...

Carbon neutral - we need a community to get there! My green tech: Aclara SGM 1411-B smart meter, Chameleon IHD6
Newcomer
October 5, 2023

@Tim_OVO It is a feature limitation, I have the same. As a workaround for now (aimed at people wanting to monitor their Autumn “Power Move” challenge progress, but others may find it helpful for other reasons) I’ve posted an Excel template (with instructions) into which you can paste the downloaded watt-accurate 400 day 30min data (using the link from @Jeffus above) in Forums →  Calculating whether you have hit the 12.5% target or not

Jeffus
Rank 20
Rank 20
October 5, 2023

Interesting this, @Simon 1402. Is that the same for others e.g @Matt 4567? Once confirmed, @Simon 1402 it might be good to get this set up as a separate feature idea. Let’s just confirm it’s a feature limitation and not an issue first...

Same for me 

Newcomer
October 5, 2023

This seems to only allow me to download the current view of the data. To get half hourly figures for a month (for Power Move monitoring) I would have to download a separate file for each day.

 

Please can we have one click to get half hourly data for the month to date. 

Exactly this!

I want to see a month’s (e.g., but over any designated time period would be nice) worth of data, but in half-hourly increments.  Added up over the calendar axis if you will, but kept as detailed bins in the 24-hour direction.  So whatever the integration time period, I always want 48 values.

An immediate application is the Power Move campaign, but it could be useful for other reasons. Let’s say I buy a new appliance. What does the average half-hourly consumption look like before and after the change?  

Cheers, Matt


 

Tim_OVO
OVO Staff
OVO Forum Legend
October 6, 2023

Thanks everyone, good to know.

 

Can someone set this up as a separate feature idea so we can keep this request distinct from the overall CSV download feature?

Carbon neutral - we need a community to get there! My green tech: Aclara SGM 1411-B smart meter, Chameleon IHD6
Newcomer
October 6, 2023

People seem to be downloading my “Power move” usage calculator, so I’ve updated it (details here)

October 8, 2023

As requested by Tim, I have now added this as a separate idea here:

https://forum.ovoenergy.com/ideas/download-a-month-s-worth-of-half-hourly-usage-data-16147

 

Upvote please! 

Jeffus
Rank 20
Rank 20
October 8, 2023

As requested by Tim, I have now added this as a separate idea here:

https://forum.ovoenergy.com/ideas/download-a-month-s-worth-of-half-hourly-usage-data-16147

 

Upvote please! 

Voted

Newcomer
December 22, 2023

Thanks to everyone contributing here.  This is so helpful to me. Using this discussion I was able to confirm I am actually being billed correctly for my tariff, E10.

And I thought my data from last winter was lost because it was SSE, I never thought I could download it (nor wanted to), but when I saw Ovo let me compare usage to a year ago, but I couldn’t and was frustrated. But Bright/glowmrkt has given me all that data back to the day the meter was installed. And their Temperature/Humidity sensor looks like exactly what I was trying to find on Amazon last winter.

Anyway, it’s enabled me to draw this pretty chart, which visualises what I thought was happening. Though last December was 3° cooler on average than this year, I am still keeping my home much warmer with a convection heater than with my 30 year old storage heater and for a lot less power. I turned on the storage heater on 25/11, and off again 3/12. The convection heater is getting the house 

So thanks!