什么是一个好的轻量级 CSV 查看器？

那里有没有很好的轻量级 CSV 观看器？我希望能够轻松刷新修改后的文件。在谷歌上快速搜索并没有找到任何明显的赢家。

我不希望每次都必须打开 Excel，因为它会锁定文件。这可以防止任何其他程序更新该文件。

77844 次浏览
小开

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.

小开

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:

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.

小开

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.

小开

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

小开

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.

小开

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.


提交答案