21

Could anybody suggest a light (small, fast) text editor that can

  • handle columnar view of csv files?
  • save quote character to all fields, even if not 'necessary'

OpenOffice Calc is bit big for my old laptop. My favourite Notepad++ cannot present a columnar view. And it seems to me that Sharp Tools Spreadsheet cannot import CSV files. Google Docs converts some date fields by default, which I do not want and it is really slow.

closed as not constructive by slhck Nov 1 '12 at 14:59

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance. If this question can be reworded to fit the rules in the help center, please edit the question.

  • CSVed is really good choice. I recommend it to anybody ... just enjoy. – Radek Mar 16 '10 at 4:31
  • if somebody is looking only for a csv viewer, TadViewer is a fairly new one: quite light to open (much lighter than LibreOffice for sure), and with a modern interface, though not exactly small at ~48MB – toto_tico Mar 26 at 9:46
15

CSVed - at 1MB it seems pretty light.

alt text

Note that as of version 2.2.1 it has trouble opening large CSV files.

  • a 4,000,000 row, 313 column, LF terminated CSV simply gives a "File is empty" warning
    • reduced to ~1000 rows it opens, but drops columns 227 - 313
    • reduced to 1 row, it still drops columns 227 - 313
  • exactly what I wanted :-) Thank you for that. – Radek Mar 14 '10 at 2:03
  • I'm trying CSVed 2.3.0 (and its little brother uniCSVed 1.1) and unfortunately they don't support line breaks into text wrapped by double-quotes, wich is a kind of CSV standard (6. Fields containing line breaks...) – Salvador Mar 13 '14 at 14:58
  • Super prog. The only thing I cannot find, how to force it to see the first line as column names? – ikashnitsky Sep 8 '15 at 12:40
  • Cannot escape double quotes, e.g. " -> "" or \" – oseiskar Oct 8 '15 at 11:40
  • appreciate, but it seems it has problem with opening UTF-8 file – user1022209 May 12 '17 at 4:36
5

I have written a product called Ron's Editor which you might want to look at. I am always interested in making it more useful/powerful so I would be interested in your feedback.

Ron's Editor is a powerful CSV file editor. It can open any format of separated text, including the standard comma and tab separated files (CSV and TSV), and allows total control over their content and structure.

With a clean and neat interface Ron's Editor is also ideal to simply view and read CSV, or any text delimited, files.

Ron's Editor is the ultimate CSV editor, whether you need to edit a CSV file, clean some data, or merge and convert to another format, this is the ideal solution for anyone who regularly works with CSV files.

Ron's Editor

  • As long as your prog does not offer any unique functionality compared with the free alternatives (like CSVed), you might consider making it more affordable or even free for personal use. Now it looks like you are trying to "sell air". – ikashnitsky Sep 8 '15 at 12:44
  • @Ilya , maybe I don't know how to use CSVed, but I actually found this Ron's Editor much better than CSVed. CSVed doesn't seem to display column names correctly and you can't edit the cells in place but instead it opens a popup window. In Ron's Editor both of those things work. – kynnysmatto Nov 14 '16 at 15:26
  • Can confirm, anyone who has used both programs extensively will easily undertand the superiority of Ron's Editor. – chili Nov 8 '18 at 16:54
3

CSVed is a light weight editor specifically designed for editing CSV files on Windows. It's free.

0

You could use the Windows port of emacs and then use the CSV mode.

Not the answer you're looking for? Browse other questions tagged or ask your own question.