Importing fleet vehicles from Excel
On this page
Opening fleet vehicles and downloading the template
This guide explains how to import fleet vehicles from Excel and review and correct a duplicate row. Open Transportation, then Transport Settings, then Vehicles.
Read the column guide in the catalogue and the notes attached to header cells. Save the data as xlsx.
Completing the vehicle details
plate_no is the vehicle plate number. Fill it in and check that it is not duplicated. chassis_no is optional chassis text. motor_number is the optional engine number.
model is an optional model year or model name. vehicle_type_serial is the optional vehicle type serial from the catalogue. vehicle_brand is optional brand text.
Use your company’s actual vehicle details when preparing your data. The identifiers shown here are training examples.
Choosing the vehicle type serial
After importing, review the type in the vehicle list and in the vehicle details.
Uploading and reviewing a partial success
A was added as serial 8 and the vehicle count became eight. Do not resubmit the successful row.
Correcting the duplicate plate
Check that the new plate is absent from the list, then upload the corrected file with the original six columns and no error column.
Reviewing the second vehicle import
Open Edit to review the plate, chassis, engine, model, brand and vehicle type before using the record in operations.
Reviewing both saved records
Compare the fields with your workbook, then choose Close to leave the review without saving changes.
Sign in to record the lessons you have read. Sign in