This article covers the CSV/XLSX file format used by Pledge to import data pertaining to last mile delivery and short trips by road where there is no data about the number of passengers or weight of delivery involved.

Before diving into the specific last mile & short trips fields, you are encouraged to first to familiarize yourself with Pledge's general CSV/XLSX file specification for importing data.

There are relatively few data points that are needed to compute emissions estimates for last mile deliveries and short trips:

However, if more precise data is provided then better emissions estimates can be computed. For example, for VEHICLE, instead of specifying just C (for CAR - AVERAGE), if the size of the car is provided e.g. C6 (for CAR - LUXURY) then a more accurate estimate will be computed. Better still, if MAKE and MODEL are provided then that will produce even better results.

It's always best to provide distance if you have it, especially if it is a reflection of the actual distance for a journey that has already happened. If the distance is provided it will always be used for the emissions computations. However, if no distance is provided then you will have to either provide origin and destination addresses or co-ordinates and Pledge will attempt to estimate the appropriate distance.

For display purposes it is ideal to provide address or co-ordinates in addition to distance if that is available.

You can find an empty template and other relevant sample files in our public repository.