I put all articles in a csv file with swedish characters åäö and thai characters กขค and some other characters like é.

Saved it in excel Apple OSX csv. Opened Textwrangler and replaced all ; with ,
Sets character encoding to Unicode (UTF-8) and Windows CRLF.

Magento displays wildcard character for the swedish characters.
Not sure what character encoding or how I should save it so that magento will be able to display properly.


Try opening the file in open office. Excel sucks when it comes to character encoding and even cvs format in general. Mac edition is even worse.

It's also free: https://www.openoffice.org

|improve this answer|||||
  • I don't believe in downloading other software to resolve an issue. But thanks for advice. – JustinBieber Jun 28 '14 at 18:46
  • So the software tools you use are not working, but you don't want to download other software tools? Okay man, good luck. – espradley Jun 28 '14 at 19:00

There are a few ways to add encoding to a web page. Since it seems you have tried a few, i think you can try AddCharset UTF-8 in your .htaccess. Also, if the problem persist you might want to try this

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.