For users seeking to this question with newer Excel versions like Excel 365…
As written at Professor Excel you could activate/restore “From Text (Legacy)” in the settings.
My prefered solution
File - Options - Data
Then you will be able to get the old import wizard… legacy but in my opinion more intuitiv.
Other possibilities
At that linked Professor Excel website there are also shown other possibilities. With Excels new import dialog, if you have several columns with numbers all in a different locale to your computers locale settings, then it will be much more effort to do the import.
With the old wizard you are set within a minute. With the new import dialog I haven’t found yet a method to be as fast as with the legacy import method.