Importing Delimited Text to MS Excel: Step 3
After you have selected the file the window below will appear. This step will tell Excel how the file is formatted, so the import can be completed successfully. Since this is a delimited file make sure that Delimited - Characters such as commas or tabs separate each field is selected at the top. Keep everything else the same. Click Next to continue.