Archive
Highlighted

excel workbook as lookup or input data type in splunk

Communicator

Hi,

I want to use an excel work book which has several tabs with data. How can i use different tabs of a single excel as input datatype in splunk.

Thanks

Tags (2)
0 Karma
Highlighted

Re: excel workbook as lookup or input data type in splunk

Champion

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
alt text

0 Karma
Highlighted

Re: excel workbook as lookup or input data type in splunk

SplunkTrust
SplunkTrust
0 Karma