CBAM Calculator Excel Template
Keep your workbook as the source of truth — download the starter template, or paste your sheet straight into the calculator.
Example value — check this week’s official EU ETS auction average
Share of emissions you buy certificates for, as EU ETS free allowances phase out.
| Goods | Category | Tonnes | tCO2e / t | Remove |
|---|---|---|---|---|
Intensities are editable examples — replace with your verified values or official defaults.
Estimation tool for planning and education only — not legal, tax or compliance advice. Official default values, certificate prices and methodology are published by the European Commission; always verify against the official sources before filing or pricing contracts. See data sources & methodology
About cbam calculator excel template
Plenty of exporters manage CBAM in a spreadsheet: one row per goods line, columns for tonnes and emissions intensity. That works until someone fat-fingers a formula or the certificate price column is three weeks stale.
Use this page either way: download the CSV starter template below (name, tonnes, tCO2e per tonne — the exact format the calculator parses), or copy a column from Excel and paste it directly. The math runs live, and the certificate price is a single visible input instead of a buried cell reference.
Frequently asked questions
What format should my spreadsheet be in?
One line per goods line with three fields: name, tonnes, tCO2e per tonne — comma, tab or semicolon separated. The parser skips anything it cannot read and tells you how many lines it skipped.
Can I keep using Excel and just check numbers here?
That is the intended workflow: maintain your workbook, paste the data here before sending a quote, and get an instant range with an up-to-date certificate price.
Is my data uploaded anywhere?
No. The calculator is a static page — parsing, math and the report all happen in your browser. There is no server-side form handler at all.
How accurate is the estimate?
The arithmetic is exact; the inputs carry the uncertainty. Certificate prices move weekly, intensities vary by installation, and rules evolve — hence the range and the disclaimers.
Is this legal or compliance advice?
No. It is an estimation and education tool. Official rules, default values and prices are published by the European Commission; verify before filing or contracting.