If you regularly import non-spreadsheet files into Excel, you may have noticed that the legacy tools have disappeared in newer versions of Excel. So, for example, where has the Text Import Wizard in Excel gone?
Switch Text Import Wizard back on
It may look like it is gone, but the legacy Text Import Wizard is still in the latest versions of Excel. MS are focussing on the new Get&Transform tool for all the ‘getting data’ but sometimes you just need to import some text files quickly.
To switch the Text Import Wizard back on:
- Click on FILE, then
- Click on the Options button
- As shown below, choose Data, and
- Choose which legacy import wizards you want to switch back on
Once you have switched them on, you can find them as shown below in the Data ribbon, under Get Data and the Legacy Wizard buttons.
Other Import Wizards that can be switched back on
As can be seen in the images above, the following import wizards can be switched back on. So you can import data from:
- SQL Server
- OData Data Feed
- XML Data Import
- Data Connection Wizard