Note More than one sorting criteria can be applied
- Open CSV file in Excel
- Press CTRL + A
- In the menu, select Data and choose Sort
- Select box My Data Has Headers
- In 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, type y 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
- In Format, select CSV
- Click Save
- The file format warning box appears; click Continue