ClarityHow to use this tool
- Enter csv with a header row, sort column number, sort type, direction.
- Select Update result to view the result.
- Check the method and assumptions below before using the result.
Input reference and sample values
Use the units and choices shown for each field. Sample values are provided for practice, not as recommendations.
| Input | Format and units | Sample |
|---|---|---|
| CSV with a header row | Keep the structure and separators shown in the sample. Line breaks are retained in this input. | name,score
Ava,20
Ben,30
Ava,20 |
| Sort column number | Numeric value. Minimum: 1. Maximum: 10000. | 2 |
| Sort type | Choose Numeric / Text (case-sensitive). | Numeric |
| Direction | Choose Ascending / Descending. | Ascending |
Result for these sample inputs
name,score Ava,20 Ava,20 Ben,30
Processed locally. Review the output before using it.
Select Try the example in the form to load these values and calculate them again. This replaces the current form inputs. Compare the result with the method and worked explanation below.
Continue this task
- Remove Duplicate CSV Rows — Remove repeated rows before sorting.
- Transpose CSV — Swap the table’s rows and columns.
The method, explained
Sort data rows by the selected column. Numeric sorting compares finite numbers; text sorting compares code units.
Scores 100,20,3 become 3,20,100 with numeric ascending order.
What to keep in mind
Numeric mode rejects blank or nonnumeric cells. Text sorting is case-sensitive and not locale-specific.
Common questions
How does this tool handle my input?
Processing happens in your browser. Your pasted content is not uploaded, included in URLs or stored as a calculation history.
What input should I use?
CSV with a header row: use the example already shown, then replace it with your own content. Numeric mode rejects blank or nonnumeric cells. Text sorting is case-sensitive and not locale-specific.
Methodology maintained by ClarityKit. How these tools are built and checked.