You'll need to have it in csv format first.
http://splunk-base.splunk.com/answers/48887/excel-spreadsheet-as-input-to-splunk-not-csv-file
My input contains some garbled data if it is imported in CSV, but if the same data is getting opened in EXCEL it is coming fine ( some korean data is there which is not recognized by .txt ), Help me to get rid of this problem please