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.


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
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) is a seasoned developer with over 10 years of experience in web and app development, and a deep knowledge of operating systems. Author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail: rakesh@code2care.org

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