Columns
All columns below must be present in the sheet.
Column | Required | Description |
ref_id | Yes | Unique identifier |
type | Yes |
|
quantity | Either this or percentage_reduction | Energy covered |
unit | Yes | Unit for quantity, for example |
percentage_reduction | Either this or quantity | Share covered, as a decimal from 0 to 1 |
issued_at | Yes | Issue date (YYYY-MM-DD) |
effective_from | Yes | Coverage start (YYYY-MM-DD) |
effective_to | Yes | Coverage end (YYYY-MM-DD) |
country_of_purchase | Yes | Two-letter country code |
tags | Yes | What the instrument applies to, in |
provider | No | Provider name |
purchase_group_name | No | Group name for related purchases |
project_name | Yes | Project name |
renewable_source | No | For example wind or solar |
Key: ref_id
Example
ref_id | type | quantity | unit | percentage_reduction | issued_at | effective_from | effective_to | country_of_purchase | tags | provider | purchase_group_name | project_name | renewable_source |
rec-2025-us-01 | unbundled_eac | 1500 | MWh |
| 2025-02-15 | 2025-01-01 | 2025-12-31 | US | country:US | Example Energy | FY25 RECs | Prairie Wind | wind |
ppa-denver-2025 | ppa |
| MWh | 0.94 | 2025-01-01 | 2025-01-01 | 2025-12-31 | US | facility:denver-office | Example Utility |
| Front Range Solar | solar |
Rules
Fill in
quantityorpercentage_reductionon each row.Enter percentages as decimals:
0.94for 94%.In
tags, usetype:nameand separate multiple targets with a semicolon, for examplefacility:denver-warehouse;facility:denver-office.To apply an instrument to a single activity, use
activity:<activity ref_id>, for exampleactivity:denver-office-electricity.Activity ref_ids and tag names referenced here can't contain a colon or semicolon, because those characters separate the values in this column.