Import Vehicles


This option, found in both the Resources->Fleet and Routing->Vehicles pages, lets you import a CSV or Excel file with your vehicles or drivers. The template is available here. If you already have a file with your vehicles or drivers, simply make a copy and change the column header/field names to match those of RouteFinder. You need only include what you want and the only fields absolutely required are: vehicle_id, shift_start, shift_end and a start_location. There are three options for entering the start location:

  • Just start_address
  • start_latitude and start_longitude
  • All of the location information in their respective standard international address format fields


Column Names

The following column names are accepted and correspond to those found in the Add/Edit Vehicle form:

  • vehicle_id required
  • driver_name
  • driver_phone
  • driver_email
  • group
    • Comma separated list of groups
    • Each group should be in string format (text)
  • notes
  • shift_start required
    • In 24h HH:MM format, ie: 09:00
  • shift_end required
    • In 24h HH:MM format, ie: 17:00
  • flexible_start
    • true or false
  • speed
    • Percentage of average speed in decimal format
  • capacity
  • start_address
    • If this field is used, no need for any more start location identifiers
  • start_address_line1
  • start_address_line2
  • start_city
  • start_district
    • District or County
  • start_region
    • Region, Province, or State
  • start_postcode
    • Postal Code, Postcode, or Zip Code
  • start_country
  • start_latitude
    • Decimal format
    • if this field is used, must have start_longitude, no other end location identifiers required
  • start_longitude
    • Decimal format
    • if this field is used, must have start_latitude, no other end location identifiers required
  • use_start_address
    • true or false
    • If this field is used, no other end location identifiers required
  • end_address
    • If this field is used, no need for any more end location identifiers
  • end_address_line1
  • end_address_line2
  • end_city
  • end_district
    • District or County
  • end_region
    • Region, Province, or State
  • end_postcode
    • Postal Code, Postcode, or Zip Code
  • end_country
  • end_latitude
    • Decimal format
    • if this field is used, must have end_longitude, no other end location identifiers required
  • end_longitude
    • Decimal format
    • if this field is used, must have end_latitude, no other end location identifiers required