North American PPAs — Excel and CSV data file

What this file is

A register of the power purchase agreements announced for generating assets in the United States, Canada and Mexico since January 2024, as data you can filter, join and load into your own models. One row per agreement, each naming its buyer: the seller, where the asset is, the technology, capacity, tenor and structure where announced, and the sources.

Alongside the deals: every buyer and every seller with their deal counts, every company named with its type and home country, and a table of which company played which role in each deal.

Every value is as announced. A blank means the term was not announced, and nothing is estimated. Deal IDs are permanent and stay the same in every update.

What you receive

An Excel workbook with a Read me sheet that explains every column, plus the same tables as CSV files that load without cleaning. Deal IDs are permanent and stay the same in every update.

• Sherpa Data … 2024-2026.xlsx — The workbook: Read me, Deals, Deal parties, Buyers, Sellers, Companies
• deals.csv — One row per PPA: buyer, seller, asset country, state or province, technology, capacity, tenor, structure, sources
• deal_parties.csv — Which company played which role in which deal
• buyers.csv — Every buyer, with type, home country, website and PPA count
• sellers.csv — Every developer, IPP or seller, with its PPA count
• companies.csv — Every company named, with type, home country and website
• README.txt — Selection rule, joins, counting rules and field coverage

How complete each field is

• Buyer, date, country, technology: 100% filled
• Seller named: 99% filled
• State or province: 83% filled
• Capacity: 81% filled
• Second independent source: 67% filled
• Tenor: 40% filled
• Structure: 11% filled
• Disclosed value: 10% filled

Field guide

Deal ID

Permanent record number (NA0001…). Unchanged in every update.

Buyer(s) / Seller(s)

The buyer (offtaker) and the developer, IPP or seller, as named in the announcement.

Asset country / State or province

Where the generating asset is. State or province as the announcement states it.

Technology

Solar PV, onshore wind, nuclear, geothermal, hydro, storage, hybrid and so on.

Capacity

As announced for the contract or project (MW, MWac, MWdc or GW). Never converted.

Tenor / Structure

Contract length and structure (virtual, physical, sleeved) where announced.

Disclosed value / Value (USD m)

The value as announced, and in US dollars millions where it was announced in dollars.

Notes

Where a package and one of its contracts are both listed: do not add their capacities.

Source / Second source

The announcement the record rests on, and an independent report of the same agreement where one exists.

How this file was put together

• What is included — PPAs for generating assets in the United States, Canada and Mexico, first announced 1 January 2024 to 3 October 2026, that name a buyer.
• What is left out — Tolling and storage-service agreements, project completions, tenders, rumoured deals and deals mentioned only in passing.
• As announced, never estimated — A blank means the term was not announced. Capacities are never converted between units.
• Updates — Update plans receive a refreshed file with the same IDs and columns, and a list of records added, changed and removed.

Sources

Every record links to the announcement it rests on: company press releases, utility and regulator releases, and trade press. 179 of 268 also carry an independent second source. Data as at 30 September 2026.

Buy this data file

• Single file — $695: Today’s file, yours to keep.
• Annual updates — $995 per year: Today’s file, then a refreshed file each year. Billed yearly.
• Quarterly updates — $1,295 per year: Today’s file, then a refreshed file every quarter. Billed yearly.
• Europe + North America — $1,495: Both files today, yours to keep — this one and European PPAs, each with its own licence.

Licensing

Single-user licence covering the workbook and CSV files. For use by the named licensee only. Redistribution, resale, posting to shared drives or circulation beyond the named licensee is a breach of licence.