topic Re: Data Display in Splunk Search

Data Display

Aedah — Wed, 29 Jan 2025 23:25:17 GMT

I dont get why the uploaded data is displayed like this. I am unable to create dashboards as it is not identifying all the data available in the file.

Re: Data Display

MuS — Thu, 30 Jan 2025 00:00:49 GMT

Hi Aedah,

you are trying to upload an xlsx file which is not text. Export the file in excel as csv and upload the csv instead.

cheers, MuS

Re: Data Display

gcusello — Thu, 30 Jan 2025 07:56:25 GMT

Hi @Aedah ,

as @MuS said, xlsx isn't a format usable for uploading or reading a file, you must convert it in csv or txt.

There isn't still a direct converter from Excel to Splunk, even if there's an app to export results in Excel, but not to import.

Ciao.

Giuseppe

Re: Data Display

inventsekar — Thu, 30 Jan 2025 16:02:49 GMT

Maybe one idea to Splunk Dev team...

if a user uploading an excel file, the Splunk can create a warning msg saying that,... "the excel file is a proprietary filetype used on Windows OS, pls consider converting the file to a csv file and then upload it to the Splunk, thanks".

Re: Data Display

gcusello — Fri, 31 Jan 2025 07:40:42 GMT

Hi @Aedah ,

you could add this to splunk ideas (ideas.splunk.com) surely many people will be interesd on it.

Ciao.

Giuseppe