Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to bypass the Text Import Wizard when you import files in Excel
Article ID: 214295 - View products that this article applies to.
This article was previously published under Q214295
This step-by-step article describes how to bypass the Text Import Wizard when you import files in Microsoft Excel 2000.
When you import text files into Excel 2000, the Text Import Wizard may automatically appear and display the first line as shown when using the default parse line. You can bypass the Text Import Wizard and accept the defaults by holding down the SHIFT key when you open the file.
Note The Text Import Wizard is not displayed when you open an ANSI text file with a .csv extension (comma-separated value files). Instead, the ANSI text file is parsed into separate columns, using commas as delimiters. If you want the Text Import Wizard to be displayed for files with a .csv extension, rename the text file so that its file name extension is .txt.