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:
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:
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):
Now the result should be much more readable:
And here is the text that I used in my example:
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