Activating Excel Legacy Wizard

If your version of Excel is not showing the Import Wizard, it may be necessary to activate the Legacy Text Import Wizard.

Go to Excel Options select Data and tick from Text (Legacy)

In Excel select Data and under Get Data it will now show Legacy Wizards From Text