Importing Text Files

Question:     Can I bypass the Text Import wizard when importing text files into Excel?

Answer:        Yes

 Why:            To quickly import a correctly parsed text file into excel and bypass the text import wizard

Applies To: Excel 2003, 2007, 2010

  1. The following text file will be used for this example. Assuming the name of the text file is List of Products.txt.

2.  Open a new blank excel workbook

3.  Select the Open option in excel

4.  Hold down the shift key while you open the List of Products text file

The text file will be imported without going through the text import wizard. Thus time will be saved.

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.