[Header] PHMSA - U.S. Department of Transportation - Pipeline and Hazardous materials Safety Adminis
spacer
For the Public
 
Hazmat Safety Community Pipeline Safety Community Media | Congress
 
Doing Business with PHMSA
 
PHMSA Home
Distribution, Transmission, and Liquid Accident and Incident Data

The ZIP files at the right each contain various files, a copy of detailed instructions, files containing descriptions of the fields/columns, and files containing the data.

Download, extract, and save the files from the needed ZIP file from the list on the right.

To load the data file into MS Excel (or MS Access):

  1. Open Excel and click "File" then "Open". This will start the "Open" dialog box.
  2. Select the data TXT file and click "Open".
  3. Excel will start the Text Import Wizard and display the first dialog.  Excel is smart enough to figure out that the file is a delimited file, so not adjustments are necessary on the first dialog.
  4. In the second dialog:
    1. Specify the delimiter as "Tab".
    2. Set the "Text Qualifier" to "{none}".
    3. Make sure "Treat consecutive delimiters as one" is turned off.
  5. In the third dialog set "Column data format" to "General".
  6. Click "Finish" to import the data.
Careers  |  Contact Us  |  No Fear  |  Privacy Policy  |  FOIA  |  Accessibility  |  FAQs  |  Web Policies  |  Site Map  |  Download Acrobat