If you’re like most people, you probably use a spreadsheet to keep track of your finances, expenses, and other important data. But what if you want to import text into your spreadsheet? Excel 2007 has a built-in text import feature that can help you do just that. To import text into Excel 2007, follow these steps:

  1. Open the spreadsheet in which you want to import the text.
  2. Click the cell in which you want to start importing the text.
  3. Type some of the text that you want to include in your spreadsheet, and then press Enter or click the cell’s hyperlink button (if it’s available).
  4. Click the Import button on the Home tab (or press Ctrl+I). Excel will start importing all of the text in the selected cell into your spreadsheet as a new column of data. ..

Open a blank or existing Excel 2007 spreadsheet.  Click the Data tab on the Ribbon and choose “From Text”.

Choose the text file you want to import and double click. This will open the Text Import Wizard.  Choose your data type and which row you want to start the data at and click next.

 

Step 2 of the Wizard allows you to manage the break lines between your data. 

Step 3 of the Wizard allows you to choose column formats, provides data preview, and other advanced settings.  When everything is organized click on Finish.

A final window will be displayed asking where you wish to put the data into the sheet.  Here you can see I chose A6.  Click OK…

Your Text Data will now be input into the Excel sheet!