What is a good light-weight CSV viewer? [closed]

Closed. This question is seeking recommendations for books, tools, software libraries, and more. It does not meet Stack Overflow guidelines guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 5 years ago.

Improve this开发者_运维百科 question

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.

---

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

---

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.

---

If your system has Cygwin, column -t in a terminal window is what I like to use.

$ cat file.csv
1,2,3,4
A,B,C,D
i,ii,iii,iv,v
foo,bar,foo foo,foobar
No commas

$ column -t -s"," file.csv
1          2    3        4
A          B    C        D
i          ii   iii      iv      v
foo        bar  foo foo  foobar
No commas

In order to update with changes to the original as you requested, you can combine it with the watch command:

watch column -t -s, file.csv

---

These threads both point to CSVed:

• Light text editor for CSV file?
• Looking for a very fast to load lightweight csv viewer

I tried it and had some issues with larger files (4000000 rows) with lots of columns (313), so YMMV.

I usually just use the BSD column utility. It's part of the util-linux package on windows:

---

You could try Ron's Editor - it will do what you want, is MUCH better than Excel for editing CSV files IMHO (that's why I wrote it), and I will let you decide if its light enough ;-)

---

Beacuse I was unhappy with how Excel displays CSV files, I produced a small executable designed to display CSV files. I recently made it available at http://csvquickviewer.com/ It’s only available for Windows because its writing in .NET

It does not need configuration but allows filtering, searching etc.

---

Finally find one can instantly open large files, and automatically detect the delimiter: The V File Viewer from http://www.fileviewer.com/ 20 days free trial. $20 to buy.

Another one, which is extremely fast and also automatically detect the delimiter is Delimit from http://delimitware.com 15 days free trail. $49 / year. Kind of expensive.

---

I believe there are Free excel viewers out there on Microsoft's site. And I think the native wordpad/write can also open up CSV files.

---

If you just want to look at the file, why not use a text editor? The better ones will notice a refresh and prompt you if you want to reload the file. However, they won't separate the values out into different columns for you; they will only display the contents. Both UltraEdit and TextPad have been reliable for me in the past.

---

OKFN's DataPipes SaaS Tool is an option for using in-browser.
GitHub automagically renders CSV into tables, providing another in-browser option, along with more functionality.