Menu
Are there any good lightweight CSV viewers out there? I would like something that easily refreshes a file after it has been modified. A quick google search didn't turn up any clear winners.
I'd prefer not to have to open Excel each time since it locks the file. This prevents any other programs from updating the file.
952
Opening a CSV file is simpler than you may think. In almost any text editor or spreadsheet program, just choose File > Open and select the CSV file. For most people, it is best to use a spreadsheet program. Spreadsheet programs display the data in a way that is easier to read and work with than a text editor.
A CSV file is a list of data separated by commas. For instance, it may look like the following: Name,email,phone number,address. Example,[email protected],555-555-5555,Example Address.
This is for viewing only, using Powershell...
GUI Display; supports sorting, filtering:
Import-Csv yourfile.csv |Out-GridView
Console Display:
Import-Csv yourfile.csv |Format-Table -AutoSize
or:
Import-Csv yourfile.csv |Format-List
For additional sorting and filtering options, pipe through where-object and sort-object cmdlets
82
I use Nirsoft's CSVFileView. It is a simple lightweight read-only csv viewer.
Note: due to password recovery tools on Nirsoft's site many virus checkers will block executables downloaded from there.
28
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
