1. Can Saved Searches Update an Excel File with Predefined Columns?
Not directly. Splunk saved searches export results in formats like:
CSV
JSON
XML
But you can:
Schedule a saved search to export as a CSV.
Use a script (Python, PowerShell, etc.) outside of Splunk to:
Watch the exported file.
Insert data into a predefined Excel template.
Save it as .xlsx.
Example:
Use the outputcsv command in your saved search:
your search query
| outputcsv my_output.csv
Then use Python (with pandas and openpyxl) to map this CSV into a predefined Excel template.
---
2. Can You Use Excel Files to Create Splunk Dashboards?
No, not directly. Splunk dashboards rely on:
Indexed data in Splunk
Real-time or scheduled searches
Lookups (CSV-based), not .xlsx
But you can:
Convert your Excel file to CSV
Upload it as a lookup table in Splunk
Use it in searches like:
| inputlookup my_excel_data.csv
From there, you can create dashboards.