Other Usage

How to create a report in Excel format ( .xls)

abhayneilam
Contributor

Splunk generates five .csv files which I import to an excel sheet to make a complete workbook which contains five tabs, tab_one tab_two tab_three tab_four tab_five

I am importing each csv file to each tab:

file1.csv to tab_one
file2.csv to tab_two
file3.csv to tab_three
file4.csv to tab_four
file5.csv to tab_five

My requirement is to reduce this manual task, means, I want to directly generate an excel sheet from splunk which would contain all the five tabs along with the data corresponding to each tab..

please suggest !!

Thanks,
Abhay

Tags (2)
0 Karma

rafadvega
Path Finder

I think the only option is to use the api to get the results and create the .xls file. In python, it should be easy. If you have access to the api and want help to develop this, I can make an example.

0 Karma

mamta_sonilv
New Member

Kindly check the excel tutorial
I hope you can solve your problem
thanks a lot

0 Karma

Damien_Dallimor
Ultra Champion

I would check out OData for Splunk.

abhayneilam
Contributor

Hi,

I am not finding any way to do that...please help me with the correct procedure

Thanks
Abhay

0 Karma

bmacias84
Champion

Currently I don't believe this capacility currently exists in Splunk. If you have some programatic skills you could use the REST API then build your Xls workbook Or have Splunk build your csv then excel macro read the csv to the correct tab.

http://www.python-excel.org/

http://www.excel-vba-easy.com/

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...