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:
- Route or distance
- Cargo weight
- 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_countryis required and at least one ofpickup_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 aslat <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 kilogramscontainers: 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 theIMOprefix. 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
The row's schema version.
Must be set to 1.
Client shipment identifier
Acts as external id. The field represents the id in your system, which you may use to reconcile emission estimates.
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.
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.
The client account's currency.
This property must be set when client_account_handle is set.
You cannot overwrite a client account's currency.
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.
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 this an estimate for an actual shipment?
- TRUE
- true
- FALSE
- false
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.
Shipment weight in kg.
One of mass_kg and containers is mandatory. You may provide both for more accurate estimates.
Shipment in containers.
One of mass_kg and containers is mandatory. You may provide both for more accurate estimates.
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.
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.
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.
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.
Pick up geographical coordinates formatted as 'lat <number> lon <number>'.
One of address, pickup_coordinates, pickup_locode is required.
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.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg1_coordinates, leg1_locode, leg1_distance_km is required.
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.
Leg provided distance.
One of address, leg1_coordinates, leg1_locode, leg1_distance_km is required.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg2_coordinates, leg2_locode, leg2_distance_km is required.
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.
Leg provided distance.
One of address, leg2_coordinates, leg2_locode, leg2_distance_km is required.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg3_coordinates, leg3_locode, leg3_distance_km is required.
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.
Leg provided distance.
One of address, leg3_coordinates, leg3_locode, leg3_distance_km is required.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg4_coordinates, leg4_locode, leg4_distance_km is required.
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.
Leg provided distance.
One of address, leg4_coordinates, leg4_locode, leg4_distance_km is required.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg5_coordinates, leg5_locode, leg5_distance_km is required.
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.
Leg provided distance.
One of address, leg5_coordinates, leg5_locode, leg5_distance_km is required.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg6_coordinates, leg6_locode, leg6_distance_km is required.
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.
Leg provided distance.
One of address, leg6_coordinates, leg6_locode, leg6_distance_km is required.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg7_coordinates, leg7_locode, leg7_distance_km is required.
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.
Leg provided distance.
One of address, leg7_coordinates, leg7_locode, leg7_distance_km is required.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg8_coordinates, leg8_locode, leg8_distance_km is required.
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.
Leg provided distance.
One of address, leg8_coordinates, leg8_locode, leg8_distance_km is required.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg9_coordinates, leg9_locode, leg9_distance_km is required.
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.
Leg provided distance.
One of address, leg9_coordinates, leg9_locode, leg9_distance_km is required.
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
trade_lane requires method to be `container_ship'.
One of
The vessel's IMO number without the IMO prefix.
When an imo is provided, the leg's method is ignored.
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.
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.
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.
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.
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.
Leg geographical coordinates formatted as 'lat <number> lon <number>'
One of address, leg10_coordinates, leg10_locode, leg10_distance_km is required.
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.
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.
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
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
Overall emission estimate in tCO2e.
Overall shipment distance in km.
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.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
Leg estimated distance in km.
Equivalent to leg*_distance_km when leg*_distance_km is provided.
Leg emission estimate in tCO2e.
