How to Add New Column in CSV File in Notepad++

If you have a CSV file that you are working on with Notepad++ and want to add a new column at the start, end, or middle of it, then you should get the CSV Lint Plugin.

Once installed, go to Plugins: CSV Lint > CSV Lint Window

First click on the "Detect Columns" button, your CSV file will be validated and column headers will be detected.

Format=CSVDelimited
ColNameHeader=True
Col1=Day Integer Width 1
;Col1=Day Enumeration 1|2|3
Col2=Visits Integer Width 4
;Col2=Visits Enumeration 2000|2409|3405
Col3=Sales Integer Width 2
;Col3=Sales Enumeration 10|14|30

Now click on "Add Column" to add a column. Now based on the original column you select, click Ok.

You will see that a new column will be introduced which you can edit and add data.

Day,Visits,Visits (2),Sales
1,2000,0000002000,10
2,2409,0000002409,14
3,3405,0000003405,30