Table of Contents
IMPORTANT: The best place to find information about Data Imports in Fleetio is the New Data Import Overview article. This resource includes step-by-step instructions, training videos, and guidance on how to prepare your import data file.
This guide provides an overview of the file requirements and supported values for importing Meter Readings for vehicles in Fleetio. Each entry includes a meter value and a corresponding date, so you may import historical data and/or current readings.
Secondary Meter Value Import
The term Meter is used in Fleetio as a generic way to describe an odometer, hour meter, auxiliary meter, etc. Meters are used to track vehicle and equipment usage and may be configured for various measurement units.
A Secondary Meter is only relevant for some Vehicles and large equipment, so this is an optional configuration that may be enabled on a per-Vehicle basis. If Secondary Meter values are imported, these will only display if the Secondary Meter is enabled on the Vehicle in question. Otherwise, the values are imported but remain hidden.
TIP: Learn more in the Meter Overview article.
Meter Readings Import Template
We recommend using the Meter Readings Import Template.
- Go to the + Quick Add menu and select Import Data.
- Click Browse Import Templates.
- Select the Vehicles template type on the left, then select Meter Entry.
- Click the Download dropdown and select Empty Template
NOTE: If you are using a spreadsheet generated from another system, modifications to the file type and data may be needed to ensure the proper format and data mapping.
Data Requirements
Be sure to note the Required section and columns in the charts below.
Columns marked Yes are always Required, whereas those marked No may be left as blank cells in the import file - the entire column can be skipped during the mapping process if it is omitted for all rows.
Columns marked * See Below have special conditions required under certain circumstances; these are explained in footnotes beneath the chart.
Each row in the import file MUST contain a unique identifier that matches the row to a corresponding Vehicle in Fleetio. The most common columns for this match are the Vehicle Name or VIN from Fleetio; however, an External Vehicle ID could also be added from Account Settings.
IMPORTANT: A unique identifier is required to match each row to the corresponding vehicle in Fleetio. This may be vehicle_name, vehicle_vin, or External ID, so any ONE of these is required, but not all three!
Columns & Values
Required Fields
The fields below are required for Meter Reading imports unless otherwise noted.
| Column | Required? | Notes |
|---|---|---|
| vehicle_name | * See Below | Nickname or number to distinguish vehicle in Fleetio. Must match Vehicle Name in Fleetio exactly. SEE: Vehicle Naming Conventions |
| vehicle_vin | * See Below | Vehicle Identification Number. Must match VIN in Fleetio exactly. |
| new_meter_value | Yes |
Most updated meter reading for a vehicle. Format your meter values as whole numbers or decimals only. Do not include other characters (e.g. comma, colon, dash, etc.).
|
| new_meter_date | Yes | This value is stored as a Date Data Type. For consistency and accuracy, format your data as YYYY-MM-DD. You may also use the Short Date Format from your Account Settings if you prefer. |
* A unique identifier is required to match each row to the corresponding vehicle in Fleetio, as explained in the Data Requirements section above. This may be vehicle_name, vehicle_vin, or External ID, so any ONE of these is required, but not all three!
Other Fields
These fields are not required but are recommended to ensure the accuracy of your data in Fleetio.
| Column | Required? | Notes |
|---|---|---|
| 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_void | No | True/False. Set to True, auto-voids the meter on import. |
| 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. Format your meter values as whole numbers or decimals only. Do not include other characters (e.g. comma, colon, dash, etc.).
|
| new_secondary_meter_date | No | This value is stored as a Date Data Type. For consistency and accuracy, format your data as YYYY-MM-DD. You may also use the Short Date Format from your Account Settings if you prefer. |
| new_secondary_meter_void | No | True/False. Set to True, auto-voids the meter on import. |
Meter Entry Import Process
For detailed step-by-step instructions, refer to the New Data Import Overview article.
