Overview
This article covers the file format used by Pledge to import externally calculated emissions data pertaining to shipment-level freight. This allows for the inclusion of emissions provided by suppliers, even when detailed shipment activity data is unavailable, enabling users to maintain a comprehensive view of their transport emissions inventory.
General CSV/Excel file specification
Before diving into the freight-specific fields, you are encouraged to first familiarise yourself with Pledge's general CSV/Excel file specification for importing data.
Understanding how to map freight data
Pledge supports the import of externally calculated freight emissions data. Unlike emissions calculated by Pledge, which describe end-to-end multi-modal movements of freight—including pre-carriage, main carriage, port-to-port, and on-carriage movements—externally calculated emissions are imported at the shipment level with minimal required data, ensuring compatibility while recognising the limitations of third-party data.
Each shipment of cargo is represented as one line in the file, where pre-calculated CO₂e values are provided without requiring full shipment breakdown
SHIPMENT_ID
For each shipment of cargo, the shipment must have a unique identifier (provided by you) in the SHIPMENT_ID field.
Handling missing shipment details
If shipment details such as weight, routing, or vehicle type are not provided, Pledge will mark the data source as "Undisclosed" to indicate that only emissions totals were supplied without detailed methodology.
When importing third-party calculated freight emissions, some shipment details may be incomplete. Pledge ensures transparency by handling missing data as follows:
All shipment activity data supported by the Multimodal Freight File Specification can be shared with Pledge, although it is not mandatory for third-party emissions imports. Any additional data provided will be displayed unedited in Pledge, ensuring full visibility while preserving the original information.
Missing shipment activity data will be labeled as Undisclosed, allowing you to track gaps in the dataset.
Template and sample files
Fields
Fields marked with a ✅ are mandatory.
| Column | Data type |
✅ | SHIPMENT_ID | TEXT e.g. ABC250304 |
✅ | DATE
| RFC 3339-like format, e.g. 2021-09-15 12:31
Ideally, the pick-up date, date of departure or otherwise start date of the shipment. |
|
|
|
✅ | CO2E | DECIMAL e.g. 1,362.45
Notes: value must be in KG |
| CO2E_BREAKDOWN_WTT | DECIMAL e.g. 134.27
Notes: value must be in KG |
| CO2E_BREAKDOWN_TTW | DECIMAL e.g. 1,228.18
Notes: value must be in KG |
|
|
|
✅ | ACTIVITY | DECIMAL e.g. 251,821.92 |
| ACTIVITY_UNIT | TEXT e.g. TONNE_KM
One of:
Notes: If not specified, will default to TONNE_KM |
|
|
|
✅ | MODE | TEXT e.g. SEA
One of:
|