I've had problems with Excel's 'new fangled import wizard, fortunately you can still access the the legacy wizard but it is hidden in the options, you need to enable it. (Show legacy data import wizards)
https://support.microsoft.com/en-us/...9-bc4a11bcc2a2