Searching/Monitoring 100s of Excel files...

[Moogz]

Hey all, I understand splunk doesn't read in an excel file unless its converted to csv or plain text but wanted to see if anyone had some ideas about something I'd like to do..

I would LOVE to be able to point splunk to a master directory that has anywhere from 20-50 subdirectories and over 100-200 excel files in them. It would be great to be able to search through the data in every single spreadsheet.

Any ideas?

[alvaromoraes]

Hello,

My suggestion is to create some Java or VBA script to do it.

Some links:
http://stackoverflow.com/questions/12605920/convert-multiple-xls-files-to-csv-files-separated-by-sem...

http://stackoverflow.com/questions/10803395/is-it-possible-to-batch-convert-csv-to-xls-using-a-macro