IEA 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 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 below. We have also compiled an FAQ list at the bottom of this page 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

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

How-to
• From the Data tab select Get Data on the ribbon and then proceed to From OData Feed option:
• Enter the URL of the category you are interested in and click OK and then on the Navigator dialog window you can search and find the subcategory that you are looking for and load all the data series in it. There is also an option to select multiple categories:
• Download and install the latest version of Microsoft Power Query following this link:
https://www.microsoft.com/en-us/download/details.aspx?id=39379
** Unless you are sure that you have a 64-bit installation of Excel, choose the 32-bit version of the install base.
• Check to be sure the Power Query Add-In is enabled. Access Excel Options from File > Options menu then navigate to Add-Ins tab, select COM Add-Ins from the Manage selection and click Go. On the COM Add-Ins dialog window check the Microsoft Power Query for Excel option and then click OK:
• Follow by selecting the From Other Sources > From OData Feed menu on Power Query
** Notice that you need to use the Power View tab and not the Data Tab in Excel 2010 and 2014. Power Query complies with the latest version of OData we currently use – that is OData V4.
• Enter the URL of the category you are interested in and click OK and then on the Navigator dialog window you can search and find the subcategory that you are looking for and load all the data series in it. There is also an option to select multiple categories: .
• From the Home tab select Get Data and then OData Feed. If it is not listed, then you can access it from the More menu item and then follow by selecting the Other category:
• Enter the URL of the category you are interested in and click OK and then on the Navigator dialog window you can search and find the subcategory that you are looking for and load all the data series in it. You also have the option to select multiple categories:

FAQ
Energy Information Administration publishes an impressive collection of data accompanied with features to view and access them. Data series can be downloaded one at a time. For more demanding use cases there is the API for software developers. All said, there is no intuitive option to easily connect and use this data set in major categories specifically in Excel and modern Business Intelligence platforms like Power BI. OilStat Data Connector bridges this gap. You can view and search for the categories you are looking for. All the series in the categories you selected then can be easily accessed with one query.
OData is a data access technology that utilizes existing Web protocols like HTTP to connect and query data. It has been formally standardized by major IT companies and is supported across multiple platforms and applications. This includes most of the Business Intelligence (BI) platforms, Excel and ERP systems. It is also noteworthy that you do not need any additional tweaks if your queries are done behind your corporate firewall. Connecting to OData is through HTTP which is the same way you view and navigate the Web.
No add-on is needed to access the data series. OData connection provider is built into Excel and most Business Intelligence platforms. There are also some Enterprise Resource Planning (ERP) systems that support connecting to OData data sources out of the box with no additional tools or configurations.
Our provider supports querying and previewing commands of a typical OData client which should be enough for most of the use cases. In more advance scenarios , you may need to filter or group the data. In this case, you need to load all the data and filter it with the functionality of the client software and do not rely on OData commands for this purpose.
At this time, you can access all data series in the data sets listed in access URL's above - with a count of around 1 million. Following remaining categories will be added in the near future: State Energy Data System, U.S. Electric System Operating Data and CO2 Emissions.
No, you don't. Your query will be applied against a cache repository that is not connected to the EIA data source directly. This repository updates nightly.
Please contact us with your feedback. We appreciate it and may be able to tweak and enhance our offering based on it.