Importing Text Files


In this topic, you will import a text file using the Text Import Wizard.


Steps:

  1. Click the Data tab.

    Step 1
  2. Click the From Text button.

    Step 2
  3. Locate the File.

    Step 3
  4. Click the Import button.

    Step 4
  5. Choose the file type that describes your data.   If you are unsure of the type, leave the default settings.

     

    Delimited:  information separated by characters such as commas or tabs.

     

    Fixed width:  information separated by spaces between each file.

    Step 5
  6. In this example, click the Delimited option.

    Step 6
  7. Click the Next button.

    Step 7
  8. Select the delimiter(s) your data contains.  If you are unsure, leave the default.

     

    Click the Next button.

    Step 8
  9. Select a format for each column.  

     

    To select a column, click in the column header.

    Step 9
  10. Click the Finish button.

    Step 10
  11. Select where you want to place your data.

     

    Click the OK button.

    Step 11
  12. Your results:

    Step 12

After completing this topic, you are able to import text files.