Importing Text Files - Exercise

Contact Us or call 1-877-932-8228
Importing Text Files - Exercise

Importing Text Files

Duration: 5 to 15 minutes.

In this exercise, you will practice importing text files into a Microsoft Excel workbook.

  1. Use Microsoft Excel to import Contact Information.txt from your Excel2013.3/Exercises folder.
  2. Use Microsoft Excel to import Capitals.txt from your Excel2013.3/Exercises folder.

Solution:

  1. To import Contact Information.txt from your Excel2013.3/Exercises folder:
    1. Open Microsoft Excel.
    2. From the FILE menu, select Open:Open Command
    3. In the Open dialog box, navigate to your Excel2013.3/Exercises folder and in the file type drop-down box, select Text Files:Navigate to File
    4. Select Contact Information.txt and click Open:Open Command
    5. In Step 1 of the Text Import Wizard, select Delimited and click Next:Wizard Step 1
    6. In Step 2 of the Text Import Wizard, select Tab and click Next:Wizard Step 2
    7. In Step 3 of the Text Import Wizard, click Finish:Wizard Step 3
  2. To import Capitals.txt from your Excel2013.3/Exercises folder:
    1. From the FILE menu, select Open:Open Command
    2. In the Open dialog box, navigate to your Excel2013.3/Exercises folder and in the file type drop-down box, select Text Files (if it isn't already selected):Text Files Command
    3. Select Capitals.txt and click Open:Select File
    4. In Step 1 of the Text Import Wizard, select Delimited and click Next:Wizard Step 1
    5. In Step 2 of the Text Import Wizard, select Comma and click Next:Wizard Step 2
    6. In Step 3 of the Text Import Wizard, click Finish:Wizard Step 3
Next