Light text editor for CSV file?

Question

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.

CSVed is really good choice. I recommend it to anybody ... just enjoy. — Radek, Mar 16 '10 at 04:31
if somebody is looking ***only for a csv viewer***, [TadViewer](https://www.tadviewer.com/) 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 '19 at 09:46

score 15 · Accepted Answer · edited Dec 30 '11 at 18:04

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

edited Dec 30 '11 at 18:04

Community

1

answered Mar 14 '10 at 01:58

Rook

23,617
32
128
213

exactly what I wanted :-) Thank you for that. – Radek Mar 14 '10 at 02: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](http://tools.ietf.org/html/rfc4180#section-2) (_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 08 '15 at 12:40
Cannot escape double quotes, e.g. `"` -> `""` or `\"` – oseiskar Oct 08 '15 at 11:40
appreciate, but it seems it has problem with opening UTF-8 file – user1022209 May 12 '17 at 04:36
version 2.5 opens 300MB files with utmost ease! – Jishan Jun 07 '18 at 09:34

score 6 · Answer 2 · edited Oct 28 '16 at 05:54

6

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.

edited Oct 28 '16 at 05:54

Gaff

18,569
15
57
68

answered Jun 12 '12 at 07:22

Aaron Stewart

69
1
1

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 08 '15 at 12:44
1

@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 08 '18 at 16:54

score 4 · Answer 3 · answered Mar 14 '10 at 01:57

4

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

answered Mar 14 '10 at 01:57

Ian C.

6,073
3
29
29

score 0 · Answer 4 · edited Nov 01 '12 at 15:00

0

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

edited Nov 01 '12 at 15:00

slhck

223,558
70
607
592

answered Mar 14 '10 at 01:59

spowers

1,065
6
6

Light text editor for CSV file?

4 Answers4

Linked

Related