How to get data from two sheets of a single excel file after converting to a CSV file?

[SanthoshSreshta]

Hi All.

I am a newbie to splunk. Till yesterday I was importing from only one sheet of excel (excel converted to csv and worked on it ).
I want now to get data from two excel sheets of single excel file and should be able to develop dashboards from two excel sheets of single excel file.
Is it possible doing so.? if yes Can anyone give me some ideas on doing this.?

Thanks,
Santhosh.

[acharlieh · Accepted solution]

You could export each sheet as a separate CSV, and then import those, but as has been answered on this site before (see below for some links), as a binary format you cannot import Excel directly into Splunk.

• http://answers.splunk.com/answers/100321/does-splunk-support-excel-imports.html
• http://answers.splunk.com/answers/67891/want-to-import-excel-data-in-splunk.html
• http://answers.splunk.com/answers/48887/excel-spreadsheet-as-input-to-splunk-not-csv-file.html

[SanthoshSreshta]

Is there no scope of exporting ( one excel file containing more than one excel sheets in it) converted that one excel file to csv file and getting the data through commands from each excel sheet (from csv file)..?
I have gone through them acharlieh.

[acharlieh]

How to manage data in Excel and convert that data to CSV is a bit outside the scope of this support site (This is a site for community Splunk support). Doing a Google search on how to convert multiple Excel sheets turns up a number of options ranging from programmatic to pre-built utilities for such a conversion. I have not done such, therefore cannot recommend any one particular way.

Once you have the data in CSVs there are a number of things you could then do with them and Splunk, indexing being the most straightforward, but you could also build lookups around each CSV and use various lookup commands with it. I suppose If you know enough python it may be theoretically possible to build an external lookup script to open your excel file and retrieve data that way. However I don't know of anyone who has built such for Splunk yet, while in theory it could be possible to build you may want to consider effort and risk vs reward.

[SanthoshSreshta]

its okay acharlieh , I just want to confirm, is it possible with splunk or not. Thanks for your suggestion. so i have posted such question here.