Download open office
save the file editing the filter settings
Make sure to select UTF8
Next put in a BAR “|” as the separator in the attributes section.
Then when importing you need to change the separator to the BAR “|”
That should work! The next issues you will have is if there are attributes on the spread sheet that are not in admin it will error then look up those line numbers and add the missing attributes to admin.
I hope that helps someone!