Importing drivers from Excel
On this page
Opening Drivers and downloading the template
This guide explains how to import drivers from Excel, review successful and rejected rows, and retry only corrected rows. Open Transportation, then Transport Settings, then Drivers.
Read the catalogue and the notes attached to header cells. Prepare accurate names and valid birth dates before uploading.
Completing the five fields
name is the driver display name. Fill it in and check that it does not duplicate an existing driver in the company. date_of_birth is optional; use a valid date cell, such as 1990-05-15.
address is optional address text. mobile_no is optional phone text; store it as text to retain a leading zero. license_no is the optional driving licence number.
A driver is linked to an accounting ledger during import. Review the Drivers mapping in Account Settings with the accountant before importing new drivers.
Uploading the file and reviewing the result
Check the driver list after the operation finishes. In this example, A was added as serial 8 and B was absent. Verify that the rejected record is absent before uploading it again.
Reviewing the rejection report and correcting the date
Save the corrected file, upload it through Import Excel and confirm Yes once.
Reviewing the corrected import and final list
Match each name and its details with your workbook, leaving the existing drivers unchanged.
Checking driver details and the linked ledger
A is linked to ledger 21300010008 and B to 21300010009, each named after its driver. Review the linked ledger field in the form with the accountant.
Sign in to record the lessons you have read. Sign in