Skip to main content

Export-CSV Powershell, don't include pesky first line

You use Export-CSV to export a result to CSV in powershell, 

It's a great tool, but it also includes type information in the first line. 

For a GCI command, it typically creates something like; 

#TYPE System.IO.DirectoryInfo

This breaks a single click open when you want to view the file in something like Excel.

You can tell Export-CSV to stop creating the Type Info by using the switch;

    -NoTypeInformation


So, your command ends up something like 

    gci -recurse | export-csv "20221124.csv" -NoTypeInformation


Comments

Post a Comment

Popular posts from this blog

NMAP

It's been about 15 years since I used NMAP, I forgot how useful the tool is. To find out what services are running on an IP address simply use something like nmap -n -v -p1-10000 x.x.x.x -n tells nmap not to do name resolution (saves about 13 seconds if the IP you're scanning isn't in DNS_ -v verbose -p1-10000 says scan ports 1 to 10,000 (otherwise nmap will only scan the first 1000 ports)
Post a Comment
Read more