Excel Add-in (Preview)

Live energy prices in your spreadsheet as refreshable formulas:

=OILPRICE.PRICE("BRENT_CRUDE_USD")

The add-in is in preview: it works today via a manifest upload, and setup takes about 2 minutes. You need an OilPriceAPI account and your API key (Dashboard → API Keys).

Install — Excel on the web (recommended, no install)

Works on any computer, ~2 minutes:

Download the add-in file: manifest.xml (right-click → Save link as… if it opens in the browser).
Open your workbook in Excel at office.com.
Home tab → Add-ins → More Add-ins.
My Add-ins tab → Upload My Add-in (top-left of the dialog).
Select the downloaded manifest.xml → Upload.
Click the OilPrice ribbon button, paste your API key, Save Key, then Test Key.
In any cell:
```
=OILPRICE.PRICE("BRENT_CRUDE_USD")
```

Install — Excel desktop on Windows

If your company uses Microsoft 365 (simplest — no scripts):

admin.microsoft.com → Settings → Integrated apps → Upload custom apps.

App type Office Add-in → Provide link to manifest file:

https://oilpriceapi.github.io/excel-energy-addin/manifest.xml

Assign to yourself (or your team), finish, and restart Excel. The add-in appears automatically (allow up to a few hours the first time).

Personal machine with admin rights: download and double-click install-windows.cmd, approve the administrator prompt, restart Excel, then Insert → My Add-ins → Shared Folder → OilPrice.

Install — Excel desktop on Mac

One line in Terminal, then restart Excel:

mkdir -p ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef && curl -fsSL https://oilpriceapi.github.io/excel-energy-addin/manifest.xml -o ~/Library/Containers/com.microsoft.Excel/Data/Documents/wef/oilprice-manifest.xml

Then Insert → My Add-ins → OilPrice (under Developer Add-ins).

Formulas

Formula	Returns
`=OILPRICE.PRICE("BRENT_CRUDE_USD")`	Latest Brent price
`=OILPRICE.PRICE("WTI_USD")`	Latest WTI price
`=OILPRICE.PRICE(A1)`	Price for the code in cell `A1` — recalculates when `A1` changes
`=OILPRICE.GET("/v1/prices/latest", "by_code=DIESEL_USD")`	Any API endpoint, spilled into cells
`=OILPRICE.CODES()`	Every supported commodity code

Commodity codes match the API — see the full commodity list for what your plan includes.

Troubleshooting

Blank task pane — close Excel fully and reopen; on the web, remove and re-upload the manifest.
#VALUE! from every formula — an old manifest may be cached. Re-download manifest.xml and repeat the upload.
Auth or quota errors in cells — the add-in surfaces plain worksheet messages for invalid key, quota, and plan-tier states; check your key and plan in the dashboard.
Anything else: email support@oilpriceapi.com — a human reads it.

Source

The add-in is open source: OilpriceAPI/excel-energy-addin — issues and feature requests welcome.