OpenRefine

Sorting Columns

To sort by one column:

1. Choose the column you would like to sort.
2. From the drop-down beside the column header, select "Sort...." This will create a pop-up box.
3. In the pop-up box, you can choose to sort your chosen cell values by text (as well as case-sensitive text), numbers, dates, and booleans. For each option, you can choose to sort in ascending or descending order.
   • Text: a-z or z-a
   • Numbers: smallest first or largest first
   • Dates: earliest first or latest first
   • Booleans: false then true or core-views/true-false 
4. Select "OK"

To sort multiple columns:

1. Choose the column you would like to sort.
2. From the drop-down beside the column header, select "Sort...." This will create a pop-up box.
3. In the pop-up box, you can choose to sort your chosen cell values by text (as well as case-sensitive text), numbers, dates, and booleans. For each option, you can choose to sort in ascending or descending order.
   • Text: a-z or z-a
   • Numbers: smallest first or largest first
   • Dates: earliest first or latest first
   • Booleans: false then true or core-views/true-false 
4. Select "OK"
5. Repeat steps 1 - 4