Meter Entries 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 the  most recent meter entries for 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.

Meter Entries Import File: Columns & Values

Fleetio recommends using the Meter Readings Import template found under Settings > Imports when importing meter 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.

Column Required? Notes
vehicle_name Yes Nickname or number to distinguish vehicle in Fleetio. Must match Vehicle Name in Fleetio exactly. SEE:  Vehicle Naming Conventions
current_meter_value No For reference purposes only. No data in this field will be imported into Fleetio.     
current_meter_date No  

For reference purposes only. No data in this field will be imported into Fleetio.

new_meter_value Yes

Most updated meter reading for a vehicle (no commas)

  • Example: 147550
new_meter_date Yes Date that should be displayed for the new_meter_value. Must be in the Short Date Format specified for the account under Settings > Account Settings. Date format must be consistent throughout file.        
  • Example: 07/15/2014
  • Example: 15/07/2014
current_secondary_meter_value No    
For reference purposes only. No data in this field will be imported into Fleetio.
current_secondary_meter_date No For reference purposes only. No data in this field will be imported into Fleetio.
new_secondary_meter_value No    
Most updated secondary meter reading for a vehicle (no commas)    
  • Example: 147550
new_secondary_meter_date No Date that should be displayed for the new_secondary_meter_value. Must be in the Short Date Format specified for the account under Settings > Account Settings. Date format must be consistent throughout file.      
  • Example: 07/15/2014
  • Example: 15/07/2014

Still need help? Contact Us Contact Us