I have added a folder to read CSV files through data input >files and directory option.
It seems that when I add a new file it needs splunk instance to restart to take up that file.
Can we configure splunk to read the file automatically when new file is placed into folder.
In that case something else is going on in your setup. Splunk does not require a restart to pick up new files. One good start for your troubleshooting is using the script found here: http://blogs.splunk.com/2011/01/02/did-i-miss-christmas-2/
I did like that.Please see the values which i have taken from splunk web.
Full path to your data:D:\SplunkInput\Data
Set host :Constant Value
Source type :csv
Set the destination index :default
Number of files :6