stephenmcd/django-forms-builder — Issue #35: CSV in Excel unicode problem
Author: sindresorhus
Created: 2011-10-20 10:33:42+00:00
State: open

There is still and issue with opening the csv file in Excel gives gibberish for norwegian chars. Same with both Excel 2003 win and 2011 mac.

This `æøå` becomes `Ã¦Ã¸Ã¥`

This seems to be a common problem, and a [solution seems to be to encode the chars as utf-16](http://djangosnippets.org/snippets/993/).

I've also managed to get it to work by opening the CSV file in Notepad++ and converting it to "utf-8 with BOM". So it might be that it's missing the BOM.