Excel Instruction Guide - Detailed explanation of general file requirements for for submitting Excel files to the TLC.
Bases submitting Excel spreadsheets must use the TLC provided templates that can be found below.
As outlined in the Excel instruction guide, bases must identify the driver and the vehicle that serviced each trip by including the driver and vehicle TLC license numbers in the main trip record file.
Please note that bases are no longer allowed to include the base’s internal IDs for drivers and vehicles.
Excel Trip Record File
New Trip Record Excel Spreadsheet (Effective January 2019) – The Trip Record Template (Proposed) must be used to submit trip records if submitting Excel files.
Example: Trip Record Excel Example
Current Trip Record Excel Spreadsheet – The Trip Record Template must be used to submit trip records if submitting Excel files.
Example: Current Trip Record Excel Example