CSV Exports
Kevin Wanek avatar
Written by Kevin Wanek
Updated over a week ago

Data measured by all Emporia devices are available as CSV Exports if needing to work with the data outside of the Emporia Energy app. Those CSV downloads are available on-demand from within the app (steps available below). Once exported, a link will be sent to the email address connected to the Emporia account with a link to download the exported data. That link will download a .zip folder containing multiple files with each file corresponding to a different time resolution (seconds, mins, hours) of data.

How to Export?

  1. Select Menu (☰) in top left corner

  2. Select Export Raw Data to CSV under Settings

  3. Select the device you'd like to retrieve CSV data for, enter the desired date range, and select Export Data

  4. You will receive an email link (to your Emporia Account address) that will allow you to download a zip file to your computer that contains each of the following files for the time period you specified:

    • 1SEC (3 hours of 1 second data)

    • 1MIN (up to 7 days of 1 minute data)

    • 15MIN (Complete 15 minute data)

    • 1H (Complete hourly data)

    • 1DAY (Complete daily data)

Screenshots of the above process:

csv_menu_select.png

(Getting to the CSV Export Options and device select)

csv_date_select.png

(Date Selection for CSV Exported Data)

Screenshot_2022-10-10_092039.png

(Success! Can check email inbox for a download link to the exported file.)

What does an Export File look like?

Here's a brief overview of what an example Gen 2 CSV Export will look like.

mceclip1.jpg

Exports will provide kW data for the seconds, minutes and 15-min data. Exports will provide kWh (energy) in the hour resolution and higher.

Note for Gen 2 (and Gen 1) related exports: The most common question about the files themselves is having multiple columns after the Date/Time column labeled with "_1", "_2" and/or "_3" at the end of the column name. Those represent each of the "mains" sensors attached to the device (in ports A, B and/or C) and you should have a column for each 200A CT sensor attached to your mains.

Feedback and Suggestions

This knowledge base is pretty new for the Emporia team. Our goal is to provide all of the information we can to help you manage your energy in better ways. If this article wasn't helpful, or we could be more clarifying on any points please reach out to the Customer Support team and we'll certainly work to improve these guides.

Did this answer your question?