Early Warning Reporting - Microsoft® Excel Templates

Excel Templates

Notice to Light Vehicles and Buses, Medium & Heavy Vehicles Submitters - Updated 6/19/2015

Beginning with submissions of 2015 Quarter 1 (January 1, 2015 - March 31, 2015) data, the NHTSA Revision Number 2.0 Excel templates must be used for your data submittals.

Only revisions to data submitted prior to April 1, 2015 will be accepted using the old templates.

The following table lists the Excel templates that are available for use in recording Early Warning Reporting (EWR) aggregate and death and injury data.

    The Microsoft® Excel templates with the .xls extensions can be used with Microsoft® Excel 2000 and 2003.
    The Microsoft® Excel templates with the .xlsx extensions can be used with the latest versions of Microsoft® Excel (2007 and 2010).

NOTE: Please read the Download Instructions before trying to download the templates.
Report Type Excel File NHTSA
Last Updated
Buses, Medium & Heavy Vehicles Aggregate BMHVehicles2.xls BMHVehicles2.xlsx 2.0 1/1/15
Buses, Medium & Heavy Vehicles Death and Injury BMHVehiclesDi2.xls BMHVehiclesDi2.xlsx 2.0 1/1/15
Child Restraint Aggregate ChildRestraints.xls ChildRestraints.xlsx 1.2 8/16/06
Child Restraint Death and Injury ChildRestraintsDi.xls ChildRestraintsDi.xlsx 1.2 8/16/06
Equipment Death and Injury EquipmentDi.xls EquipmentDi.xlsx 1.2 8/16/06
Light Vehicles Aggregate LightVehicles2.xls LightVehicles2.xlsx 2.0 1/1/15
Light Vehicles Death and Injury LightVehiclesDi2.xls LightVehiclesDi2.xlsx 2.0 1/1/15
Low Volume Vehicles Death and Injury LowVolumeVehiclesDi2.xls LowVolumeVehiclesDi2.xlsx 2.0 1/1/15
Motorcycles Aggregate MotorCycles.xls MotorCycles.xlsx 1.2 8/16/06
Motorcycles Death and Injury MotorCyclesDi.xls MotorCyclesDi.xlsx 1.2 8/16/06
Substantially Similar Vehicles SubstantiallySimilar.xls SubstantiallySimilar.xlsx 1.2 8/16/06
Tires Aggregate Tires.xls Tires.xlsx 1.4 8/16/06
Tires Death and Injury TiresDi.xls TiresDi.xlsx 1.2 8/16/06
Trailers Aggregate Trailers.xls Trailers.xlsx 1.2 8/16/06
Trailers Death and Injury TrailersDi.xls TrailersDi.xlsx 1.2 8/16/06

Download Instructions

Use the following procedure to download an EWR Excel template:

  1. Right-click on the desired template above to start the download. A pop-up menu appears.
  2. Click "Save Target As..." to save the file to your desktop.

    If the Download Fails

    If the download process is interrupted for any reason, click on the template link to re-start the process. You can return to a particular link as many times as necessary to get a complete download.