U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590
202-366-4000


Skip to content U.S. Department of Transportation/Federal Highway AdministrationU.S. Department of Transportation/Federal Highway Administration

Bridges & Structures

NBI ASCII Files


Note on saving data files:

Some of the data files are large and can take some time to load. After you click on the link, please make sure the file is loaded before saving. Below are examples of a file loading and a file completely loaded.

Note on importing the data:

To import into Excel, choose the Data Tab, then From Text, choose your file from saved directory and import. Import wizard pops up. Choose Delimited File, Comma Separated and the Text Qualifier is a single quote (not double which is excel default), on the next screen which is the Column Data Format screen highlight the structure number column (column 2) and choose "TEXT" for the structure number column format rather than the default of "GENERAL" this will import the structure numbers correctly and keep the formatting.

Notes on using the data:

  1. After downloading the data you will need to distinguish the subset of "highway bridges". To obtain this set items 5a=1; 49>=6.1meters; 112=Y and 42a=1 or 4 or 5 or 6 or 7 or 8.
  2. To make data use easier starting in 2013 only highway bridges are written to the download file. An additional status field was also added (see record layout)
  3. All data in the inventory rating and operating rating fields is written in metric tons.
Word files can be viewed with the Word Viewer
PDF files can be viewed with the Acrobat® Reader®
Updated: 07/10/2014
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000