Converting CSV to fixed-width in Notepad++?

Question

Is there a way in Notepad++ to convert a comma-separated file to fixed width columns?

This feature exists in UltraEdit and explained in Working with CSV files, but I am happy with my Notepad++, and I don't want to pay for a copy of UltraEdit.

score 50 · Accepted Answer · answered Apr 06 '11 at 17:39

50

Use the built in TextFX menu.

TextFX -> TextFX Edit -> Line up multiple lines by (,)

I didn't discover this on my own, I found it on sourceforge while trying to figure out this exact question!

answered Apr 06 '11 at 17:39

Chance

626

score 11 · Answer 2 · edited Mar 27 '25 at 19:48

11

In the meantime I have just found a very nice tool for that. It's called CSVed and available here, with many many nice features. If you hate Excel when viewing CSV files like I do, you should give it a try.

edited Mar 27 '25 at 19:48

MaxD

69

answered Mar 16 '10 at 10:09

ercan

853

score 2 · Answer 3 · answered Jul 25 '21 at 14:09

For TSV files (tab separated) and newer Notepad++ release (either x86 or x64) the plugin Elastic Tabs is very helpful for this. I have it configured for .tsv files and it works like a charm.

Another plugin that maybe helpful in conjunction is CSV Lint, but didn't had the need for it yet. It features conversion between CSV comma, CSV semicolon and TSV formats.

score 0 · Answer 4 · edited Feb 15 '14 at 18:47

0

Yes, it's possible in Notepad: menu Edit -> Replace... -> ReplaceAll ',' by '\t'.

edited Feb 15 '14 at 18:47

Peter Mortensen

12,326

answered Jul 09 '12 at 09:41

albs

25

Converting CSV to fixed-width in Notepad++?

4 Answers4