The following steps show how to convert a character (for example a tab or comma) with a new line using Notepad++.

For this example we’ll be converting

The,Quick,Brown,Fox,Jumped,Over,The,Lazy,Dog

to

The
Quick
Brown
Fox
Jumped
Over
The
Lazy
Dog

1. Open the file using Notepad++ (or paste the text into a new file)
2. Open the Search -> Replace menu
3. In the ‘Find what’ box enter the character to convert to a new line
4. In the ‘Replace with‘ box enter \n
5. Under ‘Search Mode’ select ‘Extended’
6. Click ‘Replace All‘
7. All the characters will now be converted to new lines.

TIP: use \t for a tab character