Sorting rows — Trusty CSV User Guide

Sorting Columns in Trusty CSV

To sort data by columns in Trusty CSV, position the cursor in the column of interest and select either Columns › Sort Ascending or Columns › Sort Descending. This action rearranges the rows based on the selected column while keeping the header row at the top; a row with line breaks in a value will move as a whole.

Sorting Multiple Columns

To sort by multiple columns or to specify how values are compared, use the Columns › Sort by Several Columns… option found in the column’s menu. This also appears when clicking the three dots next to the column number in the column bar, starting with the current column.

Example of a Data Set

product category price
Espresso coffee 2.20
Matcha latte tea 4.20
Flat white coffee 3.40
Chai tea 3.60
Cold brew coffee 10.90
Cortado coffee 3.10
Croissant bakery 2.60
Earl grey tea 2.90
Cappuccino coffee 3.30
Banana bread bakery 3.20
Mocha coffee 3.90
Green tea tea 2.70
Cinnamon roll bakery 3.50
Americano coffee 2.60
Rooibos tea 2.80
Brownie bakery 2.95
Macchiato coffee 2.90
Iced tea tea 3.10
Muffin bakery 2.75
Latte coffee 3.50

Numeric and Date Sorting

Trusty CSV sorts numbers by their value; for instance, 9.50 sorts before 10.00, taking into account the column’s decimal separator. A column filled with dates is sorted by day and time, regardless of formatting, with 31/12/2025, 2026-01-05, and 5 Jan 2026 9:30 appearing in chronological order.

Comparing Text Values

When sorting text, the software uses a conventional word order—not distinguishing between capital and lowercase letters. For example, Item 2 would be before Item 10. Any rows that contain empty cells or values inconsistent with the column type will be moved to the end.

Sorting Behavior

When using Sort by Several Columns..., a window appears that allows the user to select the sort order for up to five columns. The first listed column is the primary sort key, followed by the secondary, tertiary, and so on, allowing for elaborate sorting structures.

Summary of Types of Sort

Empty cells and null values always appear at the end, maintaining consistency in sorting.