Welcome to the community
Simply ask, learn and share
Showing results for 
Search instead for 
Did you mean: 

Downloading Smart Meter data to CSV

posted by DHogg | A year ago

Hi There.
I have just had a smart meter installed and I am trying to download the data. My meter is set to send ½ hour readings. I can see the data (with a few missing days early on) at a daily level but I cannot see the hourly readings. Whilst I can see the readings I cannot download them as data ie CSV.

NB I have a smart meter installed in an overseas property and can download hourly readings as a CSV file. This helps when assessing whether to switch Time-Of-Day  charging. With Scottish Power I'm trying to work out what items are using the power.


posted by  Gordon | A year ago
Re: Downloading Smart Meter data to CSV

Hi @DHogg welcome to the Community! At the moment Smart Meter data is just available to view online, however we are in the early days of the Smart Meter rollout and planning more advanced account features that will allow you to get more insight into your consumption like you have suggested. If we have any trials or prototypes related to this coming up would you be interested in taking part? We would love to get your feedback! 

Also this article may explain why you are missing a few days of readings if maybe you changed the frequency to half hourly? 

Top answer

posted by DHogg | A year ago
Re: Downloading Smart Meter data to CSV
Yes that's fine. Before I retired, I was a data analyst and system controller for a national communications organisation

posted by ashmanq | 11 months ago
Re: Downloading Smart Meter data to CSV


I realise this post is 5 months old, has there been any progress in allowing us to download smart meter usage data in CSV format?

Currently you can only download the bill period usage data but you cant download the data from the smart meter usage information which is broken down to daily usage.

posted by AndyBarber | 4 months ago
Re: Downloading Smart Meter data to CSV
Hi I would also be interested in any information regarding CSV download or api that might become available.

The ultimate goal would be some sort of integration with something like openhab

posted by Davc | 4 months ago
Re: Downloading Smart Meter data to CSV

There are so many operational problems these days I think downloading of spreadsheet data is very unlikely to be worked on.