CSV reference
This reference is for logistics. If you're looking to submit a CSV for transactions, check out our guide here.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.CSV upload
Shipment details
The following properties apply to the entire shipment.version- Set this to
2for all rows. - Required.
- Format: Integer.
- Example:
2
shipment_id- A unique identifier for reconciling emission estimates with shipments in your system. Generate this string to track shipments in the results CSV.
- Optional.
- Format: String (unique ID that you generate).
- Example:
SHIP123456789
client_account_id- Links the emission estimate to an existing client account
- Required if generating emission reports for your customers and
client_account_handleis not provided. - Format: Account ID found in Lune dashboard.
- Example:
5ZKgqb84eLV9dynzDLyD0Ov7zoPxWGMQ
client_account_handle- Links the estimate with an existing client account if the handle matches. If no matching handle is found and no
client_account_idis provided, a new client account is created. - Required if generating emission reports for your customers and
client_account_idis not provided. - Format: String. Must be lower case and snake case.
- Example:
acme-inc
client_account_external_pages_visibility- Controls the visibility of external pages such as sustainability and analytics pages. Options: hidden, public. Defaults to hidden.
- Optional.
- Format: Enum (
hidden|public) - Example:
public
client_account_currency- The client account’s currency. Note: Lune does not support all currency codes.
- Required if creating a new client account via CSV.
- Format: ISO 4217 three-letter currency code
- Example:
USD
client_account_name- The name of the client. Defaults to
client_account_handleif not provided. If different from the account name in Lune’s system, the account name will be updated. - Optional.
- Format: String.
- Example:
Acme Incorporated
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.
- Optional.
- Format: String.
- Example:
Acme Climate Team
is_shipment- Indicates whether the estimate is for an actual shipment. Defaults to
falseif left blank. - Required if generating emission reports for customers.
- Format: Boolean.
- Example:
true
shipped_at- The shipment date and time, recorded for analytics purposes.
- Optional.
- Format: RFC 3339 timestamp.
- Example:
2024-05-01T14:30:00Z
mass_kg- The shipment’s weight in kilograms.
- Required if
containersis not provided. Optional but recommended for increased accuracy, ifcontainersis provided. - Format: Decimal number.
- Example:
1250.5
containers- The number of TEU containers in the shipment.
- Required if
mass_kgis not provided. Optional but recommended for increased accuracy, ifmass_kgis provided. - Format: Integer.
- Example:
2
source- Where the shipment originated.
- Required.
- Format: Can be provided as a comma-separated address with a three character country code, a UN/LOCODE, an IATA or ICAO airport code, or geographic coordinates.
- Example:
lat 51.5074, lon -0.1278orGBLONorApple Lane, London, SW1A 2AA, GBR
Leg details
The following values applies to an individual leg of the shipment. Prefix each value withlegX_, 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_identificationis provided. - Format: Enum (see list of supported methods below).
- Example:
diesel_truck,plane,container_ship
destination- Where the leg terminated; where the subsequent leg begins.
- Required.
- Format: Can be provided as a comma-separated address with a three character country code, a UN/LOCODE, an IATA or ICAO airport code, or geographic coordinates.
- Example:
lat 51.5074, lon -0.1278orGBLONorApple Lane, London, SW1A 2AA, GBR
refrigerated- Indicates whether the transport container is refrigerated (true) or dry (false).
- Optional.
- Format: Boolean.
- Example:
true
fuel- The fuel type used for road shipments. Only applies to vans, rigid, or articulated trucks.
- Optional (only applicable for road transport methods).
- Format: Enum (
gasoline,diesel,99_diesel_1_biodiesel,98_diesel_2_biodiesel,95_diesel_5_biodiesel,93_diesel_7_biodiesel,90_diesel_10_biodiesel,80_diesel_20_biodiesel,50_diesel_50_biodiesel,ethanol_from_corn,hvo_from_tallow,lpg,cng) - Example:
diesel
trade_lane- Trade lane designation for container ship shipments.
- Optional.
- Format: Enum (see full list below).
- Example:
disaggregated_asia_to_africa
departure_on- Departure date from the previous leg’s destination. Used with
flight_numberfor air tracking, or withvessel_identificationandarrival_onfor vessel tracking if the shipment completed over 24 hours ago. - Required if
flight_numberorvessel_identificationis used. - Format:
YYYY-MM-DD - Example:
2024-05-01
arrival_on- Arrival date at this leg’s destination. Used for vessel tracking if the shipment completed over 24 hours ago and
vessel_identificationis also provided. - Required for vessel tracking when used with
departure_onandvessel_identification. - Format:
YYYY-MM-DD - Example:
2024-05-01
vessel_identification- Identifies the vessel using either the IMO number (omit the IMO prefix) or the vessel name.
- Required for vessel tracking. Can replace method.
- Format: String (IMO number or vessel name).
- Example:
9395044orMSC Zoe
transit_corridor- The transit corridor used for sea shipments. This is used to improve the accuracy of the estimate. If not provided, the shortest route is calculated.
- Only applicable to sea shipments.
- Format: Enum (
panama,suez,cape_of_good_hope,northwest_passage,northeast_passage,cape_horn) - Example:
cape_of_good_hope
flight_number- The flight number for this leg in ICAO or IATA format. Requires
departure_on. - Required if using flight tracking.
- Format: String.
- Example:
LH1234orDLH400.
distance_km- The distance traveled during this shipment leg, in kilometres.
- Required if destination information is not provided.
- Format: Decimal number.
- Example:
742.5
Enum values
Trade lanes
Container transport emissions vary per trade lane. When a trade lane is not given we'll use an industry-wide average. Providing anaggregated_* trade lane group will result in an a more accurate estimate. Providing an disaggregated_* trade lane will result in the best estimate precision.The identifiers are kept relatively short for brevity: Mediterranean includes Black Sea and South America includes Central America.The trade lanes are bidirectional, for example disaggregated_asia_to_africa covers both Asia to Africa and Africa to Asia.aggregated_panama_tradeaggregated_transatlanticaggregated_transsuezaggregated_transpacificaggregated_otherdisaggregated_asia_to_africadisaggregated_asia_to_mediterraneandisaggregated_asia_to_middle_eastdisaggregated_asia_to_north_america_eastdisaggregated_asia_to_north_america_westdisaggregated_asia_to_north_europedisaggregated_asia_to_oceaniadisaggregated_asia_to_south_americadisaggregated_europe_to_africadisaggregated_europe_to_south_americadisaggregated_europe_to_middle_eastdisaggregated_europe_to_oceaniadisaggregated_mediterranean_to_north_america_eastdisaggregated_mediterranean_to_north_america_westdisaggregated_north_america_to_africadisaggregated_north_america_to_oceaniadisaggregated_north_america_to_south_americadisaggregated_north_america_to_middle_eastdisaggregated_north_europe_to_north_america_eastdisaggregated_north_europe_to_north_america_westdisaggregated_south_america_to_africadisaggregated_intra_africadisaggregated_intra_north_americadisaggregated_intra_south_americadisaggregated_se_asia_to_ne_asiadisaggregated_intra_ne_asiadisaggregated_intra_se_asiadisaggregated_north_europe_to_mediterraneandisaggregated_intra_mediterraneandisaggregated_intra_north_europedisaggregated_intra_middle_eastdisaggregated_other
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 waterwaysinland_waterway_motor_vessel_extra_smallinland_waterway_motor_vessel_smallinland_waterway_motor_vessel_mediuminland_waterway_motor_vessel_largeinland_waterway_coupled_convoyinland_waterway_pushed_convoy_smallinland_waterway_pushed_convoy_mediuminland_waterway_pushed_convoy_largeinland_waterway_tankerinland_waterway_container_vessel_mediuminland_waterway_container_vessel_largeinland_waterway_container_vessel_convoy
diesel_freight_trainelectric_freight_traindiesel_freight_train_us_averagediesel_freight_train_eu_averagediesel_freight_train_eu_containerdiesel_freight_train_eu_carsdiesel_freight_train_eu_chemicalsdiesel_freight_train_eu_coal_steeldiesel_freight_train_eu_building_materialsdiesel_freight_train_eu_manufactured_productsdiesel_freight_train_eu_cerealsdiesel_freight_train_eu_truck_and_trailerdiesel_freight_train_eu_trailer_onlyelectric_freight_train_eu_averageelectric_freight_train_eu_containerelectric_freight_train_eu_carselectric_freight_train_eu_chemicalselectric_freight_train_eu_coal_steelelectric_freight_train_eu_building_materialselectric_freight_train_eu_manufactured_productselectric_freight_train_eu_cerealselectric_freight_train_eu_truck_and_trailerelectric_freight_train_eu_trailer_only
diesel_truckdiesel_truck_refrigeratedtruck_generic_vantruck_generic_urbantruck_generic_mgvtruck_generic_hgvtruck_rigid_7_5ttruck_rigid_12ttruck_rigid_20ttruck_rigid_26ttruck_rigid_32ttruck_articulated_34ttruck_articulated_40ttruck_articulated_44ttruck_articulated_60ttruck_articulated_72ttruck_generic_van_petroltruck_generic_van_cngtruck_generic_van_lpgtruck_rigid_7_5t_cngtruck_rigid_12t_cngtruck_rigid_20t_cngtruck_rigid_26t_cngtruck_rigid_26t_lngtruck_articulated_44t_light_loadtruck_articulated_44t_heavy_loadtruck_articulated_44t_containertruck_articulated_60t_heavy_loadtruck_articulated_60t_containertruck_articulated_72t_heavy_loadtruck_articulated_72t_containertruck_articulated_40t_si_engine_lng_containertruck_articulated_40t_si_engine_cngtruck_articulated_40t_si_engine_bio_lngtruck_articulated_40t_si_engine_cng_containertruck_articulated_40t_si_engine_bio_lng_containertruck_articulated_40t_hpdi_lng_dieseltruck_articulated_40t_hpdi_cng_dieseltruck_articulated_40t_hpdi_bio_lng_dieseltruck_generic_van_electrictruck_rigid_7_5t_electrictruck_rigid_7_5t_electric_light_loadtruck_rigid_12t_electrictruck_rigid_12t_electric_light_loadtruck_rigid_20t_electrictruck_rigid_20t_electric_light_loadtruck_rigid_40t_electrictruck_rigid_40t_electric_light_loadtruck_generic_van_refrigeratedtruck_generic_urban_refrigeratedtruck_generic_mgv_refrigeratedtruck_generic_hgv_refrigeratedtruck_rigid_7_5t_refrigeratedtruck_rigid_12t_refrigeratedtruck_rigid_20t_refrigeratedtruck_rigid_26t_refrigeratedtruck_rigid_32t_refrigeratedtruck_articulated_34t_refrigeratedtruck_articulated_40t_refrigeratedtruck_articulated_44t_refrigeratedtruck_articulated_60t_refrigeratedtruck_articulated_72t_refrigeratedtruck_generic_van_petrol_refrigeratedtruck_generic_van_cng_refrigeratedtruck_generic_van_lpg_refrigeratedtruck_rigid_7_5t_cng_refrigeratedtruck_rigid_12t_cng_refrigeratedtruck_rigid_20t_cng_refrigeratedtruck_rigid_26t_cng_refrigeratedtruck_rigid_26t_lng_refrigeratedtruck_articulated_44t_light_load_refrigeratedtruck_articulated_44t_container_refrigeratedtruck_articulated_44t_heavy_load_refrigeratedtruck_articulated_60t_heavy_load_refrigeratedtruck_articulated_60t_container_refrigeratedtruck_articulated_72t_heavy_load_refrigeratedtruck_articulated_72t_container_refrigeratedtruck_articulated_40t_si_engine_lng_container_refrigeratedtruck_articulated_40t_si_engine_cng_refrigeratedtruck_articulated_40t_si_engine_bio_lng_refrigeratedtruck_articulated_40t_si_engine_cng_container_refrigeratedtruck_articulated_40t_si_engine_bio_lng_container_refrigeratedtruck_articulated_40t_hpdi_lng_diesel_refrigeratedtruck_articulated_40t_hpdi_cng_diesel_refrigeratedtruck_articulated_40t_hpdi_bio_lng_diesel_refrigeratedtruck_generic_van_electric_refrigeratedtruck_rigid_7_5t_electric_refrigeratedtruck_rigid_7_5t_electric_light_load_refrigeratedtruck_rigid_12t_electric_refrigeratedtruck_rigid_12t_electric_light_load_refrigeratedtruck_rigid_20t_electric_refrigeratedtruck_rigid_20t_electric_light_load_refrigeratedtruck_rigid_40t_electric_refrigeratedtruck_rigid_40t_electric_light_load_refrigeratedtruck_na_vantruck_na_generaltruck_na_auto_carriertruck_na_draytruck_na_expeditedtruck_na_flatbedtruck_na_heavy_bulktruck_na_dry_van_ltltruck_na_dry_van_tltruck_na_mixedtruck_na_movingtruck_na_packagetruck_na_refrigeratedtruck_na_specializedtruck_na_tanker
planepassenger_planecargo_plane
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_mdoCSV results
Once the CSV is uploaded, the resulting CSV includes the following headings.estimate_id- The unique identifier for the emission estimate.
- Example:
enjo9g08vx3Mpjj9E7apPrEZ57XJkDVd
dashboard_url- URL to the emission calculation page in the Lune dashboard.
- Example:
https://dashboard.lune.co/calculate-emissions/multi-leg-shipping/QW1j8x9Jn0RBp2a0Rv3Yv5XmeblVrD2Z/results
client_account_analytics_url- URL to customer-facing analytics page (if
client_account_external_pages_visibilityis set totrue). - Example:
https://dashboard.lune.co/clients/acme-inc/analytics
total_mass_tco2e- Total tonnes of CO₂ equivalent emissions for the shipment.
total_mass_tco2e_wtt- Total tonnes CO₂ equivalent emissions from well-to-tank operations.
total_mass_tco2e_ttw- Total tonnes CO₂ equivalent emissions from tank-to-wheel operations.
total_mass_tco2e_unknown- Unattributed tonnes CO₂ equivalent emissions (neither WTT nor TTW).
total_mass_tco2- Total tonnes of CO₂ emissions for the shipment. This is only for CO₂, not carbon dioxide equivalent.
total_mass_tco2_wtt- Total tonnes of CO₂ emissions from well-to-tank.
total_mass_tco2_ttw- Total tonnes of CO₂ emissions from tank-to-wheel.
total_mass_tnox- Total tonnes of nitrogen oxides (NOₓ) emissions for the shipment.
total_mass_tnox_wtt- Total tonnes of NOₓ emissions from well-to-tank.
total_mass_tnox_ttw- Total tonnes of NOₓ emissions from tank-to-wheel.
total_mass_tnmhc- Total tonnes of non-methane hydrocarbons (NMHC) emissions for the shipment.
total_mass_tnmhc_wtt- Total tonnes of NMHC emissions from well-to-tank.
total_mass_tnmhc_ttw- Total tonnes of NMHC emissions from tank-to-wheel.
total_mass_tso2- Total tonnes of sulfur dioxide (SO₂) emissions for the shipment.
total_mass_tso2_wtt- Total tonnes of SO₂ emissions from well-to-tank.
total_mass_tso2_ttw- Total tonnes of SO₂ emissions from tank-to-wheel.
total_mass_tpm- Total tonnes of particulate matter (PM) emissions for the shipment.
total_mass_tpm_wtt- Total tonnes of PM emissions from well-to-tank.
total_mass_tpm_ttw- Total tonnes of PM emissions from tank-to-wheel.
total_distance_km- Total shipment distance in kilometres.
total_adjusted_distance_km- Total shipment distance with adjustment factors applied.
error- Error message if the row failed to process.
- Example:
Address cannot be resolved.
legX_, where X represents the leg number.leg1_estimated_distance_km- Estimated distance for the leg.
legx_estimated_adjusted_distance_km- Estimated distance with adjustment factors for the leg.
legx_total_tco2e- Total tonnes CO₂ equivalent emissions for the leg.
legx_total_tco2e_wtt- Total tonnes CO₂e WTT emissions for the leg.
legx_total_tco2e_ttw- Total tonnes CO₂e TTW emissions for the leg.
legx_total_tco2e_unknown- Total tonnes CO₂e unknown-source emissions for the leg.
legx_total_tco2- Total tonnes CO₂ emissions for the leg. This is for carbon dioxide, not carbon dioxide equivalent.
legx_total_tco2_wtt- Total tonnes CO₂ WTT emissions for the leg.
legx_total_tco2_ttw- Total tonnes CO₂ TTW emissions for the leg.
legx_total_tnox- Total tonnes NOₓ emissions for the leg.
legx_total_tnox_wtt- Total tonnes NOₓ WTT emissions for the leg.
legx_total_tnox_ttw- Total tonnes NOₓ TTW emissions for the leg.
legx_total_tnmhc- Total tonnesNMHC emissions for the leg.
legx_total_tnmhc_wtt- Total tonnes NMHC WTT emissions for the leg.
legx_total_tnmhc_ttw- Total tonnes NMHC TTW emissions for the leg.
legx_total_tso2- Total tonnes SO₂ emissions for the leg.
legx_total_tso2_wtt- Total tonnes SO₂ WTT emissions for the leg.
legx_total_tso2_ttw- Total tonnes SO₂ TTW emissions for the leg.
legx_total_tpm- Total tonnes PM emissions for the leg.
legx_total_tpm_wtt- Total tonnes PM WTT emissions for the leg.
legx_total_tpm_ttw- Total tonnes PM TTW emissions for the leg.