in cmd,

findstr /N /I "something" *.csv > C:\output.csv

Find "something" from current directory of all csv files and output results to C:\output.csv