Get Diesel Prices Directly in Excel
Install our free Excel add-in and get real-time diesel prices with simple formulas. No coding required.
Quick Start (2 Steps)
Install Add-in
Click the link below to install the Energy Price Comparison add-in from Microsoft AppSource (Office Store).
Install NowUse Formulas
Type formulas like =DIESEL_PRICE("CA") to get live prices.
Get State Diesel Price (FREE)
Use the DIESEL_PRICE function to get current diesel prices for any US state:
Formula:
Result:
Compare All 50 States
Build a spreadsheet that compares diesel prices across states:
| Column A | Column B | Column C |
|---|---|---|
| State | Formula | Price |
| California | =DIESEL_PRICE("CA") | $4.86 |
| Texas | =DIESEL_PRICE("TX") | $3.42 |
| Florida | =DIESEL_PRICE("FL") | $3.75 |
Build a Fleet Fuel Cost Calculator
Calculate total fuel costs for your fleet across different states:
Track Price Changes Over Time
Manually record prices each week to build a historical dataset:
| Date | CA Price | TX Price | Difference |
|---|---|---|---|
| Dec 15, 2025 | =DIESEL_PRICE("CA") | =DIESEL_PRICE("TX") | =B2-C2 |
| Dec 8, 2025 | $4.82 | $3.38 | $1.44 |
| Dec 1, 2025 | $4.79 | $3.35 | $1.44 |
Perfect For...
Fleet Managers
Track diesel costs across routes, calculate fuel budgets, and optimize refueling strategies.
Financial Analysts
Build financial models, forecast fuel costs, and analyze diesel price trends in Excel.
Business Owners
Monitor fuel expenses, compare regional prices, and make data-driven decisions.
Get Diesel Prices by State
Click any state to see current prices and get Excel formula examples:
Alabama
Formula: =DIESEL_PRICE("AL")
View prices →
Alaska
Formula: =DIESEL_PRICE("AK")
View prices →
Arizona
Formula: =DIESEL_PRICE("AZ")
View prices →
Arkansas
Formula: =DIESEL_PRICE("AR")
View prices →
California
Formula: =DIESEL_PRICE("CA")
View prices →
Colorado
Formula: =DIESEL_PRICE("CO")
View prices →
Connecticut
Formula: =DIESEL_PRICE("CT")
View prices →
Delaware
Formula: =DIESEL_PRICE("DE")
View prices →
Florida
Formula: =DIESEL_PRICE("FL")
View prices →
Georgia
Formula: =DIESEL_PRICE("GA")
View prices →
Hawaii
Formula: =DIESEL_PRICE("HI")
View prices →
Idaho
Formula: =DIESEL_PRICE("ID")
View prices →
Add-in Features
✅ Simple Formulas
Use Excel formulas you already know. No VBA or macros required.
🔄 Auto-Refresh
Prices update automatically when you open the spreadsheet or manually refresh.
🌐 Works Offline
Last fetched prices are cached, so your spreadsheet works even without internet.
💾 Export Data
All data stays in Excel. Export to CSV, PDF, or any format Excel supports.
🔐 Secure
Your API key is stored securely in Excel. Data is fetched directly from our API.
🆓 Free Tier
State averages are free with unlimited queries. No credit card required.
Frequently Asked Questions
Do I need an API key?
Yes, but state-level diesel prices are free with unlimited queries. Sign up for a free API key and enter it in the add-in settings.
Which Excel versions are supported?
The add-in works with Excel 2016 and later, Excel for Microsoft 365, and Excel Online (web version).
Can I get station-level prices in Excel?
Currently, the add-in supports state-level averages (free). Station-level pricing requires the Python or Node.js SDKs. We're working on adding this to Excel.
How often do prices update?
State averages update weekly from EIA data every Monday. The add-in automatically fetches fresh data when you open Excel.
Ready to Get Started?
Install the add-in and start getting diesel prices in Excel today