CSV upload
Calculate the CO₂e emissions for your shipment by uploading a CSV.Pre-requisites
Complete the following setup steps before using this guide:1. Fill in the CSV
Each row in the CSV represents a single shipment, supporting up to 10 legs per shipment. At least one leg is required per row. Each shipment must have the distance travelled, cargo weight, and transport method in order to be processed.We've outlined, below, the minimum requirements for successful use of Lune's CSV uploader. For a full list of headings that can be used in the CSV, as well as details about formatting, please see the CSV reference.Minimum requirements
For a single leg shipment, with a known source and destination, the following headings should be included to be able to run an emission estimate calculation:version
mass_kg
source
leg1_destination
leg1_method
- Sea shipment template: Five single-leg shipments by sea.
- Road shipment template: Three single-leg shipments by road.
- Air shipment template: Three single-leg shipments by air.
- Train shipment template: Three single-leg shipments by train.
- Multi-modal template. Three shipments with three legs each, using different transport methods. You can create a multi-modal sheet by combining the columns of the sea, road and air templates.
For multi-leg shipments, use the prefix
legx_
, replacing x
with the leg number to identify values that are unique to each leg. For example, use leg1_
for the first leg and leg6_
for the sixth leg.Cargo weight
Cargo weight must be included in the CSV. However, it can be expressed using mass or number of containers. If you have both pieces of information, we recommend adding both for a more accurate estimate.mass_kg
containers
Distance or route
Distance travelled must be included in the CSV. However, it can be expressed through number of kilometres, or the source and destination of a leg.legx_distance_km
source
legx_destination
- Comma-seperated address, ending with a country code: The country code is a 3-letter ISO 3166 country code. For example,
Apple Lane, London, SW1A 2AA, GBR
. - UN LOCODE For example,
CA
. - IATA or ICAO airport code: For example,
LHR
. - Geographical coordinates: Should be formatted as
lat x lon y
. For example:lat 43.65 lon 79.38
.
Transport method
Specify the transport method for each leg using thelegx_method
heading. Common values include:cargo_plane
container_ship
diesel_truck
legx_method
column blank and instead provide the vessel’s IMO number or name under legx_vessel_identification
. Examples include:- IMO number:
9619969
- Vessel name:
MARIBO MAERSK
Tracking and analytics
If you'd like to seperate the calculations by your end customer, you can include the following headers in each row. By including these headers, Lune can provide tailored analytics to each of your end customers.shipment_id
client_account_id
client_account_handle
client_account_currency
is_shipment
shipped_at
2. Upload the CSV
Populate the CSV sheet using your preferred editor. You can either omit or leave blank any non-required columns. Once all required values have been added, save the file in.csv
format, ensuring it has the .csv
file extension.Next, go to the logistics spreadsheet calculation page to upload your file. You can upload the CSV by either dragging and dropping it onto the page or clicking the Upload button to select the file manually. Make sure the file size does not exceed 2MB.
3. Interpret the results
Once the sheet has been processed and you receive the confirmation email, you can download the results directly from the confirmation email.The results are also available in a table at the bottom of the logistics spreadsheet calculation page. This table displays each upload, the number of calculations processed, and provides an option to download the results.The results are provided in CSV format. Your original submitted data remains intact, with a few additional headings added to the results file:estimate_id
dashboard_url
total_mass_tco2
legx_total_tco2