...
Panel |
---|
|
Click on the "File Menu" and on the bottom left corner you should see the "Options" selection - click this: ![](https://avantalytics.atlassian.net/wiki/download/thumbnails/2524416/Excel%20Options.PNG?version=1&modificationDate=1546892876000&cacheVersion=1&api=v2&height=400)
- You should now be viewing all the options for Microsoft Excel - in particular we want to select "Data" - the third option from the top on the left shown below:
![](https://avantalytics.atlassian.net/wiki/download/thumbnails/2524416/Legacy%20Import%20Option.PNG?version=1&modificationDate=1546892876000&cacheVersion=1&api=v2&height=400) - Once you click "Data" - not on the right on the bottom is a list of checkboxes under "Show legacy data import wizards"
- Check (at least) the "From Text" legacy import option.
- Press the "OK" button.
- Open a new workbook.
- Navigate to the "Data" menu to active the Data Ribbon options as per normal.
- Choose the "Get Data" - the first option on the left hand side.
- When the dropdown menu appears - notice there is a Legacy Wizards Option - select that and you should see the option for the old import which proceeds as you'd expect. (Shown below)
![](https://avantalytics.atlassian.net/wiki/download/thumbnails/2524416/Annotation%202019-01-07%20152523.png?version=1&modificationDate=1546892876000&cacheVersion=1&api=v2&height=400)
|
Update 2021 – If after enabling this or when opening another file in Excel you do not have the option to choose "Legacy Wizards" (its greyed out) please follow the instructions from Microsoft below:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_windows8-mso_o365b/i-am-not-able-to-enable-the-text-import-wizard-in/012ec2ad-6dfe-472c-b7e0-cd6a85cb8168
Related articles
https://officesmart.wordpress.com/2018/06/18/turn-on-the-legacy-wizards-in-microsoft-excel-365/
...