A CSV file consists of a spreadsheet where the data is separated by commas. This is a type of format for saved data. You can use Excel to sort a CSV file.
Note: More than one sorting criteria can be applied
Open CSV file in Excel
Press CTRL + A
In the menu, select Data > Sort
Check the box next to My Data Has Headers
Under Column, choose column you want to sort your list
Choose what order you want to use reorganize your list
Note: If you want to refine your sorting order, click Add Level and a new sorting line will appear
Click OK
Review your reordered list
In the menu, select File and choose Save As
Choose where you want to save your CSV file
Select CSV format
Save
Note: If you cannot sort the CSV file properly with the above method, please contact our support team via Contact US.
