Page 1 of 1
PV generation data export
Posted: Sun Sep 07, 2025 12:29 am
by ColonelP
Hi, does anyone know how I can export a report of my inverter data including the PV generation values on a daily basis? It doesn't look like I can generate any report that does data showing production kWh over the course of a day, only monthly or annually. what I'm looking for is a CSV file that I can produce a graph similar to the graph shown on the Foxesscloud overview page showing performance throughout the day.
Thanks,
Colin.
Re: PV generation data export
Posted: Mon Sep 22, 2025 5:11 pm
by Will
Depending on how technical you want to get but I would recommend looking at Home Assistant to capture your system data, you can then save data from HA automatically to a database or CSV
Re: PV generation data export
Posted: Sun Oct 05, 2025 5:31 pm
by Redders
Hello Colin,
Have you looked at the Apple/Android app Energy Stats, written by Al Priest?
It allows you to examine, and download to .csv files if you want, whatever data you like from your inverter. It covers a very comprehensive range of parameters for you to select from, which are collected every five minutes and can be downloaded for one day at a time. There is no Windows version that I can find, but it is very user friendly on your phone or tablet.
Once you've got the data downloaded you can do whatever you like with it. My system was installed in October last year and I now have well over half a million records with three fields in each. I am not inclined to go the full geek with Home Assistant but, after starting off with Google Sheets as my analysis tool and finding it got bogged down with the size of the dataset, I am now using an online spreadsheet called Row Zero which happily works with multi-million record datasets and is incredibly powerful. And it's free!
I've attached a couple of screenshots which will give you an idea of what it can do. I could share my workbook with you if you want to look a bit further.
Cheers
John
Re: PV generation data export
Posted: Sun Oct 05, 2025 10:03 pm
by ColonelP
Thanks John,
This is really helpful. It certainly gives me what I need without going too deep. It looks like this answers my query and it is very much appreciated.
Best regards,
Colin.
Redders wrote: ↑Sun Oct 05, 2025 5:31 pm
Hello Colin,
Have you looked at the Apple/Android app Energy Stats, written by Al Priest?
It allows you to examine, and download to .csv files if you want, whatever data you like from your inverter. It covers a very comprehensive range of parameters for you to select from, which are collected every five minutes and can be downloaded for one day at a time. There is no Windows version that I can find, but it is very user friendly on your phone or tablet.
Once you've got the data downloaded you can do whatever you like with it. My system was installed in October last year and I now have well over half a million records with three fields in each. I am not inclined to go the full geek with Home Assistant but, after starting off with Google Sheets as my analysis tool and finding it got bogged down with the size of the dataset, I am now using an online spreadsheet called Row Zero which happily works with multi-million record datasets and is incredibly powerful. And it's free!
I've attached a couple of screenshots which will give you an idea of what it can do. I could share my workbook with you if you want to look a bit further.
Cheers
John
Screenshot (1).pngScreenshot (2).png
Re: PV generation data export
Posted: Mon Oct 06, 2025 12:16 pm
by Redders
Hello again, Colin.
I'm glad you found my note yesterday useful, but I got a bit carried away with my own reporting system and neglected to pass on anything about the Energy Stats app, which is definitely the place to start.
To remedy that, I've done a couple of screenshots for each of two days which I selected because (a) 11 April was a clear day and the curve for PV generation (it's listed as "Meter2Power", don't ask...) is about as pretty as it gets and (b) 16 July was a day which started out clear and got cloudy in the afternoon. It was also the day when the maximum output I have recorded to date took place, 4.11kW at 15:41:56.
The first screenshot for each date just shows the PV generation series; the second adds in what was going on through the day for the other five parameters I track, which take a bit of getting your head around to start with but are very informative once you've done so. The one real drawback of the EnergyStats app is that it can only display the data for one day at a time. If you want to look at the series over time you will have to get into the download/spreadsheet method. That's for another day.
Hope this helps,
John