Oil & Gas Dashboard in Google Sheets

The Oil & Gas Dashboard in Google Sheets ships with 6 linked tabs, 16 KPI cards, 18 pivot-driven charts and 15 native slicers. Every pivot, slicer and formula already reaches row 1,001, so you paste your own well records over the sample rows and the whole file recalculates. Setup takes under 10 minutes.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

The file opens with 500 rows of clearly labelled demo data — invented well records used only to populate the charts. They are not real production figures for any operator, basin or field. Delete them, keep the column headers, and the dashboard becomes your own reporting sheet.

🔑 Key Features of the Oil & Gas Dashboard in Google Sheets

📊 Four analysis pages, four KPI cards each. Overview carries Total Production (BOE), Total Revenue, Opex per BOE and Avg Uptime. Production carries Total BOE Produced, Avg Daily Rate, Crude Oil BOE and Remaining Reserves. Operations carries Avg Uptime, Total Downtime Hrs, Workovers and Shut-In Records. Financials carries Total Revenue, Total Opex, Netback and Opex Ratio.

🎛️ 15 native Google Sheets slicers. Overview filters on Month, Region, Product and Status. Production filters on Field, Product, Well Type and Month. Operations filters on Region, Downtime Cause and Status. Financials filters on Contract Type, Product, Region and Month. Clicking one slicer redraws every chart, pivot and Top 5 panel on that page.

🧮 Real pivot tables, not helper formulas. Each chart reads a pivot table parked to the right of its page, past a wide spacer column. Scroll right and you can inspect the exact numbers behind any chart — nothing is hidden in a formula chain, and the file stays fast as your log grows.

🔎 A Search tab that returns 18 fields. Pick a Well ID and the sheet prints Date, Region, Field, Product, Well Type, Segment, Revenue, Production (BOE), Opex, Opex per BOE, Daily Rate, Uptime %, Downtime Hours, Downtime Cause, Status, Contract Type and Month for that single record.

🎨 One-palette theming. The build uses a deep ink (#0B3954) against an orange accent (#FF7043) plus a cyan for second chart series. Edit the palette at the top of the Apps Script file and every header, card and chart restyles together.

📦 What’s Inside the Oil & Gas Dashboard

Page 1: Overview — Portfolio Performance

A portfolio-wide view across all basins, products and assets. Four KPI cards sit above six charts: Facility Uptime % by Segment (three gauges for Downstream, Midstream and Upstream), Revenue by Product, Opex per BOE vs Output, Monthly Production Volume, Revenue by Field and Reserves Depletion by Month. The right sidebar holds a Portfolio Snapshot, a 12-Month Revenue Trend, Top 5 Fields by Revenue, a Product Revenue Share bar list and an At a Glance table.

Page 2: Production — Field Output

Volumes, daily rates and operating cost by asset. Charts include Production by Field & Product, Avg Daily Rate by Month, Monthly Operating Cost and Production by Well Type. The sidebar ranks Top 5 Fields by Output and shows the Well Type Output Share across Deepwater, Offshore Shelf, Onshore and Shale, plus a per-region BOE list.

Page 3: Operations — Uptime, Downtime and Well Status

Charts include Downtime Hours vs Average Uptime (a combo of monthly downtime bars against an uptime line), Downtime Hours by Cause and Records by Well Status. The sidebar lists Top 5 Fields by Downtime and the Downtime Cause Share across Equipment Failure, Planned Maintenance, Pipeline Constraint and Weather. This page reports the downtime hours you log — it is a reporting view, not an HSE, well-integrity or reliability-engineering system.

Page 4: Financials — Revenue, Opex and Netback

Charts include Revenue by Month, Revenue by Contract Type, Operating Cost by Region, Revenue vs Opex by Field and Revenue by Region & Product. The sidebar ranks Top 5 Contracts by Revenue and shows Regional Revenue Share. Netback here is simply revenue minus the operating cost you enter — a management figure computed from your own inputs, not an audited or standards-based measure.

Page 5: Search — Well Record Lookup

Choose any Well ID from the dropdown and the Well Record Details panel prints the full 18-field record for that well — region, field, product, well type, segment, revenue, production, opex, daily rate, uptime, downtime cause, status and contract type.

Page 6: Instructions — User Guide

A 10-step guide covering the pivot-and-slicer architecture, how to clear a slicer, why the KPI cards stay unfiltered by design, how to replace the sample rows, the 1,000-row auto-expand limit and how to raise it, and how to re-theme the file.

Data sheet

One flat table behind everything, with columns for Well ID, Date, Month, Region, Field, Product, Well Type, Segment, Revenue, Production (BOE), Opex, Opex per BOE, Daily Rate, Uptime %, Downtime Hours, Downtime Cause, Status and Contract Type. Keep the headers and paste your own rows underneath.

📊 Oil & Gas Dashboard in Google Sheets vs. an Excel Dashboard vs. Paid Energy Analytics SaaS

For operators and analysts who want a clean production and cost view without a vendor implementation, the Oil & Gas Dashboard in Google Sheets sits in the sweet spot.

👥 Who This Template Is For — and Who It’s Not For

✅ This template is built for:

• Production and operations analysts at small to mid-size operators who report monthly volumes, uptime and opex
• Energy consultants and advisory teams who need a presentable client deliverable fast
• Finance teams tracking revenue, operating cost and netback by field, region and contract type
• Service companies and asset managers who want a shareable snapshot without buying an analytics platform
• Students and trainers teaching upstream metrics with a realistic, populated worked example

❌ This template is NOT for:

• Statutory or regulatory reserves reporting — it does not implement SEC or SPE-PRMS reserve definitions, and the reserves figures are simply the numbers you type in
• HSE, emissions or environmental compliance reporting — there is no emissions, flaring or incident module and no conformance claim of any kind
• Well integrity, SCADA or real-time surveillance — the file reads a manually maintained log, not live sensor feeds
• Commodity price forecasting, hedging or trading decisions — there is no price model and nothing here is trading or investment advice
• Teams needing SSO, audit trails or SOC 2 controls on their reporting layer
• Datasets beyond a few thousand rows, where a database and a BI tool are the right answer

⚙️ How to Use the Oil & Gas Dashboard

1. Open the PDF in your download and click the Google Sheets copy link to create your own editable copy in Drive.
2. Open the Instructions tab and read the 10-step user guide — it explains the pivot-and-slicer architecture in two minutes.
3. Go to the Data sheet, delete the 500 demo rows, and paste your own well records under the same column headers.
4. Keep the headers exactly as they are. Pivots, slicers and charts are bound to those names.
5. Return to Overview and click a slicer. Every chart, pivot and Top 5 panel on that page filters together.
6. Use Select all inside a slicer to clear it. Slicers are per-page, so each tab keeps its own filters.
7. Open the Search tab and pick a Well ID to read the full 18-field record for a single well.
8. Need more than 1,000 rows? Open the Apps Script file, raise DATA_ROWS, and re-run main().
9. Share the Drive link with your team, or use File then Download to export a PDF for a monthly pack.

💼 Real-World Use Cases

Daniel is a production analyst at a 60-person independent operator. He maintains one monthly log of well records and uses the Oil & Gas Dashboard in Google Sheets to show which fields moved volumes, where opex per BOE drifted, and how uptime tracked across Upstream, Midstream and Downstream — replacing three hand-built spreadsheets he used to rebuild every month.

Priya runs an energy advisory practice with four consultants. She copies the template per client, pastes their production log in, and delivers a filtered Overview and Financials pack the same day — no platform licence, no implementation call, and the client keeps the file afterwards.

Marcus teaches an upstream economics module. He hands students the populated demo file so they can see how netback, opex ratio and daily rate interact before they build anything of their own, and the Instructions tab means he does not spend the first session explaining the mechanics.

❓ Frequently Asked Questions

What KPIs does the Oil & Gas Dashboard in Google Sheets track?

The Oil & Gas Dashboard in Google Sheets tracks 16 KPI cards across four pages: total production in BOE, total revenue, opex per BOE, average uptime, average daily rate, crude oil BOE, remaining reserves, total downtime hours, workovers, shut-in records, total opex, netback and opex ratio, plus revenue per BOE and netback margin.

Is the sample data real production data?

No. The Oil & Gas Dashboard in Google Sheets ships with 500 rows of invented demo records covering fictional fields such as Ironwood and Delta Sands. They exist only so the charts are populated when you open the file. Replace them with your own records before using the dashboard for anything real.

How long does setup take?

Under 10 minutes. Click the copy link in the PDF, delete the demo rows on the Data sheet, paste your own well records under the same headers, and every pivot, slicer and chart in the Oil & Gas Dashboard updates automatically. No add-ons, macros or scripts to configure.

Can I use this for regulatory reserves or emissions reporting?

No. The Oil & Gas Dashboard in Google Sheets is a management reporting template fed by your own numbers. It does not implement SEC or SPE-PRMS reserve definitions, carries no emissions or HSE module, and makes no compliance or conformance claim. Use your official systems for statutory filings.

How does this compare to Enverus or Quorum?

Those platforms are full energy data suites with vendor implementation and annual contracts. The Oil & Gas Dashboard in Google Sheets is a $9.99 one-time reporting file you own outright and can edit freely. It covers monthly production, uptime, cost and netback reporting, not subsurface modelling or land management.

How many rows can the dashboard handle?

Pivots, slicers and every formula already cover 1,000 data rows, so you can paste up to row 1001 with no edits at all. To go further, open the Apps Script file, raise the DATA_ROWS value and re-run main() — the whole dashboard rebuilds at the new size.

Do I need Excel or any add-on?

No. The Oil & Gas Dashboard in Google Sheets runs entirely in Google Sheets in any modern browser. It uses native pivot tables, native slicers and standard SUMIFS, COUNTIFS and AVERAGE formulas — no add-ons, no macros and no monthly subscription.

👤 About the Author

Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PK-AnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

Working across the wider energy and industrial estate? Pair this with the Power Generation Dashboard in Google Sheets for generation and load reporting, or the Chemical Manufacturing Dashboard in Google Sheets for downstream plant output. The Renewable Energy Dashboard in Google Sheets and Steel & Metals Dashboard in Google Sheets round out an energy-transition reporting pack.

Also available as: a broader industry view in the Oil and Gas Analysis Dashboard in Google Sheets, plus Excel and Power BI editions. Browse the full Google Sheets Dashboard templates collection for more.

📖 Click here to read the Detailed Blog Post<

Watch the step-by-step video Demo:

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

📅 Last updated: August 2026