Notepad++: Convert Comma-Separated Values Easily

Do you use Notepad++ at work? It has useful commands to convert comma-separated values into columns and vice versa. Let me explain the shortcuts.

1. Converting Comma-Separated Rows into Columns

I need to convert a comma-separated row into a column. The column values should not have commas at the end.

Data

Krishna,Rani,Mohan,Radha,Venki,Sowmya

Ctrl+A, and Ctrl+H. Then, use the below parameters.

Find What , 
Replace with \n  
Search Mode Regular expression.

Click on the Replace All.

Final result

2. Converting Columns into Comma-separated Rows

My data is

ABC

BCD

CDE

select CTRL+A and CTRL+H , in the window use

Find What: \r\n

Replace with: ,

Select Extended in Search mode.

Now click on Replace All

References

• Notepad++ Documentation