Excel User Tips

Excel page

User tips

 - Charts

 - Formula

 - Formatting

 - Printing

 - Miscellaneous

Help resources

Override Excel's Text Import Wizard

If you import text files into Excel, you've undoubtedly encountered the Text Import Wizard, which guides you through parsing the text.

If the files you import are always parsed correctly, you may prefer to bypass this wizard and accept the defaults. To do so:

1. Select File, Open

2. Locate the file to be imported

3. Hold down Shift while you click Open

Note: When you import a file with a .csv extension, the Text Import Wizard won't kick in. To override this default, you need to change the file's extension from .csv to .txt.