Search results
Access EIA data — right in your spreadsheet; You can download EIA energy data (and economic data from the St. Louis Federal Reserve (FRED)) directly to your spreadsheet for charts, graphs, and tables. Version 2.1.0 was released March 30, 2023. Microsoft Excel Add-Ins
- Documentation
(Optional, but required to receive data values) For the...
- Register
Energy Information Administration - EIA - Official Energy...
- Forgot API Key
Energy Information Administration - EIA - Official Energy...
- Faq's
Does EIA have data on the movement (transport) of crude oil,...
- API Terms of Service Agreement
You may use the EIA API to develop a service to search,...
- Widgets
To embed a visualization: Use any of the following EIA data...
- Total Energy
Energy use fell during 2020 in all U.S. states except Alaska...
- Bulk Download Facility
The U.S. Energy Information Administration is committed to...
- Documentation
- EIA Add-In Installation Instructions
- Sion 4.1
- Sion 4.0
- Version 3
Open Microsoft Excel and click on the File menu button in the upper left-hand corner of the window.Choose Options from the menu.On the left side of the window choose Add-Ins.Implemented 1date feature allowing for cleaner worksheets and easier data manipulation.Created buttons for the "data sort" feature from version 4.0, and the new "1date" feature.The EIA Add-in now has the ability to handle hourly series'.Charting has been improved to allow full functionality with the new featuresVersion/duplicate detection added for registered/installed EIA add-ins.Implemented new vertical and horizontal data display options.Implemented new sort data function.Allow changes to start date for the individual series.Series ID search fixed allowing for more accurate results.Browse Data and Data Search display refined for better usability. Differentiating selected series on open forms allowing for users to see what they have selected.Added "+" signs to Browse data form display to allow for a windows explorer feel to navigation.Add-In update prompt added to alert user when a new version is available.• Detailed data files in Excel format • Web applications that allow the public to interact with and visualize EIA’s electricity data • Wholesale daily electricity price index data for selected price hubs
- 275KB
- 18
Mar 5, 2020 · Export data easily. EIA’s international information is easily downloaded as data, maps, and charts for presentations, reports, and spreadsheets. Data downloads are available in CSV and JSON formats.
Open the EIA_2016_Company_Level_Imports file. There are four sheets in this workbook. The documentation notes the source of the data, the IMPORTS sheet contains 20 columns and 24618 rows, totaling to 492,360 individual points of data.
Sep 2, 2023 · # Fetch data from the EIA API my_data = eia. get_data (route, data_param, frequency = frequency, start_date = start_date, end_date = end_date, facet_name = facet_name, facet_values = facet_values) # Save the retrieved data to an Excel file named 'my_data' eia. save_to_excel (my_data, 'my_data') # Filter the data to select only records where ...
People also ask
How do I download data from EIA?
What is the EIA API?
What data formats are available in EIA?
Is EIA data free?
The EIA-906, EIA-920, EIA-923 and predecessor forms provide monthly and annual data on generation and fuel consumption at the power plant and prime mover level. A subset of plants, steam-electric plants 10 MW and above, also provides boiler level and generator level data.