CSV reference

Each row in the CSV represents a single shipment. The properties listed below can be included as column headings to provide details about the shipment.

Shipment details

The following properties apply to the entire shipment.

version

Required. Set this to 2 for all rows.

shipment_id

A unique identifier for reconciling emission estimates with shipments in your system. Generate this string to track shipments in the results CSV.

client_account_id

Links the emission estimate to an existing client account. Required for generating emission reports for your customers.

client_account_handle

Associates the estimate with an existing client account if the handle matches. If no matching handle is found and no client_account_id is provided, a new client account is created. Required for generating emission reports for your customers.

client_account_external_pages_visibility

Controls the visibility of external pages such as sustainability and analytics pages. Options: hidden, public. Defaults to hidden.

client_account_currency

The client account’s currency, specified as an ISO 4217 three-letter currency code. Note: Lune does not support all currency codes. Required if creating a new client account via CSV.

client_account_name

The name of the client. Defaults to client_account_handle if not provided. If different from the account name in Lune’s system, the account name will be updated.

client_account_beneficiary

The name that will appear on future carbon credit retirements for the customer. Provide only if different from the existing beneficiary in Lune’s system. If specified, the beneficiary name will be updated in Lune’s system.

is_shipment

Indicates whether the estimate is for an actual shipment. Defaults to false if left blank.

shipped_at

The shipment date and time, recorded for analytics purposes. Use the RFC 3339 section 5.6 timestamp format.

mass_kg

The shipment’s weight in kilograms. Either mass_kg or containers is required. Both can be provided for more accurate estimates.

containers

The number of TEU containers in the shipment. Either mass_kg or containers is required. Both can be provided for more accurate estimates.

source

Where the shipment originated. This can be provided as a comma-separated address, a UN/LOCODE, an IATA or ICAO airport code, or geographic coordinates (formatted as “lat <latitude>, lon <longitute>”, using decimal representation).

Leg details

The following values applies to an individual leg of the shipment. Prefix each value with legX_, where X represents the leg number. For example, use leg1_ for the first leg and leg6_ for the sixth leg. There can be up to 10 legs included per row.

method

The transport method for this leg. Required unless vessel_identification is provided. For a full list of supported methods, see below.

destination

Where the leg terminated; where the subsequent leg begins. This can be provided as a comma-separated address, a UN/LOCODE, an IATA or ICAO airport code, or geographic coordinates (formatted as “lat <latitude>, lon <longitute>”, using decimal representation).

refrigerated

Indicates whether the transport container is refrigerated (true) or dry (false).

fuel

Use for road shipments. The fuel type for this vehicle. Only applicable for shipments using vans, rigid or articulated trucks.

trade_lane

Use for container ship shipments. A trade lane designation. Requires the method to be container_ship.

departure_on

The departure date from the previous legs destination. Value is used with flight_number to identify a flight, or with vessel_identification and arrival_on for vessel tracking if the entire shipment was completed over 24 hours ago.

arrival_on

The arrival date at this legs destination. Value is used for vessel tracking if the entire shipment was completed over 24 hours ago and arrival_on, and vessel_identification are provided.

vessel_identification

Identifies the vessel using either the IMO number (removing the IMO prefix) or the vessel name.

flight_number

The flight number for this leg, in either ICAO or IATA format. Requires departure_on.

distance_km

The distance traveled during this shipment leg, in kilometres.

Methods

There are many supported transport methods when using Lune to calculate emissions. The following values are available to use as a value under the method heading for each leg.

Inland waterways

inland_waterway_motor_vessel_extra_small
inland_waterway_motor_vessel_small
inland_waterway_motor_vessel_medium
inland_waterway_motor_vessel_large
inland_waterway_coupled_convoy
inland_waterway_pushed_convoy_small
inland_waterway_pushed_convoy_medium
inland_waterway_pushed_convoy_large
inland_waterway_tanker
inland_waterway_container_vessel_medium
inland_waterway_container_vessel_large
inland_waterway_container_vessel_convoy

Trains

diesel_freight_train
electric_freight_train
diesel_freight_train_us_average
diesel_freight_train_eu_average
diesel_freight_train_eu_container
diesel_freight_train_eu_cars
diesel_freight_train_eu_chemicals
diesel_freight_train_eu_coal_steel
diesel_freight_train_eu_building_materials
diesel_freight_train_eu_manufactured_products
diesel_freight_train_eu_cereals
diesel_freight_train_eu_truck_and_trailer
diesel_freight_train_eu_trailer_only
electric_freight_train_eu_average
electric_freight_train_eu_container
electric_freight_train_eu_cars
electric_freight_train_eu_chemicals
electric_freight_train_eu_coal_steel
electric_freight_train_eu_building_materials
electric_freight_train_eu_manufactured_products
electric_freight_train_eu_cereals
electric_freight_train_eu_truck_and_trailer
electric_freight_train_eu_trailer_only

Road

diesel_truck
diesel_truck_refrigerated
truck_generic_van
truck_generic_urban
truck_generic_mgv
truck_generic_hgv
truck_rigid_7_5t
truck_rigid_12t
truck_rigid_20t
truck_rigid_26t
truck_rigid_32t
truck_articulated_34t
truck_articulated_40t
truck_articulated_44t
truck_articulated_60t
truck_articulated_72t
truck_generic_van_petrol
truck_generic_van_cng
truck_generic_van_lpg
truck_rigid_7_5t_cng
truck_rigid_12t_cng
truck_rigid_20t_cng
truck_rigid_26t_cng
truck_rigid_26t_lng
truck_articulated_44t_light_load
truck_articulated_44t_heavy_load
truck_articulated_44t_container
truck_articulated_60t_heavy_load
truck_articulated_60t_container
truck_articulated_72t_heavy_load
truck_articulated_72t_container
truck_articulated_40t_si_engine_lng_container
truck_articulated_40t_si_engine_cng
truck_articulated_40t_si_engine_bio_lng
truck_articulated_40t_si_engine_cng_container
truck_articulated_40t_si_engine_bio_lng_container
truck_articulated_40t_hpdi_lng_diesel
truck_articulated_40t_hpdi_cng_diesel
truck_articulated_40t_hpdi_bio_lng_diesel
truck_generic_van_electric
truck_rigid_7_5t_electric
truck_rigid_7_5t_electric_light_load
truck_rigid_12t_electric
truck_rigid_12t_electric_light_load
truck_rigid_20t_electric
truck_rigid_20t_electric_light_load
truck_rigid_40t_electric
truck_rigid_40t_electric_light_load
truck_generic_van_refrigerated
truck_generic_urban_refrigerated
truck_generic_mgv_refrigerated
truck_generic_hgv_refrigerated
truck_rigid_7_5t_refrigerated
truck_rigid_12t_refrigerated
truck_rigid_20t_refrigerated
truck_rigid_26t_refrigerated
truck_rigid_32t_refrigerated
truck_articulated_34t_refrigerated
truck_articulated_40t_refrigerated
truck_articulated_44t_refrigerated
truck_articulated_60t_refrigerated
truck_articulated_72t_refrigerated
truck_generic_van_petrol_refrigerated
truck_generic_van_cng_refrigerated
truck_generic_van_lpg_refrigerated
truck_rigid_7_5t_cng_refrigerated
truck_rigid_12t_cng_refrigerated
truck_rigid_20t_cng_refrigerated
truck_rigid_26t_cng_refrigerated
truck_rigid_26t_lng_refrigerated
truck_articulated_44t_light_load_refrigerated
truck_articulated_44t_heavy_load_refrigerated
truck_articulated_44t_container_refrigerated
truck_articulated_60t_heavy_load_refrigerated
truck_articulated_60t_container_refrigerated
truck_articulated_72t_heavy_load_refrigerated
truck_articulated_72t_container_refrigerated
truck_articulated_40t_si_engine_lng_container_refrigerated
truck_articulated_40t_si_engine_cng_refrigerated
truck_articulated_40t_si_engine_bio_lng_refrigerated
truck_articulated_40t_si_engine_cng_container_refrigerated
truck_articulated_40t_si_engine_bio_lng_container_refrigerated
truck_articulated_40t_hpdi_lng_diesel_refrigerated
truck_articulated_40t_hpdi_cng_diesel_refrigerated
truck_articulated_40t_hpdi_bio_lng_diesel_refrigerated
truck_generic_van_electric_refrigerated
truck_rigid_7_5t_electric_refrigerated
truck_rigid_7_5t_electric_light_load_refrigerated
truck_rigid_12t_electric_refrigerated
truck_rigid_12t_electric_light_load_refrigerated
truck_rigid_20t_electric_refrigerated
truck_rigid_20t_electric_light_load_refrigerated
truck_rigid_40t_electric_refrigerated
truck_rigid_40t_electric_light_load_refrigerated
truck_na_van
truck_na_general
truck_na_auto_carrier
truck_na_dray
truck_na_expedited
truck_na_flatbed
truck_na_heavy_bulk
truck_na_dry_van_ltl
truck_na_dry_van_tl
truck_na_mixed
truck_na_moving
truck_na_package
truck_na_refrigerated
truck_na_specialized
truck_na_tanker

Air

plane
passenger_plane
cargo_plane

Sea

container_ship
sea_bulk_carrier_10dwkt_hfo
sea_bulk_carrier_10dwkt_vlsfo
sea_bulk_carrier_10dwkt_mdo
sea_bulk_carrier_35dwkt_hfo
sea_bulk_carrier_35dwkt_vlsfo
sea_bulk_carrier_35dwkt_mdo
sea_bulk_carrier_60dwkt_hfo
sea_bulk_carrier_60dwkt_vlsfo
sea_bulk_carrier_60dwkt_mdo
sea_bulk_carrier_100dwkt_hfo
sea_bulk_carrier_100dwkt_vlsfo
sea_bulk_carrier_100dwkt_mdo
sea_bulk_carrier_200dwkt_hfo
sea_bulk_carrier_200dwkt_vlsfo
sea_bulk_carrier_200dwkt_mdo
sea_bulk_carrier_over_200dwkt_hfo
sea_bulk_carrier_over_200dwkt_vlsfo
sea_bulk_carrier_over_200dwkt_mdo
sea_chemical_tanker_5dwkt_hfo
sea_chemical_tanker_5dwkt_vlsfo
sea_chemical_tanker_5dwkt_mdo
sea_chemical_tanker_10dwkt_hfo
sea_chemical_tanker_10dwkt_vlsfo
sea_chemical_tanker_10dwkt_mdo
sea_chemical_tanker_20dwkt_hfo
sea_chemical_tanker_20dwkt_vlsfo
sea_chemical_tanker_20dwkt_mdo
sea_chemical_tanker_40dwkt_hfo
sea_chemical_tanker_40dwkt_vlsfo
sea_chemical_tanker_40dwkt_mdo
sea_chemical_tanker_over_40dwkt_hfo
sea_chemical_tanker_over_40dwkt_vlsfo
sea_chemical_tanker_over_40dwkt_mdo
sea_general_cargo_5dwkt_hfo
sea_general_cargo_5dwkt_vlsfo
sea_general_cargo_5dwkt_mdo
sea_general_cargo_10dwkt_hfo
sea_general_cargo_10dwkt_vlsfo
sea_general_cargo_10dwkt_mdo
sea_general_cargo_20dwkt_hfo
sea_general_cargo_20dwkt_vlsfo
sea_general_cargo_20dwkt_mdo
sea_general_cargo_over_20dwkt_hfo
sea_general_cargo_over_20dwkt_vlsfo
sea_general_cargo_over_20dwkt_mdo
sea_liquefied_gas_tanker_50dwkt_hfo
sea_liquefied_gas_tanker_50dwkt_vlsfo
sea_liquefied_gas_tanker_50dwkt_mdo
sea_liquefied_gas_tanker_100dwkt_hfo
sea_liquefied_gas_tanker_100dwkt_vlsfo
sea_liquefied_gas_tanker_100dwkt_mdo
sea_liquefied_gas_tanker_200dwkt_hfo
sea_liquefied_gas_tanker_200dwkt_vlsfo
sea_liquefied_gas_tanker_200dwkt_mdo
sea_liquefied_gas_tanker_over_200dwkt_hfo
sea_liquefied_gas_tanker_over_200dwkt_vlsfo
sea_liquefied_gas_tanker_over_200dwkt_mdo
sea_oil_tanker_5dwkt_hfo
sea_oil_tanker_5dwkt_vlsfo
sea_oil_tanker_5dwkt_mdo
sea_oil_tanker_10dwkt_hfo
sea_oil_tanker_10dwkt_vlsfo
sea_oil_tanker_10dwkt_mdo
sea_oil_tanker_20dwkt_hfo
sea_oil_tanker_20dwkt_vlsfo
sea_oil_tanker_20dwkt_mdo
sea_oil_tanker_60dwkt_hfo
sea_oil_tanker_60dwkt_vlsfo
sea_oil_tanker_60dwkt_mdo
sea_oil_tanker_80dwkt_hfo
sea_oil_tanker_80dwkt_vlsfo
sea_oil_tanker_80dwkt_mdo
sea_oil_tanker_112dwkt_hfo
sea_oil_tanker_112dwkt_vlsfo
sea_oil_tanker_112dwkt_mdo
sea_oil_tanker_200dwkt_hfo
sea_oil_tanker_200dwkt_vlsfo
sea_oil_tanker_200dwkt_mdo
sea_oil_tanker_over_200dwkt_hfo
sea_oil_tanker_over_200dwkt_vlsfo
sea_oil_tanker_over_200dwkt_mdo
sea_other_liquids_tanker_1dwkt_hfo
sea_other_liquids_tanker_1dwkt_vlsfo
sea_other_liquids_tanker_1dwkt_mdo
sea_other_liquids_tanker_over_1dwkt_hfo
sea_other_liquids_tanker_over_1dwkt_vlsfo
sea_other_liquids_tanker_over_1dwkt_mdo
sea_ropax_2dwkt_hfo
sea_ropax_2dwkt_vlsfo
sea_ropax_2dwkt_mdo
sea_ropax_5dwkt_hfo
sea_ropax_5dwkt_vlsfo
sea_ropax_5dwkt_mdo
sea_ropax_10dwkt_hfo
sea_ropax_10dwkt_vlsfo
sea_ropax_10dwkt_mdo
sea_ropax_20dwkt_hfo
sea_ropax_20dwkt_vlsfo
sea_ropax_20dwkt_mdo
sea_ropax_over_20dwkt_hfo
sea_ropax_over_20dwkt_vlsfo
sea_ropax_over_20dwkt_mdo
sea_refrigerated_bulk_carrier_2dwkt_hfo
sea_refrigerated_bulk_carrier_2dwkt_vlsfo
sea_refrigerated_bulk_carrier_2dwkt_mdo
sea_refrigerated_bulk_carrier_6dwkt_hfo
sea_refrigerated_bulk_carrier_6dwkt_vlsfo
sea_refrigerated_bulk_carrier_6dwkt_mdo
sea_refrigerated_bulk_carrier_10dwkt_hfo
sea_refrigerated_bulk_carrier_10dwkt_vlsfo
sea_refrigerated_bulk_carrier_10dwkt_mdo
sea_refrigerated_bulk_carrier_over_10dwkt_hfo
sea_refrigerated_bulk_carrier_over_10dwkt_vlsfo
sea_refrigerated_bulk_carrier_over_10dwkt_mdo
sea_roro_5dwkt_hfo
sea_roro_5dwkt_vlsfo
sea_roro_5dwkt_mdo
sea_roro_10dwkt_hfo
sea_roro_10dwkt_vlsfo
sea_roro_10dwkt_mdo
sea_roro_15dwkt_hfo
sea_roro_15dwkt_vlsfo
sea_roro_15dwkt_mdo
sea_roro_over_15dwkt_hfo
sea_roro_over_15dwkt_vlsfo
sea_roro_over_15dwkt_mdo
sea_vehicle_carrier_30dwkt_hfo
sea_vehicle_carrier_30dwkt_vlsfo
sea_vehicle_carrier_30dwkt_mdo
sea_vehicle_carrier_50dwkt_hfo
sea_vehicle_carrier_50dwkt_vlsfo
sea_vehicle_carrier_50dwkt_mdo
sea_vehicle_carrier_over_50dwkt_hfo
sea_vehicle_carrier_over_50dwkt_vlsfo
sea_vehicle_carrier_over_50dwkt_mdo

Results

Once the CSV is uploaded, the resulting CSV includes the following headings.

estimate_id

The unique identifier for the emission estimate.

dashboard_url

The URL to the specific emission calculation page in the Lune dashboard. This page allows you to review your estimate, understand how the emissions were calculated, and offset emissions.

client_account_analytics_url

This column is populated when client_account_handle is provided. This page allows your customers to view their shipment analytics, review individual calculations, and better understand how the emissions were calculated.

total_mass_tco2

The total emission estimate for the shipment, measured in tCO₂e.

total_distance_km

The total distance traveled by the shipment, measured in kilometres.

total_adjusted_distance_km

The total shipment distance in kilometres, including distance adjustment factors.

estimated_distance_km

Prefixed with the relevant leg (legX_). The estimated distance for the shipment leg, measured in kilometres. Equivalent to legX_distance_km if provided.

estimated_adjusted_distance_km

Prefixed with the relevant leg (legX_). The estimated shipment leg distance, including distance adjustment factors, measured in kilometres.

total_tco2

Prefixed with the relevant leg (legX_). The emission estimate for the shipment leg, measured in tCO₂e.

error

Describes any error encountered when processing the row. If this column is populated, the row failed to process and no results were returned. Review and correct the provided data.n

Additional resources

Learn how to use the CSV using our guide.

Calculate emissions

Logistics

Spend management

Track and report emissions

Dashboard

Logistics analytics

Spend management analytics

Logistics emissions explanations widget

Offset emissions

Carbon credits

General concepts

Accounts

Emission calculations

Logistics methodology

Carbon credit orders

API reference

Basic information

Shipping emission estimates

Spend emission estimates

Other emission estimates

Emission factors

Tracking and reporting

Carbon quotes and orders

Carbon projects