Industrial Production and Capacity Utilization - G.17
Historical Data: Steps to get the G.17 files into Excel
- Save the data file on your disk drive with a file name ending in ".txt".
- Start Excel and click on "Open" on the "File" menu.
Select text file as type of file. Select file, click "Open". - Text Import Wizard comes up.
- Step 1: Pick "Delimited" then "Next>".
- Step 2: Pick "Space" as delimiter and then "Next>"
- Step 3: Pick "Finish"
Notes:
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.
Last update: March 30, 2012