In my experience searching through “.csv” files
- Open the command prompt.
- Start PowerShell and navigate to the directory where the file is located.
- Once in the directory use the command:
cat ‘.\excelfilename.csv’ | select-string info
After you have done this the information you enter after select-string will be search for.