If you ever wanted to save a google search to a CSV file, you should check out SEOquake.
Recently I used SEOquake to generate 50 CSV files. The end goal was to work with these CSV files in Powershell. Unfortunately, each of the original files had a header that I wanted to remove.
I used the following powershell code to strip out the first 6 lines of each of these files:
After running that powershell code, I can now work with SEOquake output more easily inside of other powershell scripts.