Excel Template for Advanced Geotab Reporting

Our latest video shows how you can use an Excel file to query APIs in Geotab. This has the potential to allow for highly customized reporting. While Geotab has extensive customized reporting, in some cases you need additional data elements the report format does not include, such as odometer, current driver for a vehicle, current vehicle for a driver, and so on.

These two posts on the Geotab Community expand on the technical details of the template, and specific uses:
Demonstration of base Vehicle Lookups for Properties
Demonstration of actual Report with Odometer Lookup

While the VBA can be expanded for more API coverage and additional error handling, there is unique potential to create simple lookups for customers or mini-dashboards, that pull data from several sources easily taking the already advanced Geotab reporting to a whole new level.