>>Back to Support

Vehicle odometer and/or label information can now be uploaded via spreadsheet.

Go to Account – Admin – Vehicle Administration and click Open.


Select Update multiple vehicles from a spreadsheet in the Additional Vehicle Options box.


Select either Update Odometer Waypoints or Update Vehicle Labels. Click Browse, locate the spreadsheet file and click Upload Now. (For now, the spreadsheet should be saved in .csv format.)


The spreadsheet should contain the vehicle information to be updated, with one row per vehicle. If odometers are being updated, the Odometer readings and corresponding Timestamps should be in columns next to either the VIN, serial number, or vehicle label - as shown below. If vehicle labels are being updated, new values for Vehicle Label, Color, License, License Country, and License State can be in ordered columns next to either the VIN or serial number of the vehicle.


After you click Upload Now you can preview the import and match the correct column definitions to the spreadsheet’s columns. When complete, click on Preview the Import:


All rows of the spreadsheet and its data are then shown in the manner they will be imported. Green check marks indicate that the row will be imported. After verifying the information appears correctly, click on Proceed with Import:


Vehicle labels and odometer readings will then be instantly updated.

GPS Insight employs an automated “odometer factor” which makes odometer readings much more accurate, based on historical adjustments. For instance, a typical device odometer (with either an LD 3500 or GPSI-3900/4000) is off by 1-2% [typical, since GPS and light duty OBD-II odometer readings are not 100% accurate]. After 500 miles, the device may show 490 or 510. If this is adjusted, the 1% adjustment factor is used moving forward, so that after the next 500 miles, the device will most likely show 999 or 1001. This feature makes odometer adjustments far less necessary. Only one or two reasonably spaced odometer adjustments is necessary to “calibrate” the device to the vehicle. Exceptional situations, such as a running vehicle being towed or excessive backing up or start/stop, may cause odometer readings to differ, but GPS Insight makes it easy to adjust those odometer readings to reality, and “allocates” the error to the prior miles in a way which avoids “jumpy” odometer adjustments.

Note that most other GPS tracking companies do not even track odometer reading – they only track absolute miles driven, which does not help with preventative maintenance schedules such as GPS Insight’s or 3rd party FMS software, which GPS Insight supports via API.


>>Back to Support