Getting Data In

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

SanthoshSreshta
Contributor

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.

Tags (3)
0 Karma
1 Solution

acharlieh
Influencer

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.

View solution in original post

0 Karma

acharlieh
Influencer

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.

0 Karma

SanthoshSreshta
Contributor

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.

0 Karma

acharlieh
Influencer

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
Contributor

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.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...