Logistics CSV spreadsheet calculations

Overview

In this guide, you will learn how to calculate emissions for shipments by:

• filling and uploading a CSV spreadsheet

Who is this guide for?

This guide is aimed at Sustainability Specialists or Product Managers.

Feel free to contact our support team if you encounter any issues.

Calculations will count towards your tier limit, one per row.

Download CSV template

Navigate to the logistics spreadsheet calculation page.

Click on the 'Download CSV template' button to download the template.

The template contains sample data. Amend and/or delete rows to fit your data.

Do not delete the header row.

To test the flow, feel free to upload the template and see results.

CSV format

Populate the CSV sheet using your preferred editor.

Ensure to save the file as csv with a .csv extension.

You may either omit or leave blank non-required columns.

Each row may contain up to 10 legs, only one leg is required. All legs have the same format, the table below describes all legs for correctness.

Files up to 2MB are supported

What to input?

Required inputs are:

1. Route or distance
2. Cargo weight
3. Transport mode

In addition, a value for version is required and must be set to 1.

Route or distance

Route

For origin, input one of address, UN/LOCODE, or geographical coordinates as follows:

• Address: pickup_country is required and at least one of pickup_street, pickup_postcode, pickup_city. Note: pickup_country is a 3-letter country code.
• UN/LOCODE: pickup_locode
• Coordinates: pickup_coordinates. Pick up geographical coordinates formatted as lat <number> lon <number>

For stops and destinations, the same format applies for leg1_country, leg2_country, and so on.

Note: you can mix and e.g., enter pickup as address and destination as UN/LOCODE. If Route is used, Lune calculates the distance.

Distance

Input the distance in km in the column for leg1_distance_km. If you have distance data, you can use it instead of Route.

Cargo weight

Input either cargo weight in kg or in TEU, or both.

• mass_kg: cargo weight in kilograms
• containers: number of TEU (Twenty-foot Equivalent Units)

Transport mode

The transport method for the first leg is entered in leg1_method or leg1_imo_number.

• leg1_method: Must be in Lune’s accepted format. See the list of available transport methods in the Reference below. Examples: cargo_plane, container_ship, diesel_truck, truck_articulated_40t.
• leg1_imo_number: The vessel's IMO number without the IMO prefix. When an IMO number is provided, the leg's method is ignored.

The same format applies to let2_method, leg3_method, and so on.

Reference

versionstring^[0-9]+$required

The row's schema version.

Must be set to 1.

---

shipment_idstring

Client shipment identifier

Acts as external id. The field represents the id in your system, which you may use to reconcile emission estimates.

---

client_account_idstring

The client account unique identifier.

When set, the emission estimate is stored against the client account.

For details in regards to Client Accounts visit https://docs.lune.co/api-reference/client-accounts/client-account.

---

client_account_handlestring^$|^[a-z0-9-_]+$

The client account handle is a unique user defined handle that identifies your customer.

A client account is created for every new handle and the emission estimate is stored against the client account.

If a client account is already associated with the handle, the emission estimate is stored against the existing client account.

For details in regards to Client Accounts visit https://docs.lune.co/api-reference/client-accounts/client-account.

Note: client_account_id takes precedence of client_account_handle.

---

client_account_currencystring

The client account's currency.

This property must be set when client_account_handle is set.

You cannot overwrite a client account's currency.

---

client_account_namestring

The client account's name.

If no value is provided, this will equal the client account handle.

If client_account_name is different from the account's name in Lune's system, the account's name will be changed.

---

client_account_beneficiarystring

The client account's beneficiary.

This is the name that appears on future retirements that are made in this account. If none is present, the organisation beneficiary will be used instead.

If client_account_beneficiary is different from the account's beneficiary in Lune's system, the account's beneficiary will be changed.

---

is_shipmentenum

Is this an estimate for an actual shipment?

If left blank, false is used.

Enum:

• TRUE
• true
• FALSE
• false

---

shipped_at

The date and time of shipping the goods for the purpose of analytics (it doesn't affect emission calculations in any way).

If a value is provided when creating or updating an estimate we use the value. Otherwise defaults to the current time when creating estimates and remains unchanged when updating estimates.

This property must be formatted as RFC 3339, section 5.6 timestamp.

Examples:

• 2023-12-01T12:30:30.000Z
• 2023-12-01T12:30:30Z
• 2023-12-01T11:30:30+01.00

One of

---

mass_kgstring^$|^[0-9]+(\.[0-9]+)?$

Shipment weight in kg.

One of mass_kg and containers is mandatory. You may provide both for more accurate estimates.

---

containersstring^$|^[0-9]+(\.[0-9]+)?$

Shipment in containers.

One of mass_kg and containers is mandatory. You may provide both for more accurate estimates.

---

pickup_countrystring

Pick up 3-letter ISO 3166 country code.

pickup_country, pickup_city, pickup_postcode, pickup_street are fields that form an address.

One of address, pickup_coordinates, pickup_locode is required.

As part of an address, to ensure accuracy, pickup_country is required and at least one of pickup_street, pickup_postcode, pickup_city.

Examples: GBR, ISR.

---

pickup_citystring

Pick up city.

pickup_country, pickup_city, pickup_postcode, pickup_street are fields that form an address.

One of address, pickup_coordinates, pickup_locode is required.

As part of an address, to ensure accuracy, pickup_country is required and at least one of pickup_street, pickup_postcode, pickup_city.

---

pickup_postcodestring

Pick up postcode or zipcode.

pickup_country, pickup_city, pickup_postcode, pickup_street are fields that form an address.

One of address, pickup_coordinates, pickup_locode is required.

As part of an address, to ensure accuracy, pickup_country is required and at least one of pickup_street, pickup_postcode, pickup_city.

---

pickup_streetstring

Pick up street.

pickup_country, pickup_city, pickup_postcode, pickup_street are fields that form an address.

One of address, pickup_coordinates, pickup_locode is required.

As part of an address, to ensure accuracy, pickup_country is required and at least one of pickup_street, pickup_postcode, pickup_city.

---

pickup_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Pick up geographical coordinates formatted as 'lat <number> lon <number>'.

One of address, pickup_coordinates, pickup_locode is required.

---

pickup_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, pickup_coordinates, pickup_locode is required.

---

leg1_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg1_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg1_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg1_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg1_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg1_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg1_departure_on and leg1_arrival_on and one of leg1_imo_number, leg1_vessel_name is provided, vessel tracking will be attempted.

---

leg1_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the arrival to the destination port.

If leg1_departure_on and leg1_arrival_on and one of leg1_imo_number, leg1_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg1_countrystring

Pick up 3-letter ISO 3166 country code. leg1_country, leg1_city, leg1_postcode, leg1_street are fields that form an address. One of address, leg1_coordinates, leg1_locode, leg1_distance_km is required. As part of an address, to ensure accuracy, leg1_country is required and at least one of leg1_street, leg1_postcode, leg1_city. Examples GBR, ISR.

---

leg1_citystring

Leg city.

leg1_country, leg1_city, leg1_postcode, leg1_street are fields that form an address.

One of address, leg1_coordinates, leg1_locode, leg1_distance_km is required.

As part of an address, to ensure accuracy, leg1_country is required and at least one of leg1_street, leg1_postcode, leg1_city.

---

leg1_postcodestring

Leg postcode or zipcode.

leg1_country, leg1_city, leg1_postcode, leg1_street are fields that form an address.

One of address, leg1_coordinates, leg1_locode, leg1_distance_km is required.

As part of an address, to ensure accuracy, leg1_country is required and at least one of leg1_street, leg1_postcode, leg1_city.

---

leg1_streetstring

Leg street.

leg1_country, leg1_city, leg1_postcode, leg1_street are fields that form an address.

One of address, leg1_coordinates, leg1_locode, leg1_distance_km is required.

As part of an address, to ensure accuracy, leg1_country is required and at least one of leg1_street, leg1_postcode, leg1_city.

---

leg1_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg1_coordinates, leg1_locode, leg1_distance_km is required.

---

leg1_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg1_coordinates, leg1_locode, leg1_distance_km is required.

---

leg1_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg1_coordinates, leg1_locode, leg1_distance_km is required.

---

leg2_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg2_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg2_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg2_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg2_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg2_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg2_departure_on and leg2_arrival_on and one of leg2_imo_number, leg2_vessel_name is provided, vessel tracking will be attempted.

---

leg2_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the arrival to the destination port.

If leg2_departure_on and leg2_arrival_on and one of leg2_imo_number, leg2_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg2_countrystring

Pick up 3-letter ISO 3166 country code. leg2_country, leg2_city, leg2_postcode, leg2_street are fields that form an address. One of address, leg2_coordinates, leg2_locode, leg2_distance_km is required. As part of an address, to ensure accuracy, leg2_country is required and at least one of leg2_street, leg2_postcode, leg2_city. Examples GBR, ISR.

---

leg2_citystring

Leg city.

leg2_country, leg2_city, leg2_postcode, leg2_street are fields that form an address.

One of address, leg2_coordinates, leg2_locode, leg2_distance_km is required.

As part of an address, to ensure accuracy, leg2_country is required and at least one of leg2_street, leg2_postcode, leg2_city.

---

leg2_postcodestring

Leg postcode or zipcode.

leg2_country, leg2_city, leg2_postcode, leg2_street are fields that form an address.

One of address, leg2_coordinates, leg2_locode, leg2_distance_km is required.

As part of an address, to ensure accuracy, leg2_country is required and at least one of leg2_street, leg2_postcode, leg2_city.

---

leg2_streetstring

Leg street.

leg2_country, leg2_city, leg2_postcode, leg2_street are fields that form an address.

One of address, leg2_coordinates, leg2_locode, leg2_distance_km is required.

As part of an address, to ensure accuracy, leg2_country is required and at least one of leg2_street, leg2_postcode, leg2_city.

---

leg2_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg2_coordinates, leg2_locode, leg2_distance_km is required.

---

leg2_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg2_coordinates, leg2_locode, leg2_distance_km is required.

---

leg2_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg2_coordinates, leg2_locode, leg2_distance_km is required.

---

leg3_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg3_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg3_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg3_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg3_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg3_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg3_departure_on and leg3_arrival_on and one of leg3_imo_number, leg3_vessel_name is provided, vessel tracking will be attempted.

---

leg3_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the arrival to the destination port.

If leg3_departure_on and leg3_arrival_on and one of leg3_imo_number, leg3_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg3_countrystring

Pick up 3-letter ISO 3166 country code. leg3_country, leg3_city, leg3_postcode, leg3_street are fields that form an address. One of address, leg3_coordinates, leg3_locode, leg3_distance_km is required. As part of an address, to ensure accuracy, leg3_country is required and at least one of leg3_street, leg3_postcode, leg3_city. Examples GBR, ISR.

---

leg3_citystring

Leg city.

leg3_country, leg3_city, leg3_postcode, leg3_street are fields that form an address.

One of address, leg3_coordinates, leg3_locode, leg3_distance_km is required.

As part of an address, to ensure accuracy, leg3_country is required and at least one of leg3_street, leg3_postcode, leg3_city.

---

leg3_postcodestring

Leg postcode or zipcode.

leg3_country, leg3_city, leg3_postcode, leg3_street are fields that form an address.

One of address, leg3_coordinates, leg3_locode, leg3_distance_km is required.

As part of an address, to ensure accuracy, leg3_country is required and at least one of leg3_street, leg3_postcode, leg3_city.

---

leg3_streetstring

Leg street.

leg3_country, leg3_city, leg3_postcode, leg3_street are fields that form an address.

One of address, leg3_coordinates, leg3_locode, leg3_distance_km is required.

As part of an address, to ensure accuracy, leg3_country is required and at least one of leg3_street, leg3_postcode, leg3_city.

---

leg3_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg3_coordinates, leg3_locode, leg3_distance_km is required.

---

leg3_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg3_coordinates, leg3_locode, leg3_distance_km is required.

---

leg3_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg3_coordinates, leg3_locode, leg3_distance_km is required.

---

leg4_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg4_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg4_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg4_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg4_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg4_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg4_departure_on and leg4_arrival_on and one of leg4_imo_number, leg4_vessel_name is provided, vessel tracking will be attempted.

---

leg4_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the arrival to the destination port.

If leg4_departure_on and leg4_arrival_on and one of leg4_imo_number, leg4_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg4_countrystring

Pick up 3-letter ISO 3166 country code. leg4_country, leg4_city, leg4_postcode, leg4_street are fields that form an address. One of address, leg4_coordinates, leg4_locode, leg4_distance_km is required. As part of an address, to ensure accuracy, leg4_country is required and at least one of leg4_street, leg4_postcode, leg4_city. Examples GBR, ISR.

---

leg4_citystring

Leg city.

leg4_country, leg4_city, leg4_postcode, leg4_street are fields that form an address.

One of address, leg4_coordinates, leg4_locode, leg4_distance_km is required.

As part of an address, to ensure accuracy, leg4_country is required and at least one of leg4_street, leg4_postcode, leg4_city.

---

leg4_postcodestring

Leg postcode or zipcode.

leg4_country, leg4_city, leg4_postcode, leg4_street are fields that form an address.

One of address, leg4_coordinates, leg4_locode, leg4_distance_km is required.

As part of an address, to ensure accuracy, leg4_country is required and at least one of leg4_street, leg4_postcode, leg4_city.

---

leg4_streetstring

Leg street.

leg4_country, leg4_city, leg4_postcode, leg4_street are fields that form an address.

One of address, leg4_coordinates, leg4_locode, leg4_distance_km is required.

As part of an address, to ensure accuracy, leg4_country is required and at least one of leg4_street, leg4_postcode, leg4_city.

---

leg4_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg4_coordinates, leg4_locode, leg4_distance_km is required.

---

leg4_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg4_coordinates, leg4_locode, leg4_distance_km is required.

---

leg4_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg4_coordinates, leg4_locode, leg4_distance_km is required.

---

leg5_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg5_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg5_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg5_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg5_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg5_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg5_departure_on and leg5_arrival_on and one of leg5_imo_number, leg5_vessel_name is provided, vessel tracking will be attempted.

---

leg5_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the arrival to the destination port.

If leg5_departure_on and leg5_arrival_on and one of leg5_imo_number, leg5_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg5_countrystring

Pick up 3-letter ISO 3166 country code. leg5_country, leg5_city, leg5_postcode, leg5_street are fields that form an address. One of address, leg5_coordinates, leg5_locode, leg5_distance_km is required. As part of an address, to ensure accuracy, leg5_country is required and at least one of leg5_street, leg5_postcode, leg5_city. Examples GBR, ISR.

---

leg5_citystring

Leg city.

leg5_country, leg5_city, leg5_postcode, leg5_street are fields that form an address.

One of address, leg5_coordinates, leg5_locode, leg5_distance_km is required.

As part of an address, to ensure accuracy, leg5_country is required and at least one of leg5_street, leg5_postcode, leg5_city.

---

leg5_postcodestring

Leg postcode or zipcode.

leg5_country, leg5_city, leg5_postcode, leg5_street are fields that form an address.

One of address, leg5_coordinates, leg5_locode, leg5_distance_km is required.

As part of an address, to ensure accuracy, leg5_country is required and at least one of leg5_street, leg5_postcode, leg5_city.

---

leg5_streetstring

Leg street.

leg5_country, leg5_city, leg5_postcode, leg5_street are fields that form an address.

One of address, leg5_coordinates, leg5_locode, leg5_distance_km is required.

As part of an address, to ensure accuracy, leg5_country is required and at least one of leg5_street, leg5_postcode, leg5_city.

---

leg5_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg5_coordinates, leg5_locode, leg5_distance_km is required.

---

leg5_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg5_coordinates, leg5_locode, leg5_distance_km is required.

---

leg5_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg5_coordinates, leg5_locode, leg5_distance_km is required.

---

leg6_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg6_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg6_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg6_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg6_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg6_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg6_departure_on and leg6_arrival_on and one of leg6_imo_number, leg6_vessel_name is provided, vessel tracking will be attempted.

---

leg6_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the arrival to the destination port.

If leg6_departure_on and leg6_arrival_on and one of leg6_imo_number, leg6_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg6_countrystring

Pick up 3-letter ISO 3166 country code. leg6_country, leg6_city, leg6_postcode, leg6_street are fields that form an address. One of address, leg6_coordinates, leg6_locode, leg6_distance_km is required. As part of an address, to ensure accuracy, leg6_country is required and at least one of leg6_street, leg6_postcode, leg6_city. Examples GBR, ISR.

---

leg6_citystring

Leg city.

leg6_country, leg6_city, leg6_postcode, leg6_street are fields that form an address.

One of address, leg6_coordinates, leg6_locode, leg6_distance_km is required.

As part of an address, to ensure accuracy, leg6_country is required and at least one of leg6_street, leg6_postcode, leg6_city.

---

leg6_postcodestring

Leg postcode or zipcode.

leg6_country, leg6_city, leg6_postcode, leg6_street are fields that form an address.

One of address, leg6_coordinates, leg6_locode, leg6_distance_km is required.

As part of an address, to ensure accuracy, leg6_country is required and at least one of leg6_street, leg6_postcode, leg6_city.

---

leg6_streetstring

Leg street.

leg6_country, leg6_city, leg6_postcode, leg6_street are fields that form an address.

One of address, leg6_coordinates, leg6_locode, leg6_distance_km is required.

As part of an address, to ensure accuracy, leg6_country is required and at least one of leg6_street, leg6_postcode, leg6_city.

---

leg6_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg6_coordinates, leg6_locode, leg6_distance_km is required.

---

leg6_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg6_coordinates, leg6_locode, leg6_distance_km is required.

---

leg6_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg6_coordinates, leg6_locode, leg6_distance_km is required.

---

leg7_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg7_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg7_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg7_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg7_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg7_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg7_departure_on and leg7_arrival_on and one of leg7_imo_number, leg7_vessel_name is provided, vessel tracking will be attempted.

---

leg7_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the arrival to the destination port.

If leg7_departure_on and leg7_arrival_on and one of leg7_imo_number, leg7_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg7_countrystring

Pick up 3-letter ISO 3166 country code. leg7_country, leg7_city, leg7_postcode, leg7_street are fields that form an address. One of address, leg7_coordinates, leg7_locode, leg7_distance_km is required. As part of an address, to ensure accuracy, leg7_country is required and at least one of leg7_street, leg7_postcode, leg7_city. Examples GBR, ISR.

---

leg7_citystring

Leg city.

leg7_country, leg7_city, leg7_postcode, leg7_street are fields that form an address.

One of address, leg7_coordinates, leg7_locode, leg7_distance_km is required.

As part of an address, to ensure accuracy, leg7_country is required and at least one of leg7_street, leg7_postcode, leg7_city.

---

leg7_postcodestring

Leg postcode or zipcode.

leg7_country, leg7_city, leg7_postcode, leg7_street are fields that form an address.

One of address, leg7_coordinates, leg7_locode, leg7_distance_km is required.

As part of an address, to ensure accuracy, leg7_country is required and at least one of leg7_street, leg7_postcode, leg7_city.

---

leg7_streetstring

Leg street.

leg7_country, leg7_city, leg7_postcode, leg7_street are fields that form an address.

One of address, leg7_coordinates, leg7_locode, leg7_distance_km is required.

As part of an address, to ensure accuracy, leg7_country is required and at least one of leg7_street, leg7_postcode, leg7_city.

---

leg7_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg7_coordinates, leg7_locode, leg7_distance_km is required.

---

leg7_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg7_coordinates, leg7_locode, leg7_distance_km is required.

---

leg7_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg7_coordinates, leg7_locode, leg7_distance_km is required.

---

leg8_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg8_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg8_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg8_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg8_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg8_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg8_departure_on and leg8_arrival_on and one of leg8_imo_number, leg8_vessel_name is provided, vessel tracking will be attempted.

---

leg8_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the arrival to the destination port.

If leg8_departure_on and leg8_arrival_on and one of leg8_imo_number, leg8_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg8_countrystring

Pick up 3-letter ISO 3166 country code. leg8_country, leg8_city, leg8_postcode, leg8_street are fields that form an address. One of address, leg8_coordinates, leg8_locode, leg8_distance_km is required. As part of an address, to ensure accuracy, leg8_country is required and at least one of leg8_street, leg8_postcode, leg8_city. Examples GBR, ISR.

---

leg8_citystring

Leg city.

leg8_country, leg8_city, leg8_postcode, leg8_street are fields that form an address.

One of address, leg8_coordinates, leg8_locode, leg8_distance_km is required.

As part of an address, to ensure accuracy, leg8_country is required and at least one of leg8_street, leg8_postcode, leg8_city.

---

leg8_postcodestring

Leg postcode or zipcode.

leg8_country, leg8_city, leg8_postcode, leg8_street are fields that form an address.

One of address, leg8_coordinates, leg8_locode, leg8_distance_km is required.

As part of an address, to ensure accuracy, leg8_country is required and at least one of leg8_street, leg8_postcode, leg8_city.

---

leg8_streetstring

Leg street.

leg8_country, leg8_city, leg8_postcode, leg8_street are fields that form an address.

One of address, leg8_coordinates, leg8_locode, leg8_distance_km is required.

As part of an address, to ensure accuracy, leg8_country is required and at least one of leg8_street, leg8_postcode, leg8_city.

---

leg8_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg8_coordinates, leg8_locode, leg8_distance_km is required.

---

leg8_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg8_coordinates, leg8_locode, leg8_distance_km is required.

---

leg8_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg8_coordinates, leg8_locode, leg8_distance_km is required.

---

leg9_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg9_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg9_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg9_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg9_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg9_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg9_departure_on and leg9_arrival_on and one of leg9_imo_number, leg9_vessel_name is provided, vessel tracking will be attempted.

---

leg9_arrival_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the arrival to the destination port.

If leg9_departure_on and leg9_arrival_on and one of leg9_imo_number, leg9_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg9_countrystring

Pick up 3-letter ISO 3166 country code. leg9_country, leg9_city, leg9_postcode, leg9_street are fields that form an address. One of address, leg9_coordinates, leg9_locode, leg9_distance_km is required. As part of an address, to ensure accuracy, leg9_country is required and at least one of leg9_street, leg9_postcode, leg9_city. Examples GBR, ISR.

---

leg9_citystring

Leg city.

leg9_country, leg9_city, leg9_postcode, leg9_street are fields that form an address.

One of address, leg9_coordinates, leg9_locode, leg9_distance_km is required.

As part of an address, to ensure accuracy, leg9_country is required and at least one of leg9_street, leg9_postcode, leg9_city.

---

leg9_postcodestring

Leg postcode or zipcode.

leg9_country, leg9_city, leg9_postcode, leg9_street are fields that form an address.

One of address, leg9_coordinates, leg9_locode, leg9_distance_km is required.

As part of an address, to ensure accuracy, leg9_country is required and at least one of leg9_street, leg9_postcode, leg9_city.

---

leg9_streetstring

Leg street.

leg9_country, leg9_city, leg9_postcode, leg9_street are fields that form an address.

One of address, leg9_coordinates, leg9_locode, leg9_distance_km is required.

As part of an address, to ensure accuracy, leg9_country is required and at least one of leg9_street, leg9_postcode, leg9_city.

---

leg9_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg9_coordinates, leg9_locode, leg9_distance_km is required.

---

leg9_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg9_coordinates, leg9_locode, leg9_distance_km is required.

---

leg9_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg9_coordinates, leg9_locode, leg9_distance_km is required.

---

leg10_method

The transport method.

Required unless imo or vessel_name is provided.

Pick one of the following options.

Examples: cargo_plane, container_ship, diesel_truck.

One of

---

leg10_refrigeratedenum

A container transport is either refrigerated or "dry" (not refrigerated). Dry transports result in lower emissions. For road transport this value is also taken in consideration if set to true, the appropriate refrigerated shipping method will be used.

Enum:

• TRUE
• true
• FALSE
• false

---

leg10_trade_lane

trade_lane requires method to be `container_ship'.

One of

---

leg10_imo_numberstring^$|^[0-9]{7}$

The vessel's IMO number without the IMO prefix.

When an imo is provided, the leg's method is ignored.

---

leg10_vessel_namestring

The vessel's name. If an IMO is provided this property will be unused.

When a vessel name that corresponds to a single ship is provided, the leg's method is ignored.

---

leg10_departure_onstring^$|^[0-9]{4}-(1[0-2]|0[1-9])-(3[01]|[12][0-9]|0[1-9])$

The date of the departure from the source port.

Vessel tracking is only available for departures within the past 3 months.

If leg10_departure_on and leg10_arrival_on and one of leg10_imo_number, leg10_vessel_name is provided, vessel tracking will be attempted.

---

leg10_arrival_onstring

The date of the arrival to the destination port.

If leg10_departure_on and leg10_arrival_on and one of leg10_imo_number, leg10_vessel_name is provided, vessel tracking will be attempted.

We can only perform vessel tracking for shipments that finished more than 24 hours ago.

---

leg10_countrystring

Pick up 3-letter ISO 3166 country code. leg10_country, leg10_city, leg10_postcode, leg10_street are fields that form an address. One of address, leg10_coordinates, leg10_locode, leg10_distance_km is required. As part of an address, to ensure accuracy, leg10_country is required and at least one of leg10_street, leg10_postcode, leg10_city. Examples GBR, ISR.

---

leg10_citystring

Leg city.

leg10_country, leg10_city, leg10_postcode, leg10_street are fields that form an address.

One of address, leg10_coordinates, leg10_locode, leg10_distance_km is required.

As part of an address, to ensure accuracy, leg10_country is required and at least one of leg10_street, leg10_postcode, leg10_city.

---

leg10_postcodestring

Leg postcode or zipcode.

leg10_country, leg10_city, leg10_postcode, leg10_street are fields that form an address.

One of address, leg10_coordinates, leg10_locode, leg10_distance_km is required.

As part of an address, to ensure accuracy, leg10_country is required and at least one of leg10_street, leg10_postcode, leg10_city.

---

leg10_streetstring

Leg street.

leg10_country, leg10_city, leg10_postcode, leg10_street are fields that form an address.

One of address, leg10_coordinates, leg10_locode, leg10_distance_km is required.

As part of an address, to ensure accuracy, leg10_country is required and at least one of leg10_street, leg10_postcode, leg10_city.

---

leg10_coordinatesstring^$|^lat -?[0-9]+(\.[0-9]+)? lon -?[0-9]+(\.[0-9]+)?$

Leg geographical coordinates formatted as 'lat <number> lon <number>'

One of address, leg10_coordinates, leg10_locode, leg10_distance_km is required.

---

leg10_locodestring^$|^[A-Z]{5}$

UN LOCODE. For a full list of options https://unece.org/trade/cefact/unlocode-code-list-country-and-territory.

One of address, leg10_coordinates, leg10_locode, leg10_distance_km is required.

---

leg10_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg provided distance.

One of address, leg10_coordinates, leg10_locode, leg10_distance_km is required.

Upload and wait for results

Once you've filled the sheet, drop the file in the appropriate box.

Depending on the size, it may take a few minutes to process the sheet.

You'll receive an email when the results are ready.

Please follow the link in your email to download the results.

We apply your API rate limit when processing a sheet.

Results

The following columns are added to the columns provided by you.

estimate_idstringrequired

The estimate's unique id.

To understand how we have calculated emissions, visit the following page:

https://dashboard.lune.co/calculate-emissions/multi-leg-shipping/<ESTIMATE_ID>/results

---

dashboard_urlstringrequired

The URL pointing to the specific emission calculation page in the Lune dashboard.

Here you can:

• review your estimate
• read how Lune has calculated your emissions
• offset your emissions

---

client_account_analytics_urlstring

The URL pointing to the specific client account's analytics page.

This column is populated when client_account_handle is provided.

Here your customers can:

• view their shipment analytics
• view individual shipment estimates
• read how Lune has calculated their emissions

---

total_mass_tco2string^$|^[0-9]+(\.[0-9]+)?$required

Overall emission estimate in tCO2e.

---

total_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$required

Overall shipment distance in km.

---

total_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$required

Overall shipment distance in km inclusive of distance adjustment factors.

---

errorstringrequired

Describes the error that occured when processing the row.

When set, the row has failed to process and does not return results.

Please correct the provided data.

---

leg1_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$required

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg1_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg1_total_tco2string^$|^[0-9]+(\.[0-9]+)?$required

Leg emission estimate in tCO2e.

---

leg2_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg2_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg2_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

---

leg3_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg3_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg3_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

---

leg4_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg4_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg4_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

---

leg5_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg5_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg5_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

---

leg6_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg6_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg6_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

---

leg7_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg7_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg7_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

---

leg8_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg8_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg8_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

---

leg9_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg9_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg9_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.

---

leg10_estimated_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance in km.

Equivalent to leg*_distance_km when leg*_distance_km is provided.

---

leg10_estimated_adjusted_distance_kmstring^$|^[0-9]+(\.[0-9]+)?$

Leg estimated distance inclusive of distance adjustment factors in km.

---

leg10_total_tco2string^$|^[0-9]+(\.[0-9]+)?$

Leg emission estimate in tCO2e.