Skip to main content
J. J. Keller Support Center

Import Vehicles or Employees in FleetMentor

Notes about Importing records:

  • Review the individual specifications/instructions for each field. You can find instructions on-screen, or on the first Sheet of the downloaded template.
  • Fields shown in red are required for importing into FleetMentor. However, the more complete the import file is, the more efficient your time in FleetMentor will be.
  • The import feature can only add records to your system; it will not update existing records.

 

Below walks through importing Vehicles and Employees.


Import Vehicles/Equipment

Select the Toolbox tab.

clipboard_efc2ea1746edd4192c1ee31a9fb39ef0a.png

Select Vehicles & Equipment.

clipboard_ef7428782918b741465ec8b7fc69c512c.png

In the left side panel, click Import Records.

clipboard_e675a03ef9214e661eef1166385a0cf8a.png

To complete the vehicle and equipment import, we require that all data be entered in a special Excel spreadsheet designed specifically for this upload tool. To download the spreadsheet template, click the Download link. Then, click "Save" when prompted and open the file after it finishes downloading. This will allow you to save the template to your computer.

clipboard_e48fee63536bee195aa941f9555385a4b.png

Review import requirements and complete the spreadsheet. Requirement information can be found in the first Sheet of the template document, or by clicking the Review link in FleetMentor.

clipboard_ec2e7c3c85ee07cbe8f7a79b1d587496e.png

Important note: When adding records to your template, if you have any locations that are not already in the FleetMentor system, they will be added as a non-separate entity. If the new location is a separate entity, you must go to Company Profile and change that location to a separate entity.

 

Example of Template:

clipboard_e751e3b1b70cd0487e64f59864efda7b8.png

 

When you have completed the template with your vehicle information, click Upload in FleetMentor. Then, click Choose File to select the completed template from your device. Select Upload.

clipboard_eaad7aab35317077b2424fe20870370ae.png

clipboard_e5928c186396a252e8fdcd763854889f7.png

Your import file will upload and you will be notified via email when the process has been completed or if any problems are encountered. Imported records are usually available for use in 1-2 business days.

 

Import Employees/Drivers

Select the Toolbox tab.

clipboard_efc2ea1746edd4192c1ee31a9fb39ef0a.png

Select Employees & Drivers under the Personnel section.

clipboard_e023f65c4a0978646e0e7f415556f31c4.png

In the left panel, click Employee Import.

clipboard_edde3d8c1bbe5ccf167804a5b0743d487.png

To complete the employee/driver import, we require that all data be entered in a special Excel spreadsheet designed specifically for this upload tool. To download the spreadsheet template, click the Download link. Then, click "Save" when prompted and open the file after it finishes downloading. This will allow you to save the template to your computer.

clipboard_e68137549524f3c5a0846c368dffbb5dc.png

Review import requirements and complete the spreadsheet. Requirement information can be found in the first Sheet of the template document, or by clicking the Review link in FleetMentor.

clipboard_e114dffeedd3fc31f7277a838b767e4ce.png

Example of Template:

clipboard_ed6d71f1976915e2b2bb0d4b6c8d7f5c6.png

When you have completed the template with your vehicle information, click Upload in FleetMentor. Then, click Choose File to select the completed template from your device. Select Upload.

clipboard_e18491363618ad086da5b1ee718260e0b.png

clipboard_e0bb7898a0981f518ee231a3f9a794263.png

Your import file will upload and you will be notified via email when the process has been completed or if any problems are encountered. Imported records are usually available for use in 1-2 business days.

  • Was this article helpful?