OPEN DATA · CSV
CSV downloads
Spreadsheet-ready copies of our price datasets. Open them in Excel, Google Sheets, LibreOffice, R or Python. Free to reuse under CC BY 4.0 with a credit to UtilityPrices.
Every file is UTF-8, comma-separated, with one header row and no comment lines. Units are in the column names (_p_per_kwh is pence per kWh, _p_per_day pence per day, _gbp_per_year pounds a year). Each row repeats its source_url and licence, so the provenance stays with the data when you copy rows elsewhere. Please credit “Data: UtilityPrices” with a link to the page named below; see licence and attribution.
Household price cap by region
One row per GB price-cap region: Direct Debit, single-rate electricity and gas unit rates and standing charges, with typical annual costs.
| Column | Meaning | First row |
|---|---|---|
region | Ofgem price-cap region name | East Midlands |
region_slug | URL slug used by the API and region pages | east-midlands |
effective_from | First day of the cap period (YYYY-MM-DD) | 2026-10-01 |
effective_to | Last day of the cap period (YYYY-MM-DD) | 2026-12-31 |
payment_method | Payment method the rates apply to | Direct Debit |
electricity_meter | Electricity meter type | Single rate |
electricity_unit_rate_p_per_kwh | Electricity unit rate, pence per kWh, including VAT where charged | 25.36 |
electricity_standing_charge_p_per_day | Electricity standing charge, pence per day | 51.45 |
electricity_vat_percent | VAT included in the electricity rates (0 during the temporary zero rate) | 0 |
gas_unit_rate_p_per_kwh | Gas unit rate, pence per kWh, including 5% VAT | 7.82 |
gas_standing_charge_p_per_day | Gas standing charge, pence per day, including 5% VAT | 29.41 |
gas_vat_percent | VAT included in the gas rates | 5 |
typical_electricity_kwh_per_year | Ofgem medium typical electricity use | 2500 |
typical_gas_kwh_per_year | Ofgem medium typical gas use | 9500 |
typical_electricity_cost_gbp_per_year | Electricity cost at typical use (UtilityPrices calculation) | 821.79 |
typical_gas_cost_gbp_per_year | Gas cost at typical use (UtilityPrices calculation) | 850.25 |
typical_dual_fuel_cost_gbp_per_year | Electricity plus gas at typical use | 1672.04 |
source_url | Ofgem source document | https://www.ofgem.gov.uk/sites/default/files/2026-08/17a-PDF-Cap-Tables.pdf |
licence | Licence and attribution terms | CC BY 4.0 (UtilityPrices); contains public sector information licensed under the Open Government Licence v3.0 (Ofgem) |
Licence column value: CC BY 4.0 (UtilityPrices); contains public sector information licensed under the Open Government Licence v3.0 (Ofgem).
Typical bill by payment method
Ofgem’s typical annual dual-fuel bill under the cap for each payment method, with the previous cap and the change.
| Column | Meaning | First row |
|---|---|---|
payment_method | Payment method as published by Ofgem | Direct Debit |
effective_from | First day of the cap period | 2026-10-01 |
effective_to | Last day of the cap period | 2026-12-31 |
typical_bill_gbp_per_year | Typical annual bill at medium typical use, rounded by Ofgem to the nearest pound | 1723 |
previous_typical_bill_gbp_per_year | Typical annual bill under the previous cap | 1663 |
previous_period | Dates of the previous cap | 1 July to 30 September 2026 |
change_percent | Change from the previous cap, rounded by Ofgem | 4 |
source_url | Ofgem source document | https://www.ofgem.gov.uk/sites/default/files/2026-08/Summary-of-changes-to-energy-price-cap-1-October-to-31-December-2026.pdf |
licence | Licence and attribution terms | CC BY 4.0 (UtilityPrices); contains public sector information licensed under the Open Government Licence v3.0 (Ofgem) |
Licence column value: CC BY 4.0 (UtilityPrices); contains public sector information licensed under the Open Government Licence v3.0 (Ofgem).
Business energy prices by consumption band
DESNZ average prices paid by UK non-domestic consumers, by fuel and annual consumption band, including and excluding Climate Change Levy.
| Column | Meaning | First row |
|---|---|---|
fuel | electricity or gas | electricity |
band | DESNZ consumption band; Average covers all bands | Very Small |
annual_consumption_mwh | Approximate annual consumption range, MWh, as printed by DESNZ | 0 - 20 |
price_excl_ccl_p_per_kwh | Average price paid, pence per kWh, excluding VAT and Climate Change Levy | 37.67 |
price_incl_ccl_p_per_kwh | Average price paid, pence per kWh, excluding VAT, including Climate Change Levy | 38.36 |
period_from | First day of the quarter | 2026-04-01 |
period_to | Last day of the quarter | 2026-06-30 |
status | DESNZ status for the quarter (provisional figures can be revised) | provisional |
published_at | DESNZ publication date | 2026-09-29 |
geography | Area covered | United Kingdom |
source_url | DESNZ source workbook | https://assets.publishing.service.gov.uk/media/6ab543da997a4b2950cceedc/table_341.xlsx |
licence | Licence and attribution terms | CC BY 4.0 (UtilityPrices); contains public sector information licensed under the Open Government Licence v3.0 (DESNZ) |
Licence column value: CC BY 4.0 (UtilityPrices); contains public sector information licensed under the Open Government Licence v3.0 (DESNZ).
Tips for using the files
- Price cap files are replaced when Ofgem announces a new cap; the business file with each quarterly DESNZ release. Use the date columns to label your charts and keep old copies if you need a time series.
- Regional rates are derived from Ofgem’s published annual cap levels, so they can differ from a supplier’s tariff by a fraction of a penny. Typical annual costs are our calculation: usage × unit rate + 365 × standing charge.
- Business prices are averages of what businesses paid across existing contracts, excluding VAT. Do not add a standing charge to them.
- Water bills are not available to download because their publishers’ terms do not allow republishing the data. Why →