Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 37 down vote accepted

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!

share|improve this answer
Nice but "Out of memory" for 15k rows. – watbywbarif Feb 9 '15 at 15:38
also it adds spaces to the file :-( – Radek Jul 15 '15 at 0:23
Radek if you want to split line, there is a feature just above in the menu called "split lines at..." – Guillaume Combot Aug 10 '15 at 19:13

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.

share|improve this answer
nice tool, thanks for referring to – Amr Elgarhy May 4 at 12:08

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

share|improve this answer
-1. Converting it into a TAB separated format does not make it a fixed width column format. – Peter Mortensen Feb 15 '14 at 18:50
Literally using "\t" does not work, neither in Notepad or Notepad++. It is always a challenge to use a TAB character in a dialog. A common work-around is to enter a TAB character in a document, put it into the clipboard by a cut (Ctrl + X) and pasting it into the field in the replace dialog. – Peter Mortensen Feb 15 '14 at 18:55
OK, in Notepad++, selecting the option "Extended (\n, \r, \t, \0, \x)" makes it work. – Peter Mortensen Feb 15 '14 at 19:09
TextFX -> TextFX Edit -> "split lines at..." – Guillaume Combot Aug 10 '15 at 19:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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