Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

3 Answers 3

up vote 22 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

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

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 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 at 18:55
    
OK, in Notepad++, selecting the option "Extended (\n, \r, \t, \0, \x)" makes it work. –  Peter Mortensen Feb 15 at 19:09

Your Answer

 
discard

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.