windows 什么是好的轻量级 CSV 查看器？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6141848/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is a good light-weight CSV viewer?
提问by syvex
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.
有没有好的轻量级 CSV 查看器？我想要一些可以在修改后轻松刷新文件的东西。快速的谷歌搜索没有找到任何明显的赢家。
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.
我不想每次都打开 Excel，因为它会锁定文件。这可以防止任何其他程序更新文件。
回答by Kevin
This is for viewing only, using Powershell...
这仅供查看，使用 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
如需其他排序和过滤选项，请通过 where-object 和 sort-object cmdlet
回答by robochat
I use Nirsoft's CSVFileView. It is a simple lightweight read-only csv viewer.
我使用 Nirsoft 的CSVFileView。它是一个简单的轻量级只读 csv 查看器。
Note: due to password recovery tools on Nirsoft's site many virus checkers will block executablesdownloaded from there.
回答by Costa
If your system has Cygwin, column -tin a terminal window is what I like to use.
如果你的系统有 Cygwin，column -t我喜欢在终端窗口中使用。
$ 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 watchcommand:
为了根据您的要求更新对原始文件的更改，您可以将其与以下watch命令结合使用：
watch column -t -s, file.csv
回答by Chris Betti
These threads both point to CSVed:
这些线程都指向CSVed：
I tried it and had some issues with larger files (4000000 rows) with lots of columns (313), so YMMV.
我试过了，但在处理带有很多列（313）的较大文件（4000000 行）时遇到了一些问题，所以 YMMV。
I usually just use the BSD column utility. It's part of the util-linuxpackage on windows:
我通常只使用 BSD 列实用程序。它是windows 上util-linux包的一部分：
回答by Aaron Stewart
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 ;-)
你可以试试Ron 的编辑器——它会做你想做的事，比 Excel 更适合编辑 CSV 文件恕我直言（这就是我写它的原因），我会让你决定它是否足够轻;-)
回答by Raphael N?ldner
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
因为我对 Excel 显示 CSV 文件的方式不满意，所以我制作了一个旨在显示 CSV 文件的小型可执行文件。我最近在http://csvquickviewer.com/上提供了它仅适用于 Windows，因为它是用 .NET 编写的
It does not need configuration but allows filtering, searching etc.
它不需要配置，但允许过滤、搜索等。
回答by Jfly
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.
终于找到一个可以瞬间打开大文件，并自动检测分隔符的：来自http://www.fileviewer.com/的V File Viewer 20天免费试用。20美元购买。
Another one, which is extremely fast and also automatically detect the delimiter is Delimit from http://delimitware.com15 days free trail. $49 / year. Kind of expensive.
另一种速度非常快并且还能自动检测分隔符的是来自http://delimitware.com 的 Delimit15 天免费试用。49 美元/年。有点贵。
回答by Sivaram
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.
我相信微软网站上有免费的 excel 查看器。而且我认为本机写字板/写也可以打开 CSV 文件。
回答by Ryan
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.
如果您只想查看文件，为什么不使用文本编辑器？更好的会注意到刷新并提示您是否要重新加载文件。但是，它们不会为您将值分成不同的列；他们只会显示内容。过去，UltraEdit 和 TextPad 对我来说都是可靠的。
回答by albert
OKFN's DataPipes SaaS Toolis an option for using in-browser.
GitHub automagically renders CSV into tables, providing another in-browser option, along with more functionality.
OKFN 的DataPipes SaaS 工具是在浏览器中使用的一个选项。
GitHub 自动将 CSV 呈现到表格中，提供另一个浏览器内选项以及更多功能。
