Energy monitoring smart plug with CSV export
Jul 7 – Oct 26, 2026Updated Oct 26, 2026
Reviewed by Dimitry Apollonsky
Which brands AI mentions
Mentioned in
ChatGPTChatGPTGoogle AI ModeGoogle AI Mode
Widest split: Home Assistant, 17% on ChatGPT and 77% on Google AI Mode.
- #1ShellyChatGPT 91%Google AI Mode 91%
- #2tiedTapoChatGPT 52%Google AI Mode 55%
- #2tiedHome AssistantChatGPT 17%Google AI Mode 77%
- #4tiedKasa SmartChatGPT 26%Google AI Mode 45%
- #4tiedEveChatGPT 39%Google AI Mode 18%
Questions and answers
ChatGPTOct 26, 2026
For a smart plug that measures electricity use and lets you export the readings to CSV, I'd start with the Emporia Smart Plug or a TP-Link Kasa energy-monitoring plug. The key distinction is whether you want an easy export from a phone app or ongoing, automated data collection for analysis in Excel, Python, or another tool.
Best options to consider
1. Emporia Smart Plug
(Best verified CSV option)
$34.99
Manufacturer's listed price
Emporia explicitly supports CSV exports, including high-resolution readings. You can choose a device and date range in its app, then download the exported data. Its 1-second data is available for up to 3 hours, 1-minute data for up to 7 days, and 15-minute data for up to a year.
Trade-off: exports are requested manually, and the system relies on Emporia's cloud.
2. TP-Link Kasa KP125M
(Good alternative)
This Kasa model has documented data-export functionality in the Kasa app. The export includes two CSV files: hourly energy usage in kWh and power-consumption readings at 5-minute intervals.
View Kasa's export documentation
Trade-off: verify that the export feature is supported by the exact hardware revision and app version sold to you.
3. Shelly Plug US Gen4
$24.99
Listed at Best Buy
Worth considering if you want a smart plug with energy measurement and compatibility with multiple smart-home ecosystems.
Trade-off: I haven't verified a direct, built-in CSV export for this model. Check its data-access options before buying if CSV is mandatory.
Which should you choose?
- Simplest CSV workflow: Emporia.
- Hourly energy totals plus more detailed power readings: Kasa KP125M.
- Smart-home flexibility: Shelly, if you're comfortable setting up your own data collection.
One important question before you buy: Do you need to export CSV files manually, or do you want the data collected automatically (for example, every minute into a file or database)? That determines which plug is the best fit.
Sources cited in this answer8
- help.emporiaenergy.comExporting and Analyzing Data | Help Center
- help.emporiaenergy.comUnderstanding Your Energy Data | Help Center
- shop.emporiaenergy.comEmporia Energy Monitoring Smart Plug
- shop.emporiaenergy.comEmporia Energy Monitoring Smart Plug
- community.tp-link.comKP125M: Kasa's First Matter-Compatible Smart Plug with Improved Energy Monitoring
- community.tp-link.comKP125M: Kasa's First Matter-Compatible Smart Plug with Improved Energy Monitoring
Google AI ModeOct 26, 2026
Most consumer smart plug apps (like
Kasa or Smart Life) keep data locked in proprietary graphs, but you can get direct CSV exports or local data logging using specific hardware and platforms.Top options for monitoring energy and getting your data out into a CSV include:
- TP-Link Tapo Smart Plugs (with Energy Monitoring 2.0): Selected Tapo Wi-Fi/Matter smart plugs (such as the TP-Link Tapo P110M ) feature an official Export All Energy Usage Data button directly inside the Tapo mobile app, letting you save your historical power tracking locally.
- Shelly Plug US / Gen3 / Gen4: Shelly devices support local web interfaces, MQTT, and HTTP REST APIs. While the native app has cloud reporting, advanced users pull historical logs locally or via Shelly's web interface/scripts without relying on a locked ecosystem.
- Local Smart Home Hubs (Home Assistant): Pairing a local-first energy monitoring plug—like the Aqara Smart Plug or Zooz ZEN15 —with Home Assistant gives you the ultimate data freedom. Home Assistant logs every second of wattage/kWh data to a local database and allows you to download device history for any timeframe instantly.
If you want to narrow this down, let me know:
- Do you prefer a direct mobile app export (no extra hub required), or are you using a smart home system like Home Assistant?
- What kind of device or appliance are you planning to plug into it?
ChatGPTOct 17, 2026
If you want to track how much electricity an appliance uses and export the readings to a CSV file, I'd look for a smart plug with energy monitoring and an accessible way to export historical data.
The key distinction is that many smart plugs display electricity usage in an app, but don't provide a straightforward CSV export. You may need a plug that integrates with Home Assistant or another data-logging system.
Three good approaches
1. TP-Link Tapo P110M
(Easy to start)
A compact smart plug with energy monitoring. A good candidate for tracking an appliance's power draw and consumption. For CSV exports, check its integration options; the standard app isn't necessarily a direct CSV solution.
Best for: someone who wants an off-the-shelf plug.
2. Shelly Plug US
A good option to investigate if you want access to measured power data through local networking and integrations. You can use a logger or Home Assistant to save readings to CSV.
Best for: more control over data collection.
3. Home Assistant + a compatible energy-monitoring plug
Home Assistant records sensor history and can feed data into a database or automation that writes CSV files. This is usually the most flexible option for scheduled exports, long-term logging, and analysis in Excel or Python.
Best for: reliable, automated data collection without depending entirely on a manufacturer's cloud.
My recommendation
For a US outlet, I'd start with the Shelly Plug US Gen4. It's listed at $24.99 on Shelly's US store and supports power measurement. SONOFF S61s is another option worth investigating if you prefer a manufacturer's app with data-export features.
Shelly Plug US Gen4
$24.99
Shelly USA
Power monitoring; suitable for a Home Assistant-based CSV logger.
What your CSV could look like
You can log readings at one-minute intervals, for example:
Timestamp Power (W) Energy (kWh) 2026-10-17 08:00 145 0.0024 2026-10-17 08:01 152 0.0049 2026-10-17 08:02 148 0.0073 These are illustrative readings, not actual measurements. For meaningful results, record cumulative energy as well as instantaneous power, and retain timestamps.
One question that will help me narrow this down: How would you prefer to export the data?
Export a CSV directly from the plug's app
Automatically save readings to CSV on a computer or Raspberry Pi
Access the readings through an API and write my own Python script
Send readings to a cloud spreadsheet or database
Budget for the plug
Under $30
$30–$60
Flexible, prioritizing data access
[Find the best fit]
Sources cited in this answer1
Google AI ModeOct 17, 2026
Most mainstream consumer smart plug apps (like Kasa/Tapo or Govee) show nice energy graphs on your phone, but rarely offer a built-in "Export to CSV" button natively in the mobile app.
Depending on whether you prefer a turnkey app solution or don't mind a bit of tinkering, here are the best ways to tackle this:
- The Native Cloud Route (Shelly Devices)
- The Setup: Use a smart plug that features open cloud dashboards with native export support, such as a Shelly Plus Plug or other Shelly PM devices.
- How it works: You can log into the Shelly Cloud Portal or use their app interface, navigate to the power consumption charts, and use the direct export to CSV button. No coding required.
- The Local / Scripting Route (TP-Link Kasa / Tapo)
- The Setup: Kasa smart plugs with energy monitoring (like the Kasa EP25 ) are locally controllable via Python.
- How it works: You can use lightweight community tools like the Python-Kasa Get Energy CSV Script on GitHub . By running a simple script on your computer connected to the same network, it queries your plug and dumps the history directly into an
output.csvfile.
- The Smart Home Hub Route (Home Assistant)
- The Setup: Connect your preferred energy-monitoring smart plug (Zigbee, Z-Wave, Matter, or Wi-Fi) to a Home Assistant hub.
- How it works: Home Assistant tracks long-term statistics for energy usage. You can export history data straight from the built-in history dashboards to a CSV file (supported in recent HA releases), or pull data cleanly using their backend tools.
To help narrow this down, let me know:
- Do you already own a specific smart plug brand (like Kasa, Tapo, or Shelly)?
- Are you comfortable using a computer script / Home Assistant , or do you need a 100% plug-and-play mobile app?
Also asked as
- I want to track my energy usage with a smart plug, but I need to be able to export the data to CSV. What are my options?
