EIA Data Connector

OilStat.com introduces Data Connector for the data series published by the Energy Information Administration (EIA). Data sets can be accessed in Excel, Power BI and other business intelligence platforms or your business systems with no add-ons using already built-in data access methods.

Each data set can be accessed by a URL listed in the table below. To use these URL’s in Office 365 / Excel 2016, first select the Data Tab and then follow by clicking Get Data > From Other Sources > From OData Feed. Copy and paste the URL corresponding to the data set you are interested in from the the table below and then you can access all the subcategories and their data points. For complete instructions on how to use our connector including Excel 2013 , Excel 2010 or Power BI please refer to the How-to section. We have also compiled an FAQ list to provide you with more information about our connector.

Dataset URL
Petroleum
Natural Gas
Crude Oil Imports
Electricity
Coal
International Energy Data
International Energy Outlook
Short-Term Energy Outlook
Total Energy
Annual Energy Outlook 2020
CO2 Emissions
US Electrical System Operating Data
State Energy Data System (SEDS)
Drilling Productivity Report (DPR)
  DPR is not part of the core data set published by EIA. It is provided and updated separately.

Datasets from Other Sources

Baker Hughes Rig Count Report

* The above URL's cannot be used directly in Web browsers to view and access data sets. You need to follow the mentioned instructions to use them as OData data sources.

** All data is © U.S. Energy Information Administration. Please refer to the TOS for usage terms.