Vehicle Import Guide

TIP: Please view our training video to learn more about Imports

New to importing data into Fleetio? Be sure to read the overview article first or watch our video on how to prepare your import data file.

This guide provides an overview of the of the file requirements and supported values for importing vehicles in Fleetio. 

IMPORTANT: All import files must be in the .csv format and meet .csv file standards. Go to http://csvlint.io/ to validate the .csv file if necessary. 

If you have issues with Importing your data using a .csv file created by Excel, please try using Google Sheets or Apple's Numbers.  Excel can sometimes cause data issues when saving .csv files.

Vehicle Import File: Columns & Values

Fleetio recommends using the Vehicle Import template found under Settings > Imports when importing vehicle data.

NOTE: If using a custom template from another system, modifications to the file may be needed to ensure the data is in the proper format and can be matched up to data in Fleetio.

Import Guide

Column Required? Notes
id No*
*Only required for updating existing vehicles
This field should be left blank for all new vehicles being added and only be used when updating existing vehicles in Fleetio. SEE:  Updating Data via Import File
name Yes Nickname or number to distinguish vehicle in Fleetio. SEE:  Vehicle Naming Conventions
year No Must be in "YYYY" format
make No
model No
trim No
meter_unit Yes Must be one of the following (default: "mi") 
  • mi
  • km
  • hr
fuel_volume_unit Yes Must be one of the following (default: "us_gallons")
  • us_gallons
  • uk_gallons
  • liters
status Yes Example: "Active"   
Text can match an existing Vehicle Status already setup for the Account, or a new Vehicle Status will be created if no match is found during the import.
type Yes Example: "Truck"   
Text can match an existing Vehicle Type already setup for the Account, or a new Vehicle Type will be created if no match is found during the import.  
group No Text can match an existing  Group and/or Subgroup already set up for the account, or a new Group will be created if it does not match up.
  • Example (group): Chicago
  • Example (subgroup): Chicago|Warehouse-01
    NOTE: Use the "pipe" character | to separate groups and subgroups. No spaces between elements are needed.
vin No Vehicle Identification Number or equipment’s Serial Number  (Must be unique)
color No
license_plate No
current_meter No

Current odometer or hour meter value (no commas) unless escaped by double quotes in file

secondary_meter_unit No Must be one of the following (default: "mi") 
  • mi
  • km
  • hr
secondary_meter_value No Current secondary meter or hour meter value (no commas) unless escaped by double quotes in file
purchase_date

Yes*
* only required if Purchase Meter is present 


Most date formats are parseable, but should try to use something like: "Jun 26, 2009"
purchase_price No 
Include the number without commas or currency symbol
purchase_meter No*
* must also specify Purchase Date if present 
Odometer or Hour Meter value at the time of purchase
warranty_expiration_date No Date the warranty expires
warranty_expiration_meter No Meter value for when the warranty expires
loan_account_number No Loan or lease account number
loan_amount No Total amount of the loan
loan_started_at No Date the loan or lease started
loan_ended_at No Date the loan or lease ends (or ended if in the past)
loan_interest_rate No Interest rate of the loan or lease
loan_notes No General notes about the loan or lease
loan_payment No Amount of the monthly loan or lease payment
residual_value No Estimated vehicle worth when the lease ends
currency No See the   Currency Codes article for a complete list of codes
registration_state No
ownership Yes   Must be one of the following (default if not set: "Owned") 
  • Owned
  • Leased
  • Rented
  • Customer
system_of_measurement Yes Must be one of the following (default if not set: "Imperial") 
  • Imperial
  • Metric
body_type No Standard Body Types are: Convertible, Coupe, Mini-Van, Pickup, SUV and Sedan

*If a different Body Type is listed in the import file, it will be added as a new option to your system's list of available Body Type's.
body_subtype No Standard Body Subtypes are: Crew Cab, Extended Cab and Passenter

*If a different Body Subtype is listed in the import file, it will be added as a new option to your system's list of available Body Subtypes.
drive_type No Standard Drive Type options are: 4x2, 4x4, AWD, FWD, and RWD

*If a different Drive Type is listed in the import file, it will be added as a new option to your system's list of available Drive Types.
brake_system No The standard brake system option is Hydraulic. 

*If a different Brake System type is listed in the import file, it will be added as a new option to your system's list of available Brake System's.
msrp_cents No  
fuel_tank_capacity No  
fuel_tank_2_capacity No  
front_track_width No
ground_clearance No
height No
length No
rear_track_width No
width No
wheelbase No
front_tire_psi No 

rear_tire_psi No 

base_towing_capacity No
curb_weight No
gross_vehicle_weight_rating No
bed_length No
max_payload No
rear_axle_type No
front_tire_type No
front_wheel_diameter No
rear_tire_type No
rear_wheel_diameter No
epa_city No
epa_highway No     
epa_combined No
engine_description No
engine_brand No
engine_aspiration No Standard Aspiration options are: Naturally Aspirated, Turbocharger, and Twin Turbocharger

*If a different Aspiration type is listed in the import file, it will be added as a new option to your system's list of available Aspiration types.
engine_block_type No
engine_bore No
engine_cam_type No Standard Cam Types are: DOHC, OHV, and SOHC

*If a different Cam Type is listed in the import file, it will be added as a new option to your system's list of available Cam Types.
engine_compression No
engine_cylinders No  
engine_displacement No  
fuel_induction No  
fuel_quality No
max_hp No
max_torque No
oil_capacity No
redline_rpm No
engine_stroke No
engine_valves No
transmission_description No 

transmission_brand No 

transmission_type No Standard Transmission Types are: Automatic, Continuously Variable, and Manual

*If a different Transmission Type is listed in the import file, it will be added as a new option to your system's list of available Transmission Types.
transmission_gears No
cargo_volume No
interior_volume No
passenger_volume No

NOTE: Custom Fields can be setup under Settings > Custom Fields. Any Custom Fields with the "Vehicle" record type will also be available to import data into. 

Still need help? Contact Us Contact Us