Energy data export

Hi,
I would like to know if there is an easy way to export the data shown in the energy panel to a CSV file or something I could process outside of HA.

I can’t find a way to do it…

Thanks in advance!

I have just starting doing this myself using the new Google Sheets integration.
To help get started i recommend this youtube video that helped me get started too.

Any progress?
I have linked google sheets to home assistant but dont now how to create an automation that exports the energy consumption/production

I did this way… it works fine…

Is it possibly to use the history integration to insert Daily, Weekly, Monthly etc values of a sensor into the google sheet?

1 Like