View Light

Windows PowerShell Built-In CSV Viewer

One of those nice hidden things that makes life much easier. There is a nice GUI-based CSV viewer built into PowerShell!

From the PowerShell prompt, use the following line:

Import-Csv filename.csv | Out-GridView

Which will give you a view like this:

Also, if you have a file that uses something other than commas to specify the separate fields (Such as a pipe '|', or semicolon ';'), you can add the following extra parameter:

Import-Csv filename.csv -delimiter '|' | Out-GridView

or

Import-Csv filename.csv -delimiter ';' | Out-GridView

Tab-delimited requires a strange specification (backtick followed by t), but works just fine:

Import-Csv filename.csv -delimiter "`t" | Out-GridView

Enjoy!

Reply
This site contains copyrighted material the use of which has not always been specifically authorized by the copyright owner. We are making such material available in our efforts to advance understanding of environmental, political, human rights, economic, democracy, scientific, and social justice issues, etc. We believe this constitutes a 'fair use' of any such copyrighted material as provided for in section 107 of the US Copyright Law. In accordance with Title 17 U.S.C. Section 107, the material on this site is distributed without profit to those who have expressed a prior interest in receiving the included information for research and educational purposes. For more information go to: http://www.law.cornell.edu/uscode/17/107.shtml . If you wish to use copyrighted material from this site for purposes of your own that go beyond 'fair use', you must obtain permission from the copyright owner.