_White_Background_square_1920px.png?width=256&height=96&name=FLEETWATCH%20Fleet%20Information%20Technology%20by%20S%26A%20Systems%2c%20Inc%20(06_28_2021)_White_Background_square_1920px.png)
Can Fleetwatch import my vehicle data?
Fleetwatch can import vehicle data
Fleetwatch FMS · Vehicle Setup
Can Fleetwatch Import My Vehicle Data?
Yes. Fill out our vehicle template spreadsheet and send it to Fleetwatch Support. A Fleetwatch technician will prepare the data and import it into your system for you.
How It Works
|
1
Request the template
Ask Fleetwatch Support for the vehicle template spreadsheet.
You
|
2
Fill it out and send it back
Add one row per vehicle and return the spreadsheet to Support.
You
|
3
We import it
A technician cleans up the data and loads it into Fleetwatch.
Fleetwatch
|
Filling Out the Template
Only two fields are required:
| Field | What it is | |
|---|---|---|
| Vehicle Number | Required | The vehicle’s number in Fleetwatch, as entered at the RIH and shown on reports |
| Primary Fuel | Required | The vehicle’s main fuel, such as Diesel, Unleaded, or CNG. The fuel name or your fluid code (for example, D for Diesel) both work. |
| All other fields | Optional | Technically optional, but recommended. See below. |
Fill in as much as you can
The more information you include, the better your data accuracy and integrity. Details such as the odometer, the other fluids each vehicle uses, MPG bounds, make, model, and year help Fleetwatch authorize the right fluids, flag unusual readings, and produce more useful reports.
What’s in the Template
The template has these columns. Required columns are marked in red with an asterisk (*).
| Identification | Vehicle *DescriptionMakeModelYearIN (VIN)LicensePlateEquipmentIDCard |
| Fuel & fluids | PrimaryFuel *Fluid3Fluid3FlagFluid3CutoffFluid4Fluid4FlagFluid4CutoffFluid5Fluid5FlagFluidFlagCutoffFluid6 |
| Mileage & MPG | OdometerMPGUpperBoundMPGCurrentMPGLowerBound |
| Organization | DivisionDeptIsRevenue |
Tips for a Clean Import
| Keep leading zeros | Vehicle numbers often start with zeros (like 000123). Format the Vehicle Number column as Text in Excel before typing or pasting. Otherwise Excel drops the zeros. |
| One row per vehicle | Each vehicle number should appear only once. Check for duplicates before sending. |
| Keep the template layout | Don’t rename, reorder, or delete columns, and avoid merged cells. |
| Fuels go in the fuel columns | Put the vehicle’s fuel in PrimaryFuel. Use Fluid3 through Fluid6 only for oil, ATF, coolant, DEF, and similar fluids. Fuel listed as an extra fluid won’t count toward Total Fuel. For a dual-fuel vehicle, let Support know the second fuel when you send the template. |
What Happens After You Send It
A Fleetwatch technician:
1. Cleans up the data so it’s ready to import.
2. Uses the Fleetwatch Excel Import Utility to produce a formatted import file.
3. System Monitor and Messaging Manager ingest the file, adding the vehicles to your Fleetwatch system.
✔ After the import, open the Vehicles section in Data Tools and spot-check a few vehicles to confirm everything came through as expected.
Ready to import your vehicles? Contact Fleetwatch Support to request the template.