How do I convert a text file to an Excel file?

How do I convert a text file to an Excel file?

Article: 000001995 Product: All

Convert a text file to an Excel file

Having a text file changed to an Excel file can allow for viewing the document in a clear manner: I.E., contacts and email address listed in separate columns instead of side by side. A text file can be converted into an Excel file through the following steps:

• 2003
• 2007
• 2010

---

Microsoft Excel 2003                

1. Open Microsoft Excel.
2. Click Data > Import External Data > Import Data.
3. Open the file you created in Notepad. A wizard will display.
4. Select Delimited and click Next.
5. Uncheck Tab and select Space.
6. Click Next.
7. Click Finish and OK.
8. On the Excel toolbar, select File > Save As. A dialog box pops up.
9. Type a new name for the file in the File Name text field.
10. Under Save As Type, choose Excel Workbook (*xlsx), Excel 97-2003 Workbook (*.xls), or CSV (Comma Delimited)(*.csv) and click Save.

If you saved as a CSV file:

• Click OK for the message "The selected file type does not support workbooks with multiple sheets".
• Click Yes for the message that the file "may contain features that are not compatible with CSV".

Note: After you save your file, import your email addresses.
Back to Top

Microsoft Excel 2007 

1. Open Microsoft Excel.
2. Select the Data tab.
3. Click From Text.
4. Browse to the text file and select it.  
5. Click Import. The Text Import Wizard will begin.
6. Select Delimited and click Next.
7. Uncheck Tab and select Comma.
8. Click Next.
9. Click Finish.
10. Select to save the information in either an existing worksheet or a new worksheet.
    Note: The contacts should now be in Excel, split into columns.
11. On the Excel toolbar, select File > Save As. A dialog box pops up.
12. Type a new name for the file in the File Name text field.
13. Under Save As Type, choose Excel Workbook (*xlsx), Excel 97-2003 Workbook (*.xls), or CSV (Comma Delimited)(*.csv) and click Save.

If you saved as a CSV file:

• Click OK for the message "The selected file type does not support workbooks with multiple sheets".
• Click Yes for the message that the file "may contain features that are not compatible with CSV".

Note: After you save your file, import your email addresses.
Back to Top

Microsoft Excel 2010

1. Open Microsoft Excel.
2. Click on the Data tab.
3. In the Get External Data group, click From Text.
4. Double-click the text file that you want to import in the Import Text File dialogue box.
5. Click Import. The Text Import Wizard will begin.
6. Select Delimited and click Next.
7. Uncheck Tab and select Comma.
8. Click Next.
9. Click Finish.
10. Select to save the information in either an existing worksheet or a new worksheet.
    Note: The contacts should now be in Excel, split into columns.
11. On the Excel toolbar, select File > Save As. A dialog box pops up.
12. Type a new name for the file in the File Name text field.
13. Under Save As Type, choose Excel Workbook (*xlsx), Excel 97-2003 Workbook (*.xls), or CSV (Comma Delimited)(*.csv) and click Save.

If you saved as a CSV file:

• Click OK for the message "The selected file type does not support workbooks with multiple sheets".
• Click Yes for the message that the file "may contain features that are not compatible with CSV".

Note: After you save your file, import your email addresses