If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.

Microsoft Excel has an import wizard, but if you structure the text correctly, you can bypass the wizard altogether.