Making The Transfer

• 1). Open Excel to a new or existing spreadsheet and highlight the cell where you want the imported data to appear.
  
  
• 2). Click the "Data" tab. Click "Get External Data" in the drop-down menu, then select "Import Data."
  
  
• 3). Browse the computer, locate the file you wish to import and select it. Click the "Open" button to advance to the Text Import Wizard. Within the wizard, select "Fixed Width" or "Delimiter" and click "Next." Choosing "Delimiter" will instruct Excel to break the text into multiple cells and columns. Otherwise, your text import will be placed in one large cell.
  
  
• 4). If you choose to delimit the text, select the appropriate delimiter to break the text into cells. Make sure you carefully watch the delimiter's effect in the preview window to ensure you reach the desired format and click next. Finally, select the column data format for each column in the file. Exit the wizard by clicking the "Finish" button.
  
  
• 5). Either open a new worksheet or click "Existing Worksheet" to import and place the data. Click "OK" to complete the import process.
  
  
• 6). Go to the file menu and select "Save As" from the drop-down menu. Name the file and save the Excel worksheet to ensure your text import data is not lost.