Export Home Assistant data graphic sensor to a .csv file or Google Sheet

If you just need a one-time report, you can use the built-in History Explorer. Navigate to the History tab in your sidebar. Select the Entities and the Time Range you want to export. Click the Download / CSV icon usually found at the top right of the history graph. Once you have the .csv file, simply upload it to Google Drive and open it with Google Sheets. Stop squinting at small history graphs! In this video, I show you the native way to export your Home Assistant sensor data as a CSV and transform it into professional charts using Google Sheets. What you’ll learn: 00:00 How to export sensor data from Home Assistant. 00:04 Click the arrow (History) icon 00:20 Click the three dots (menu) 00:44 Upload your downloaded CSV file to Google Drive 00:59 Open with Google Sheets 01:47 Choose "Line Chart" Transforming Data into Graphics Once your data is flowing into Google Sheets, it will look like a raw list of timestamps and numbers. Here is how to make it visual: Highlight your data: Select the columns containing your "Datetime" and "Value." Insert Chart: Go to Insert - Chart. Choose Chart Type: * For temperature or power usage, use a Line Chart. For daily totals (like rainfall), use a Column Chart. Aggregate Data: If you have too many data points (e.g., every minute), use a Pivot Table in Google Sheets to calculate the "Average per Day" before graphing. Tools used: #HomeAssistant #GoogleSheets #DataVisualization #SmartHome #IoT