Export History to CSV

Feature Requests
#1

The History Tab is fantastic but there is times I want to be able to grab some data quickly and throw it into excel

What I was thinking was adding a download button to the history page, using the same data (plus entity ID) and date range as the history. Selecting what entities to export would be a bonus.

If there is already a way to do this please let me know

Ability to do .csv export from History?
Export data
#2

See this post.

#3

Or perhaps a service that you can call manually, through a script or automated. Just like the recorder.purge service. Something like a history.save or history.download service, where you can provide JSON data for parameters like export type (CSV, JSON, XML) and/or a list of entities.

#4

The file notification solution has some limitations:

  • Using a trigger that fires every five minutes, you don’t get events that happen inbetween (door opens and closes again)
  • The value template looks very nasty if you have lots of sensors.

A history component that stores the data in CSV files (one for each day) would be nice. Just like the influxdb component stores the new state of each event for the included entities inside the influxdb. The component could gzip the file of the last day to save storage.

#5

Has this ever been addressed?

#6

Yes, but the pull request was rejected.

#7

Why was that? Can you share a link to the PR?

#8

This may be possible already if you are able to pull values out of the database.

I have something similar in NodeRED which takes MQTT messages, and saves them to an SQL database, but you could output CSV instead if you wanted.

1 Like
#9

+1 This would be incredibly useful for easily sharing data.

1 Like
#10

CSV export is a must. I am surprised it is not implemented yet! We have all values in the database, why not export it, instead of looking on the graph?

#11

Home Assistant is an open source project, so anyone can contribute. It will probably be added by whom it itches most. Perhaps that’s you? :wink:

#12

How about just extracting the desired data from the SQL database directly? I think there are even online converters for this.

#13

I believe the SQL returns json. So it’s a db within a db. Kinda

#14

I don’t think File Notification will work - that’s going to start outputting, but what I want to do is dump out the data for a variety of sensors for the last month. If I knew I wanted that date a month ago I would have just fixed the problem I’m trying to fix now…

#15

Found a relatively simple way to do this:

  1. Install SQLite Web add-on (GitHub - hassio-addons/addon-sqlite-web: SQLite Web - Home Assistant Community Add-ons) and open Web UI
  2. Select “states” table
  3. Select “Query” tab.
  4. Enter SQL query and click execute: it will report the first 1000 rows if successful

SELECT * FROM states WHERE entity_id = "sensor.your_sensor_id"

  1. Click on “Export CSV”: it will have all rows

Screen Shot 2022-05-25 at 17.08.05
Screen Shot 2022-05-25 at 17.08.051048×706 54 KB

3 Likes
#16

I believe this custom card supports exporting the shown data to csv:

1 Like
#17

Good pick up. Yes this History Explorer custom card works for CSV export