1. Save the data file on your disk drive with a file name ending in .txt.

2. Start Excel and click on open on the File menu.  
   Select text file as type of file.  Select file.

3.  Text import wizard comes up.  
	Step 1:  pick "Delimited" then "Next>".
	Step 2:  Pick "Space" as delimier and then "Next>"
	Step 3:  pick "Finish"

Each line in spreadsheet should have the code, the year, and the twelve months in separate cells.


Note:

If the text import wizard does not appear and all data is in the first cell of each row:

Click on the the first column heading where the data resides, this should
highlight the contents of the column in all rows throughout your spreadsheet.

Click on Text to Columns from the Data Menu.
You should then see the Text import wizard and can follow the directions in 
number three above.

    

Release dates | Historical data | Data Download | Documentation
Current Monthly Release   Other formats: ASCII | PDF (144 KB)
Supplemental Monthly Release   Other formats: ASCII | PDF (144 KB)
Annual Revision Release   Other formats: ASCII | PDF (150 KB)

Statistical releases