Text import wizard gone? How to import CSV and text files in Excel

Microsoft quietly replaced the comfortable Text Import Wizard from Excel and replaced it with the "Get & Transform" tools.

The "Get & Transform" tools offer a lot of options and are very powerful. Unfortunately, they are quite complicated to use. Here is what you should now.

Topics in this article include:

• Restore the "Text Import Wizard".
• How to use the "Text Import Wizard".
• Import text and csv files with the "Get & Transform" tools.