Please note that PHMSA's Office of Pipeline Safety is still checking the data quality of the reports received this year, therefore the current year data is not presented as it may change as we receive supplementary information from the operators.

The ZIP files at the right each contain three files, a copy of these instructions, a file containing a description of the fields/columns, and a file appended with the year 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.