How to align columns in Notepad++

http://tomaslind.net/2016/02/18/how-to-align-columns-in-notepad/

How to align columns in Notepad++

Here’s a short tip on how to align columns (separated by comma or other character) for text files in Notepad++ for increased readability.

When a delimited text file is opened in Notepad++ (or any other text editor), the content may look something like this:

Non aligned columns in Notepad++

Since the columns aren’t aligned, it is quite hard to read the data.

To make the columns aligned (e.g. like in Excel), the plugin TextFX can be used. In Notepad++, select Plugins -> Plugin Manager and check the plugin to install:

TextFX plugin download

Restart Notepad++ when prompted.

Copy the character that is used as a column delimiter (in the example above it is “;”) and select all rows. Next, select TextFX -> TextFX Edit -> Line up multiple lines by (Clipboard Character):

TextFX Line up multiple lines by

Now the result should be much more readable:

Aligned columns in Notepad++

And here is the text that I used in my example:

1 2 3

PK;Name;InvoiceNumber;InvoiceDate;ReferenceNumber;DueDate;Amount 12688564;Tomas Lind;123456;2016-02-17;111;2016-03-17;1000 101;Mr X;88;2016-02-07;0;2016-03-17;100