Viewing CSV Files Without Excel

Published on Monday, October 5, 2015

Photo by Jan Loyde Cabrera on Unsplash

An installation issue with Office 2010 on the computer I built last weekend (I've hit my activation limit for the product key) got me to evaluate whether an Office 365 purchase would be worthwhile. Thinking back, I realized that over the past 9 months the only time I'd opened up any Office program was to view CSV files in Excel. That's not enough to justify $99 a year right now, so I'm going to hold off on a new Office purchase for a bit (2010 is still on my laptop if I really, really need it).

That bit of backstory is just in the service of pointing out that if all you need is a nice grid for viewing, sorting, and filtering CSV files, you can use Out-GridView in PowerShell. Just use Import-Csv to read the CSV file and pipe it into Out-GridView:

Import-Csv .\Batting.csv | Out-GridView

Example Out-GridView Output