Getting Data In

excel workbook as lookup or input data type in splunk

surekhasplunk
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

javiergn
SplunkTrust
SplunkTrust
0 Karma

inventsekar
Ultra 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
Get Updates on the Splunk Community!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Splunk is officially part of Cisco

Revolutionizing how our customers build resilience across their entire digital footprint.   Splunk ...

Splunk APM & RUM | Planned Maintenance March 26 - March 28, 2024

There will be planned maintenance for Splunk APM and RUM between March 26, 2024 and March 28, 2024 as ...