Early Warning Reporting - Microsoft® Excel Templates

Excel Templates

Notice to Light Vehicles and Buses, Medium & Heavy Vehicles Submitters - Updated 12/19/2014

Beginning with submissions of 2015 Quarter 1 (January 1, 2015 - March 31, 2015) data, new Excel templates will be required for your data submittals. The Version 2.0 files can be downloaded from the second table below to allow for setting up your processing to accommodate the new requirements.

Submissions using the new templates will NOT be accepted prior to April 1, 2015. After April 1, 2015 only revisions to submissions prior to that date 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 BMHVehicles.xls BMHVehicles.xlsx 1.2 8/16/06
Buses, Medium & Heavy Vehicles Death and Injury BMHVehiclesDi.xls BMHVehiclesDi.xlsx 1.2 8/16/06
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 LightVehicles.xls LightVehicles.xlsx 1.2 8/16/06
Light Vehicles Death and Injury LightVehiclesDi.xls LightVehiclesDi.xlsx 1.2 8/16/06
Low Volume Vehicles Death and Injury LowVolumeVehiclesDi.xls LowVolumeVehiclesDi.xlsx 1.2 8/16/06
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

Preview of Version 2.0 Excel templates - Using these templates will be required as of April 1, 2015. Submittals using them will NOT be accepted before that date.
Report Type Excel File NHTSA
Effective Date
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
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

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.