How to save/export data to Excel format?

[patosette (Christian)]

Hi everyone, i need to save datas from HomeAssistant to create a sort of log where i have readings from selected sensor every x minutes in a format compatible with Excel (.csv, .xls, .xlsx or so).
I managed to do that with the Google Sheets integration, but i’d like to have a backup option that does not require internet acces (as HomeAssistant works in a network with a 4G router so it could drop sometimes) and so i’d need to save datas to a file in HomeAssistant or, if that’s not possible, to export existing datas from Home Assistant history into excel, selecting a period of time and frequency… do you know any solution that could work?

[VDRainer]

You can use the history-explorer-card in the frontend and here is a solution with a file notification.

Export sensor data to text file

You can use the file notification for this. All you have to do is build the message like you want. eg: notify: - platform: file name: filenotify filename: /your/path/to/file.csv #timestamp: true automation: - alias: sensor_values_to_file initial_state: 'on' trigger: - platform: time at: '23:59:55' action: - service: notify.filenotify data_template: message: "{{ states.sensor.test_sensor1.state }};{{ states.sensor.test_sensor2…

[happi.happo (Hello World)]

Is there some default way to do this? Out of the box in the application?

[VDRainer]

Wait for 2024.2

2024.2: Beta release notes

[jakeasmith]

Ooo neat. It’s native now! Here’s an updated link to the release notes:

2024.2: More voice, more icons, more integrations, more... everything!