I need a smart plug that monitors energy usage and exports data to CSV.

If you want a smart plug that monitors energy usage and lets you pull that data into a CSV file, you have a couple of stellar, user-friendly options that don't require an advanced engineering degree to extract your data.

Top Recommendations

Add to list

• Why it fits: Shelly devices are locally controllable and feature robust cloud dashboards. The Shelly Smart Control Web Interface features a direct Export to .csv button right on their power consumption charts.
• Data Access: You can view real-time data, expand the consumption graphs to full screen, select your custom date/time intervals, and instantly download the CSV. No cloud subscription or extra software is required.

Add to list

• Why it fits: TP-Link’s Tapo app includes built-in energy monitoring dashboards (v2.0+) that natively support clearing and exporting all energy usage data locally from the app settings without forcing a factory reset.
• Data Access: If you prefer programmatic or deeper automation access, community tools like the Python Kasa Gist Script or third-party companion apps like Watt App can pull consumption data straight into formatted CSV/Excel files.

Add to list

• Why it fits: Excellent physical hardware supporting the modern local-first Matter standard. While the native Meross app handles history, pairing it with a local smart home platform like Home Assistant lets you easily log and export long-term statistics into CSV format.

Would you prefer a plug that works entirely locally via a web browser/app (like Shelly), or are you already using a smart home system like Home Assistant or Apple HomeKit where the data can be exported on the backend?

Yes. If CSV export is a hard requirement, I’d narrow the field considerably.

Best options

• Shelly Smart Plug Gen 4 - $24.99 (Micro Center)

1. Shelly Plug US Gen4 — my top pick. It measures power consumption and has a strong ecosystem for getting data out. Most importantly, Shelly's software supports exporting consumption data as CSV; Shelly documents an “Export .csv” function for its consumption history.

• Kasa Matter Smart Plug with Energy Monitoring - $79.99 (newegg.com)

2. TP-Link Kasa/Tapo + Watt app — best if you want simple phone-based CSV export. The third-party Watt for Smart Devices app explicitly supports energy-monitoring Kasa and Tapo plugs and can export chart datasets to CSV. Supported plugs include Kasa KP125/KP125M and Tapo P110/P115/P125M.

• Eve Smart Plug & Power Meter - $39.95 (B&H Photo)

3. Eve Energy — good Apple/HomeKit-oriented choice. It provides energy consumption monitoring, although I'd put it behind Shelly/Kasa if CSV export is the primary requirement.

What I'd buy

If you want “plug it in → monitor watts/kWh → periodically download CSV”, I'd choose Shelly Plug US Gen4.

If you want something cheap and straightforward, a Kasa/Tapo energy-monitoring plug + Watt app is compelling because the CSV export is explicitly documented.

If you tell me iPhone vs Android, Wi-Fi vs Matter/Zigbee, and your budget, I can narrow this to the best 1–2 plugs for you.

Most mainstream consumer smart plugs (like TP-Link Kasa Go to product viewer dialog for this item. or Govee Go to product viewer dialog for this item. ) track energy usage inside their respective mobile apps, but none of them natively offer a direct "Export to CSV" button right out of the box. Manufacturers usually keep data locked in their apps or cloud ecosystem.

To get your energy data into a CSV file, you have three main paths depending on your technical comfort level:

• Emporia Smart Home Ecosystem (Easiest Native Export): While Emporia is better known for whole-home monitors, they do offer smart plugs and explicit on-demand CSV data exports emailed directly to you via the Emporia Energy Help Center . It is the closest thing to a native consumer plug ecosystem with direct spreadsheet support.
• TP-Link Kasa + Python Script (For Tinkerers): TP-Link Kasa energy-monitoring plugs (like the Kasa Smart Wi-Fi Plug Slim Go to product viewer dialog for this item. ) locally broadcast data that can be pulled. Tech-savvy users often run local scripts (such as the Python-Kasa GitHub Snippet ) to query the switch on your local Wi-Fi and dump consumption stats straight into a CSV.
• Home Assistant (The Ultimate Permanent Setup): Pairing almost any local energy-monitoring smart plug (like Kasa or Shelly) with a Home Assistant hub gives you a dedicated energy dashboard. Home Assistant natively lets you pull historical logs for any time period and download the device data cleanly.

To help narrow down the best setup for you, tell me:

• Are you comfortable using a local smart home hub (like Home Assistant) or a script , or do you need a strictly plug-and-play mobile app?
• What app/ecosystem (Alexa, Google Home, Apple Home) are you already using?

If CSV export is a hard requirement, I’d narrow it to these two:

• Shelly Plug US Gen4 - $24.99 (Best Buy)
• Meross Matter Smart Plug with Energy Monitor - $52.99 (Meross Official Store)
• Eve Energy Matter Smart Plug - $39.95 (Eve)

My pick: Shelly Plug US Gen4

• Shelly Plug US Gen4 - $24.99 (Best Buy)

• Energy monitoring: Yes, including consumption measurements.

• CSV export: Yes. Shelly's interface provides an Export CSV function for consumption data.

• U.S. plug: Yes; rated up to 15 A / 1,800 W.

• Connectivity: Wi-Fi, Bluetooth, Zigbee and Matter.

• Good choice if: You want relatively inexpensive plugs and want straightforward access to the data rather than being locked into a proprietary ecosystem.

• Bonus: Shelly integrates with Home Assistant, giving you another way to collect/process the measurements.

Another strong option: Emporia Smart Plug

Emporia is particularly attractive if energy-data analysis is your main priority. Its Smart Plug measures real-time watts and cumulative kWh, and Emporia explicitly supports CSV exports from its app.

The important caveat is that Emporia's export is cloud/app-based: you select the device and date range, then receive a download link by email. It can provide 1-second, 1-minute, 15-minute, hourly and daily CSV data, with different retention periods.

What I'd buy

For maximum flexibility: Shelly Plug US Gen4 For easiest energy-data reporting/CSV workflow: Emporia Smart Plug

If you tell me your budget and whether you want 1 plug or several, I can narrow this to the best 2–3 options and compare CSV format, data granularity, local/API access, Home Assistant compatibility, and current price.

Yes. I found two especially good options if CSV export is a hard requirement:

🥇 Best overall: Shelly Plug US Gen4

Shelly Smart Plug Gen 4

$24.99

• Measures power consumption, voltage, and current.
• Direct CSV export is built into the Shelly interface.
• US 15A/1800W-class plug.
• Wi-Fi, Bluetooth, Zigbee, and Matter support.
• Particularly good if you want to eventually automate or process the data yourself.

🥈 Best for detailed historical energy data: Emporia Smart Plug

The Emporia Smart Plug measures real-time watts, voltage and cumulative kWh, and Emporia explicitly supports CSV exports.

Its CSV system is unusually good for analysis: exports can include 1-second, 1-minute, 15-minute, hourly, and daily data, depending on the retention period.

One caveat: Emporia is more cloud-dependent; it currently doesn't provide a public API or local device access.

My recommendation

If your goal is “plug it in → collect energy data → periodically download CSV → analyze it in Excel/Python”, I'd choose Shelly Plug US Gen4.

If your priority is long-term energy monitoring and very detailed historical CSV data, choose Emporia.

I would not buy a Kasa/Tapo/Meross plug solely for this requirement unless you verify the exact model's export capability—the apps often provide energy graphs/history without offering a straightforward CSV export.

If you tell me your budget and what appliance you're monitoring (e.g. refrigerator, PC, heater, EV charger), I can narrow it down to the best 2–3 plugs and current prices.

Finding a smart plug with native, straightforward CSV data export can be tricky, as most manufacturer apps prefer to trap your data in basic graphical UI charts . However, a few hardware options and ecosystem combinations handle data exporting smoothly.

Top Hardware & Software Choices for CSV Export

• Shelly Plus Plug S / Shelly Smart Control App : Shelly devices are local-control power champs . Through the Shelly Cloud Control Web Portal or their app interface, power consumption charts feature a direct Export to CSV button for granular time segments.
• Emporia Smart Plug : Emporia provides robust energy hardware . Their app supports a clean raw data export feature (Menu > Export Raw Data to CSV ) allowing you to select specific devices, set custom date ranges, and receive a compiled dataset via email.
• TP-Link Tapo / Kasa + Home Assistant or Python Scripts : While Tapo/Kasa apps don't natively let you tap a button to download a spreadsheet, the plugs themselves log accurate stats . Many users pull data seamlessly by pairing them with Home Assistant (which exports history to CSV/Excel easily) or by using lightweight community Python Kasa Scripts to dump consumption stats straight into a local .csv file.
• Eve Energy (Apple Home / iOS) : If you operate within an Apple ecosystem, the modern versions of the Eve app support direct data downloads into spreadsheet-ready formats if you prefer staying local/ecosystem-tied.

To help narrow down the best plug for your setup, let me know:

• Do you prefer a standalone mobile app that exports directly, or are you open to using a hub like Home Assistant or a script?
• What kind of Wi-Fi / smart home ecosystem (Alexa, Google Home, Apple Home) are you currently using?

Finding a smart plug that natively offers a direct "Export to CSV" button in its consumer mobile app can be surprisingly tricky, as most plug ecosystems lock your data behind their graphical interfaces. However, you have a few solid hardware options with direct export features, plus local-control methods that make data logging and exporting trivial.

One of the best off-the-shelf options for data ownership. Using the official Shelly Smart Control app or their web interface (control.shelly.cloud ), the power consumption charts feature a direct Export to CSV button. They also support local HTTP APIs if you want to pull data programmatically.

A popular budget-friendly Wi-Fi smart plug with reliable power monitoring. Its companion eWeLink app records up to 100 days of historical power consumption data and natively supports exporting that data.

Eve Energy : If you are in the Apple Home ecosystem, the Eve app for Eve Energy plugs supports downloading and exporting historical energy and cost data directly into spreadsheet formats.

While Tapo and Kasa apps don't give you a clean export button out of the box, these are the most accurate and responsive plugs for local automation setups. Enthusiasts commonly use lightweight open-source Python scripts (like python-kasa ) to pull statistics straight to CSV, or route them into Home Assistant which logs everything to a database and allows effortless data downloading.

To help narrow down the best choice, tell me:

• Do you prefer a cloud app with a built-in export button (like Shelly or Sonoff), or are you open to using a local hub / script?
• What smart home ecosystem (Alexa, Google Home, Apple Home, Home Assistant) do you use?

Yes. The best fit I found is the Shelly Plug Gen4 because it combines energy monitoring with native CSV export rather than requiring a separate data platform.

Shelly Plug Gen4 15A 1800W Smart Plug with Power Measurement

$24.99

Why I’d pick it

• Measures energy consumption as well as power.
• CSV export is built into Shelly's interface: its consumption chart can be exported directly as .csv.
• Wi-Fi, Bluetooth, Zigbee and Matter support, so you're not locked into one ecosystem.
• Rated up to 15 A / 1,800 W, making it suitable for typical household appliances.
• Around $25 in current listings.

If you want more advanced analysis, Shelly + Home Assistant is an even better setup: Home Assistant can collect the plug's long-term energy statistics and export them as CSV, giving you much more control over date ranges and data processing.

Shelly Plug Gen4

$24.99

Shelly Plug US Gen4

$24.99

ThirdReality Smart Plug Gen2

$38.99

SONOFF S31

$21.51

Bottom line: If "plug it in → monitor usage → download CSV" is the key requirement, I'd buy the Shelly Plug Gen4. The direct CSV capability is the important differentiator here.

If you tell me whether you want Wi-Fi only, no cloud, Home Assistant compatibility, or the cheapest option, I can narrow it down further.

Very few mainstream consumer smart plugs natively let you tap a button in a mobile app and export raw historical data straight to a CSV file without a paid cloud subscription or a home automation hub . This is because standard smart plugs don't have massive internal onboard storage, meaning data collection and logging are usually handled via manufacturer cloud servers or local software.

The most reliable setups to monitor energy usage and get your data into a CSV format involve pairing energy-monitoring smart plugs with specific apps or local platforms.

Native App Export (Cloud/Paid)

• Shelly Plus Plug S Go to product viewer dialog for this item. / Shelly Plug S Gen3 Go to product viewer dialog for this item. : One of the most open consumer plugs available. You can view real-time and historical power consumption via the Shelly Smart Control app or web portal (control.shelly.cloud ), which includes a native Export to CSV feature for consumption charts.
• Tuya / Smart Life Compatible Plugs : Many generic and branded energy-monitoring plugs run on the Tuya/Smart Life ecosystem. Tuya supports data exporting via their app, though exporting historical logs sometimes requires opting into their energy-saving cloud membership tier.

Local Hub & Open-Source Options (Best for Data Hoarders)

• Home Assistant + Local/Wi-Fi Plugs (Shelly Go to product viewer dialog for this item., TP-Link Tapo P110M Go to product viewer dialog for this item. , or Kasa KP115 Go to product viewer dialog for this item.) : If you route local energy-monitoring plugs through a hub like Home Assistant , it permanently logs long-term statistics for voltage, wattage, and cumulative kWh. Home Assistant includes built-in tools to export historical states and energy data directly to a CSV/spreadsheet file.
• TP-Link Kasa Go to product viewer dialog for this item. (e.g., KP115 or EP25 Go to product viewer dialog for this item. ) + Python Scripts : Kasa plugs track energy exceptionally well, but their official app won't let you natively export it. However, because the community has built open-source tools (like the python-kasa library), users regularly run quick local scripts to pull usage statistics straight into a local .csv file.
• Tasmota / ESPHome Flashed Plugs : Tech-forward users often use smart plugs flashed with open-source firmware paired with tools like Prometheus or Grafana to export continuous, second-by-second metrics locally without relying on manufacturer apps.

Would you prefer a plug with a native app export (like Shelly) or are you open to using a local smart home hub/script for unlimited free CSV data logging?

If CSV export is a hard requirement, I’d narrow it to these:

Shelly Plug US Gen4

$24.99

Meross Matter Smart Plug

$52.99

SONOFF S31 Energy Monitoring Plug

$20.90

Eve Smart Plug & Power Meter

$69.95

My pick: Emporia Smart Plug

The Emporia Smart Plug is the strongest match if you want energy monitoring + straightforward CSV exports. Emporia explicitly supports exporting device data as CSV, with selectable date ranges and resolutions including 1-minute, 15-minute, hourly, and daily data.

One important caveat: Emporia's 1-minute data is retained for only 7 days, while 15-minute data is retained for a year; if you need high-resolution historical data, you'd want to export regularly.

If you want local/API access: Shelly Plug US Gen4

The Shelly Plug US Gen4 is particularly attractive if you're comfortable with Home Assistant or APIs. It has built-in power monitoring and supports local connectivity, and Shelly's ecosystem can export power-consumption data to CSV. Community users also report using Shelly's API for customized CSV collection.

Bottom line:

• Easiest CSV workflow: Emporia Smart Plug
• Best for local control/custom data collection: Shelly Plug US Gen4
• Don't assume every energy-monitoring plug exports CSV—many only provide graphs or app-level history.

If you tell me your budget and whether you need 120V US plugs, I can narrow this to the best 2–3 options.