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

Jeffus
Rank 20
Rank 20
February 22, 2023

@Jeffus From the glowmarkt.com website if you already have the free Bright app. 

And so it does! The consumption figures for each time period in nice CSV. Looks ideal.

Couple of questions in case anyone knows here:

  • my data (downloaded or in the Bright app) only seems to start when I registered for Bright. The SmartMeter was installed years ago - any idea if I can get historical data? Other apps seem to manage it (but no download!).
  • My Electric & Gas meters are listed - can my new Electric Export MPAN be added? That would be most useful.

Hi @mavison 

The Bright team are good at responding

Try emailing 

support@glowmarkt.com

Jeffus
Rank 20
Rank 20
February 22, 2023

Hi @mavison

You could also try this as they mention production. Let us know id that works 

https://data.n3rgy.com/consumer/home

 

Jeffus
Rank 20
Rank 20
February 22, 2023

@Tim_OVO 

It does seem quite surprising OVO don't offer this feature as it will be driving customers to 3rd party apps even more these days and other suppliers like Octopus.

It seems strange this idea was never picked up over time. One of the more obvious Ideas to pursue. 

Tim_OVO
OVO Staff
OVO Forum Legend
March 9, 2023

A quick update on this one from our product team:

 

Our Energy Insights team are currently working on this feature and we hope to have more information on when this will be live in the second half of 2023.
 

I’m looking forward to this! 

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

A quick update on this one from our product team:

 

Our Energy Insights team are currently working on this feature and we hope to have more information on when this will be live in the second half of 2023.
 

<checks calendar : ooh it’s now September 2023!> Any more info ?

//M

<notes extreme age of this feature request, back some 4 years it seems>

Tim_OVO
OVO Staff
OVO Forum Legend
September 15, 2023

Hi @Matt 4567

 

Just getting the latest update on this for you. Bear with. 

Carbon neutral - we need a community to get there! My green tech: Aclara SGM 1411-B smart meter, Chameleon IHD6
Tim_OVO
OVO Staff
OVO Forum Legend
September 15, 2023

so @Matt 4567 it turns out it's already released!

 

On the OVO app head to the Usage section, then the view table and it's down the bottom:

 

 

We’ll mark this feature idea as completed. Please let us know if you have any issues or feedback about it. 

Carbon neutral - we need a community to get there! My green tech: Aclara SGM 1411-B smart meter, Chameleon IHD6
Tim_OVO
OVO Staff
OVO Forum Legend
September 15, 2023
Open for votesCompleted
Carbon neutral - we need a community to get there! My green tech: Aclara SGM 1411-B smart meter, Chameleon IHD6
Newcomer
September 16, 2023

This is great … but the feature is only on the app not on the desktop site?

This is a bit of a minor issue, since my spreadsheets live on a desktop environment. Having to download usage via an app (which I don’t currently use, or particularly want), then export to somewhere where the spreadsheet can pick it up, is all extra faffing about.  

Tim_OVO
OVO Staff
OVO Forum Legend
September 18, 2023

I’ll pass that feedback on, Matt - much appreciated.

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