Skip to main content
All CollectionsPledge platformImporting your data
Third-party calculated freight emissions file specification
Third-party calculated freight emissions file specification

File specification for shipment-level freight emissions that have been pre-calculated by third parties.

Updated this week

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:

  • TONNE_KM

  • TONNE

  • TEU_KM

  • CONTAINER_MOVED

Notes: If not specified, will default to TONNE_KM

MODE

TEXT e.g. SEA

One of:

  • AIR

  • RAIL

  • ROAD

  • SEA

  • INLAND_WATERWAYS

  • LOGISTICS_HUB


Did this answer your question?