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.

CSV Lint for Notepad++

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.

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
Add or split a column based on data from an existing column - Notepad++

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail:

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap