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 do the columnar view. And it seems to me that Sharp Tools Spreadsheet cannot import csv file. GoogleDoc convert some date fields by default which I do not want and it is really not fast and easy way how to edit csv.

link|improve this question

CSVed is really good choice. I recommend it to anybody ... just enjoy. – Radek Mar 16 '10 at 4:31
feedback

3 Answers

up vote 5 down vote accepted

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
link|improve this answer
exactly what I wanted :-) Thank you for that. – Radek Mar 14 '10 at 2:03
feedback

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

link|improve this answer
feedback

You could use the windows port of emacs and then a csv mode like http://www.emacswiki.org/emacs/CsvMode.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

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