Getting Data In

csv couldn't be opened for reading

zacksoft
Contributor

My csv is placed on desktop
So I am using | inputcsv "C:/Users/JM/Desktop/rap.csv"
Splunk is not able to read. It says the csv couldn't be opened for reading.
I tried this before couple of months back with a similar .csv and it had worked. not sure why is it not working this time...unable to figure out why it is unable to read.

Tags (1)
0 Karma
1 Solution

koshyk
Super Champion

You need to upload the CSV into Splunk
1. Via GUI => Just navigate to splunkURL/manager/search/lookups and upload the CSV. Put a name to it (like rap.csv)
Give permissions accordingly if you want to share to other users.

Then in the GUI, just do a

|inputlookup rap.csv

2.If you want to do it via backend, ensure that you upload the CSV via GUI. It normally comes to an app (like search app) or your own app. Just update the CSV in $SPLUNK_HOME/etc/apps/<your_app>/lookups/rap.csv

View solution in original post

0 Karma

koshyk
Super Champion

You need to upload the CSV into Splunk
1. Via GUI => Just navigate to splunkURL/manager/search/lookups and upload the CSV. Put a name to it (like rap.csv)
Give permissions accordingly if you want to share to other users.

Then in the GUI, just do a

|inputlookup rap.csv

2.If you want to do it via backend, ensure that you upload the CSV via GUI. It normally comes to an app (like search app) or your own app. Just update the CSV in $SPLUNK_HOME/etc/apps/<your_app>/lookups/rap.csv

0 Karma

zacksoft
Contributor

Thank you very much.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...