How to make excel interpret Chinese characters in CSV file

I am sending a report from a unix shell script that contains chinese characters. When I open the CSV report in plaintext editor like textmate I can see the chinese characters but when I open CSV report file in Excel I don't see the chinese characters, but some gibberish. How do I "tell" excel that the file contains Chinese charset ? Here is the code that sends mail and attaches the CSV file. send_mail() { v_mailpart="ZZ_/afg6432dfgkl.94531q" echo "Mail to be sent to $RPT_SEND_TO" echo "To: $RPT_SEND_TO Subject: Blah Report as of $report_date_format; Content-Type: multipart/mixed; boundary=\"$v_mailpart\" MIME-Version: 1.0 This is a multi-part message in MIME format. --$v_mailpart Content-Type: text/html Content-Disposition: inline

Hi All,

Please find attached, the daily report

Thanks,
Blah Team

NOTE: This is an auto-generated email. Do not reply to it. Please send an email to blah-group@mycompany.com in case of any issues.

--$v_mailpart Content-Transfer-Encoding:UTF-8; Content-Type: text/plain;charset=\"UTF-8\"; Content-Disposition: attachment; filename=blah-report.csv cat $spool_file5" | /usr/sbin/sendmail -t }