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
  1. Open CSV file in Excel
  2. Press CTRL + A
  3. In the menu, select Data and choose Sort
  4. Select box My Data Has Headers
  5. In Column, choose column you want to sort your list
  6. 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
  7. Click OK
  8. Review your reordered list
  9. In the menu, select File and choose Save as....
  10. Choose where you want to save your CSV file
  11. In Format, select CSV
  12. Click Save
  13. The file format warning box appears; click Continue