Guru's Verification engine ensures consistency, confidence, and trust in the knowledge your organization shares. Learn more.

EIA Electricity Instructions

Procedure

Step 1) Go to https://www.eia.gov/electricity/data/browser/#/topic/7?agg=0,1&geo=vvvvvvvvvvvvo&endsec=vg&freq=Q&charted=1

Step 2) In 'Change data set', choose 'Average Retail Price of Electricity'

In 'View a pre-generated report', choose item 5.6 (Average Retail Price of Electricity to Ultimate Customers by End-Use Sector, by State)

Step 3) Choose the 'Monthly' time span

Make sure to drag the date ALL THE WAY to the right to the left, select Jan 2015, in order to display the most recent data

image.png

Step 4) Click on 'DOWNLOAD' and then on 'Table (CSV)'

image.png

Step 5) Open the downloaded spreadsheet if it looks like the one bellow, continue to Step 6)

image.png

If it looks like the one bellow (all data in the first column), click on the following link:

EIA Correction Electricity

image.png

Step 6) Select all data starting from cell 'C5' (the whole table, to the bottom and to the right) and copy it

image.png

Step 7) On the collection spreadsheet, paste the data on cell 'A9'

You must have Author or Collection Owner permission to create Guru Cards. Contact your team's Guru admins to use this template.