...
The file must be saved in a CSV format. By default, Excel creates the template in a TXT format and users must manually change the file format. This is very important, because the import fails if the file type is not correct. When Save is clicked, Excel might prompt a message “Some feature in your workbook might be lost if you save it as CSV To do this click ‘Save As’ in Excel and select 'CVS UTF-8 (Comma delimited). Do you want to keep using that format?”. Select Yes. If you use Save As to save the file, verify that the format is CSV UTF-8 (Comma delimited)(*.csv).cvs)' as the file type before clicking Save.
Step 4. Import the Template
...