Splunk can import any text-based format. Excel file formats such as xls and xlsx is not text-based and as such cannot be read directly by Splunk.
as a workaround, you can convert the excel file to csv file and then upload to splunk.
to confirm this, i tried to upload a excel file, on the first step, it loads fine. 2nd step - data preview, shows