Korean character is broken when I export the query results in .csv file

[yschoi]

When I export the query results in .csv file using export function, the Korean character is broken.

I found out the Excel Export app in the splunk website.
When I use the Excel Export app, there is no problem.

But the Excel Export app saves query results as .xls file not .csv file.

Please help me to solve this problem.

Thanks in advance!

[ruman]

How are you viewing the CSV file? Assuming the output is UTF-8 (which should be the case unless you've instructed Splunk to use a different character set for this source), you might need to tell Excel to use UTF-8 when you open the CSV. http://stackoverflow.com/a/6488070 has some instructions for this.

If you are opening it with another application, make sure that it supports and recognizes the character set that the data is in.

[yschoi]

Is there any other way without Excel Export app?