Hi buttonc. I've been through some of those and solved my particular error. First, on your Excel Template, the files they have are set up like a German file or some such . You need to do the following to solve that:
1. Open the template file you downloaded.
2. Insert a line at the type.
3. In the cell A1 (top left) enter the following text: sep=;
This is the best way. You may also be able to save the file, change the extension to .txt (instead of .csv). When you open the saved file, it then automatically starts the Excel parse wizard and you can delimit the file that way.
Other issues: Should be no on the ISO questions.
My issue was that I had a value in the ID field, even though I told the importer to override it still hosed up the import. When I reviewed the columns I just told the system to ignore the id field and it imported fine.
Finally, I recommend you download Notepad++. It is a great text editor, you can set encoding, etc., and best of all, it is FREE!