Petrol Price CSV Download overview
Accessing structured, machine-readable fuel price data is essential for financial analysts, logistics managers, application developers, and corporate research teams. The petrol price CSV download dataset provides historical and current South African fuel price adjustments in a standardized, tabular format suitable for automated ingestion, data modeling, and reporting.
As part of the broader fuel price data download South Africa framework, this page serves as a dedicated hub for acquiring historical pricing files, understanding underlying data structures, and connecting data pipelines to official South African fuel sources.
For quick reference or single-trip calculations, you can inspect live rates on petrol price today or estimate route costs using our calculate fuel cost tool.
Date range
The CSV dataset covers official monthly price adjustments gazetted by the South African government.
- Historical Depth: Monthly archive entries covering official adjustments over multi-year periods.
- Effective Date Alignment: Fuel prices in South Africa change officially on the first Wednesday of each calendar month. Every row in the dataset is anchored to its official effective implementation date (
YYYY-MM-DD). - Official Benchmark Reference: Sample Benchmark [Effective Date: 07 August 2024] — Inland 95 Unleaded Petrol: 2,271.00 c/l (R22.71/l); Coastal 95 Unleaded Petrol: 2,192.00 c/l (R21.92/l).
Products covered
The CSV dataset aggregates price structures across all primary refined fuel products sold at retail and wholesale levels in South Africa:
- Petrol 93 Unleaded (ULP) & LRP: Inland benchmark retail figures.
- Petrol 95 Unleaded (ULP): Coastal and Inland retail figures.
- Diesel 50ppm & 500ppm: Wholesale benchmark prices for low and standard sulfur diesel.
- Illuminating Paraffin (IP): Wholesale and maximum retail pricing.
- Liquefied Petroleum Gas (LPG): Maximum retail prices per kilogram.
Pricing is explicitly categorized into Inland (Magisterial District Zone 9C – Gauteng benchmark) and Coastal (Zone 1A) pricing zones to account for rail and pipeline transport differentials.
Source methodology
All figures in the petrol price CSV download dataset are verified against official government releases. The data hierarchy follows two primary authoritative bodies:
- Department of Mineral Resources and Energy (DMRE): The sole official regulatory authority issuing gazetted monthly fuel price adjustments and structural cost breakdowns.
- Central Energy Fund (CEF): The state corporation monitoring daily over- and under-recovery indicators based on international product prices and the USD/ZAR exchange rate.
Every dataset update undergoes automated schema checks and quarterly quality assurance (QA) audits to ensure strict mathematical integrity between line-item levies, Basic Fuel Price (BFP) components, and final retail or wholesale pump figures.
What the dataset includes
The dataset delivers a complete breakdown of South African fuel pricing mechanics rather than just top-line retail numbers. Each row provides line-item granularity into how final prices are calculated in South Africa.
Key components captured in the dataset include:
- Basic Fuel Price (BFP): The free-on-board (FOB) cost of importing refined petroleum products from international refineries, accounting for ocean freight, insurance, cargo dues, and storage.
- Fuel Taxes & Statutory Levies:
- General Fuel Levy (GFL): Tax collected on behalf of the National Treasury.
- Road Accident Fund (RAF) Levy: Statutory levy dedicated to third-party motor vehicle accident compensation.
- Customs & Excise Duty: Standard tariff applied to fuel imports and production.
- Margin & Distribution Costs:
- Wholesale Margin: Fixed margin allowed for fuel oil marketing companies.
- Retail Margin: Fixed margin allocated to service station operators (applicable to petrol).
- Zone Differential / Transport Costs: Cost of transporting fuel from coastal refineries via pipeline, rail, or road to inland pricing zones (e.g., Zone 9C Gauteng).
- Slate Levy: Variable adjustment mechanism used to absorb cumulative monthly under- or over-recoveries experienced by fuel suppliers.
Download formats and field definitions
The dataset is formatted in standard Comma-Separated Values (CSV) with UTF-8 character encoding, ensuring compatibility with Microsoft Excel, Google Sheets, Python Pandas, R, SQL databases, and enterprise resource planning (ERP) platforms.
Download format
- File Type:
.csv - Encoding: UTF-8
- Delimiter: Comma (
,) - Date Format: ISO 8601 (
YYYY-MM-DD) - Numeric Values: Unformatted numbers (no currency symbols or comma thousand separators) to simplify machine parsing.
Dataset schema and field definitions
| Field Name | Data Type | Units | Description |
effective_date | Date | YYYY-MM-DD | Date the price adjustment came into effect. |
pricing_zone | String | Code / Text | Geographic zone (Inland_9C, Coastal_1A). |
fuel_grade | String | Text | Specific fuel type (93_ULP, 95_ULP, Diesel_50ppm, Diesel_500ppm). |
bfp_cents_per_litre | Float | c/l | Basic Fuel Price component in cents per litre. |
fuel_levy_c_per_l | Float | c/l | General Fuel Levy component in cents per litre. |
raf_levy_c_per_l | Float | c/l | Road Accident Fund levy component in cents per litre. |
slate_levy_c_per_l | Float | c/l | Slate balance recovery levy in cents per litre. |
wholesale_price_c_per_l | Float | c/l | Official wholesale price in cents per litre. |
retail_price_c_per_l | Float | c/l | Official maximum retail price in cents per litre. |
retail_price_rand_per_l | Float | R/l | Converted retail price in Rand per litre (c/l / 100). |
Historical coverage and update frequency
Related history tables
South African fuel pricing updates follow a strict monthly schedule dictated by administrative review periods.
- Update Cadence: The CSV file is updated within hours of the official DMRE price announcement, which usually occurs on the Monday preceding the first Wednesday of each month.
- Monthly Adjustments vs. Daily Indicators: While the CSV dataset records confirmed gazetted figures, daily fluctuations are driven by international Brent Crude prices and the Rand/USD exchange rate. The daily movement tracked by the Central Energy Fund represents an over- or under-recovery balance that accumulates into the final monthly adjustment.
- Tracking Macroeconomic Factors: Historical datasets allow analysts to model the relationship between international oil prices, slate balance adjustments, and domestic fuel inflation over time.
API overview and integration options
For developers and engineering teams requiring real-time programmatic feeds rather than manual petrol price data download exports, our underlying data architecture integrates directly with the structured fuel price data API.
+----------------------------+
| DMRE / CEF Raw Data |
+----------------------------+
|
v
+----------------------------+
| Validation & QA Engine |
+----------------------------+
/ \
v v
+------------------+ +-------------------+
| CSV Export Hub | | REST Data API |
+------------------+ +-------------------+
Endpoints
GET /v1/fuel-prices/latest— Retrieves the current effective fuel price structures for all grades and zones.GET /v1/fuel-prices/history— Queries historical adjustments within a specified date range (?start=YYYY-MM-DD&end=YYYY-MM-DD).GET /v1/fuel-prices/download/csv— Programmatically fetches the latest consolidated CSV file.
Coverage
Full historical and active coverage for all official South African magisterial pricing zones, including Inland (Zone 9C) and Coastal (Zone 1A) benchmarks for 93 ULP, 95 ULP, Diesel 50ppm, Diesel 500ppm, and Paraffin.
Sample response
Below is an example JSON payload returned by the corresponding API endpoint, mirroring the structure found in the CSV download:
JSON
{
"effective_date": "2024-08-07",
"zone": "Inland_9C",
"fuel_grade": "95_ULP",
"pricing": {
"bfp_cents_per_litre": 1185.300,
"general_fuel_levy_c_per_l": 396.000,
"raf_levy_c_per_l": 218.000,
"slate_levy_c_per_l": 4.000,
"retail_price_c_per_l": 2271.000,
"retail_price_rand_per_l": 22.71
},
"currency": "ZAR",
"status": "Official Gazetted"
}
Update schedule
API endpoints and CSV download files are synchronized simultaneously following the publication of verified monthly fuel price schedules by the DMRE.
Use cases
- Fleet & Logistics Management: Automate monthly fuel expense revaluations and fuel-card limits across commercial fleets.
- ERP & Accounting Systems: Sync official wholesale and retail fuel prices into SAP, Oracle, or Sage for automated invoice matching.
- Financial Modeling & Analytics: Evaluate inflation drivers, transport sector input costs, and macroeconomic trends.
- Consumer & Industry Portals: Power real-time mobile apps, calculators, and news reporting tools.
Access & documentation
To request enterprise API credentials or access developer documentation, submit an inquiry through our dedicated data portal.
How to use the data
- Importing into Spreadsheets: Open Microsoft Excel or Google Sheets, select
Import > CSV, set the delimiter to comma, and ensure theeffective_datecolumn is parsed as ISO Date (YYYY-MM-DD). - Data Processing in Python: Use Pandas to load and analyze fuel price trends:Python
import pandas as pd # Load fuel price CSV dataset df = pd.read_csv('petrol_prices_sa.csv', parse_dates=['effective_date']) # Filter for Inland 95 Unleaded Petrol inland_95 = df[(df['pricing_zone'] == 'Inland_9C') & (df['fuel_grade'] == '95_ULP')] print(inland_95[['effective_date', 'retail_price_rand_per_l']].head()) - Unit Conversion Note: Retail and wholesale figures are provided in cents per litre (
c/l) to maintain precision with official gazetted schedules. Divide by100to convert to Rand per litre (R/l).
Related API, history and forecast pages
To navigate through our complete data suite, access these related resources across the site:
- Main Data Hub: Visit fuel price data South Africa for a complete overview of all dataset tools, historical tables, and system connections.
- Live Prices: Check petrol price today for immediate updates on active retail prices.
- Programmatic Access: Integrate with our fuel price data API for direct database links.
- Trip Cost Estimations: Use our calculate fuel cost calculator to project fleet and private travel costs.
Frequently asked questions
What should users expect from the petrol price CSV download page?
Users receive a structured, machine-readable dataset containing official South African fuel price histories, line-item tax breakdowns, and regional pricing zone differentials formatted for easy import into spreadsheets or analytics pipelines.
Which sources should the page reference?
The dataset references official monthly price publications from the Department of Mineral Resources and Energy (DMRE) and daily over/under-recovery indicators tracked by the Central Energy Fund (CEF).
Who is this page for?
This page is designed for software developers, financial analysts, fleet managers, logistics coordinators, and researchers who require verified South African fuel price data in structured CSV or API formats.
What is the next action?
You can download the sample CSV file directly, query our API documentation for direct integration, or use the online fuel tools to calculate current fuel costs.