Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Open MS Excel
  2. Click on the Office button and choose Open.  The Open File dialog box will appear. Find the file you want to open.  You may need to navigate to the place where the file you want to open is stored.
  3. Highlight the file you want to open by clicking on it once. 
  4. Click the Open button in the bottom, right hand corner of the screen.
  5. The Text Import Wizard dialog box will appear.

Step 1

Use the following settings

  • Original data type: Delimited
  • Start Import at row: 1
  • File origin: 20127: US-ASCII

...

  1. In the Data Preview, click on the heading of the first column - it should say "General."
    (click image to enlarge)

    Image Added

  2. Scroll the bar over to the far, right side so that the last column in your data set displays.
  3. Hold down the Shift key on your keyboard and click the header of the last column.  Release the Shift key.  This should highlight all the columns. 
    (click image to enlarge)

    Image Added

  4. In Column data format, click the radio button next to Text.  This will import all of the columns in text format.
  5. Click Finish