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.

Follow these steps to instantly access thousands of energy data series in Office 365 / Excel 2016 :

1 Select Data Tab.
2 Navigate to Get Data > From Other Sources > From OData Feed.
3 Copy a URL link from the list below matching the dataset your are interested in exploring.
4 Paste the link in and click OK. You can now view all top-level categories and load hundreds of data points in each.

For complete instructions on how to use our connector in other platforms including Excel 2013 , Excel 2010 and 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.

Starting September 2020, you need an access key to use EIA Data Connector full functionality. Your Free access key allows you to query up to four categories per month. We also provide two paid subscription tiers - Pro and Enterprise - for usres who need premium access to our connector. See Pricing page for options. Following URL’s with no access key would only return a limited number of rows for evaluation purposes. Please login / register to view them with your unique key embedded.

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 2021
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
OPEC MOMR (Monthly Oil Market Report)
OPEC ASB (Annual Statistical Bulletin)
BP Statistical Review
OECD
JODI (Joint Oil Data Initiative)

* 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.