How to Sort CSV File Data in Notepad++ based on a Column

CSV Lint is the plugin that you must get on your Notepad++ text editor if you work with CSV files a lot.

This plugin can help you to sort your data by any column in ascending or descending order unlike the default sorting options that just let you sort based on the data per line.

Example: Sort Data based on Col2

Data:

Col1,Col2,Col3
1,2000,10
2,2409,14
3,3405,30

You go to Plugins > CSV Lint > CSV Lint Window

Next, you click on Detect Columns followed by Sort where you can select your column and choose Ascending/Descending options.



Result after Sorting:

Col1,Col2,Col3
3,3405,30
2,2409,14
1,2000,10