Google Sheets PV Tracker

Feel free to download if you wish

I created a Google Sheet to track some of the most important elements of our PV systems.

Here’s a link to our 2025 data.

I upgraded and automated my tracking in 2026. I track the amount of electricity we’ve used each day (the Load), the amount our PV system has produced both in total and at the individual “string” level, and how many kilowatt hours we’ve put into and taken out of our batteries. The sheet also calculates the difference between those values (“Net Loads”, “Net Energy” and “Net Battery”).

I also wanted to keep track of any days when we had to run the generator. If that happens, I just put an “X” in the appropriate cell for that day. And finally, I record the lowest state of charge for the batteries for that day. Home Assistant appends these values to Google Sheets just before midnight each day, and then the data resets.

Here’s a link to data for the house.

And here’s data to similar data for the studio.

If you decide to download and use a copy, I hope you find it useful.