I came across this thread when I was having similar issues displaying CSV files in Excel. After some trial-and-error with different encodings and BOM chars I found the best solution was to encode the CSV as tab-delimited UTF-16 LE.
I put together a blog post on the topic here in the hope it helps the next time someone has the same problem:
