How to export datas to Excel?

[patosette (Christian)]

Hi everyone, i need to create a sort of logger in which based on conditions (values above threshold, time etc) i can save the data from the sensor into a .csv or other excel compatible formats.
I managed to do it with the Google Sheets integration but i would like an offline solution too… do you have any idea?

[VDRainer]

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…