Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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 38 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
1  
Nice but "Out of memory" for 15k rows. – watbywbarif Feb 9 '15 at 15:38
1  
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
3  
-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
2  
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
1  
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .