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.
Best Answer
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