Data Sorter
Sort CSV rows by any column, with numbers sorted numerically rather than as text.
Processing: This tool runs entirely in your browser. Your input and any file you open stay on your device — nothing is uploaded to a server.
How to use the data sorter
- Paste your CSV.
- Choose the column and direction.
- Copy or download the sorted result.
About this tool
Sorting by a column, with the header left in place.
The detail that matters is numeric sorting. Sorted as text, 10 comes before 9, because text comparison works character by character and "1" precedes "9". This checks whether both values in a comparison are numbers and sorts them numerically when they are — so 9, 10, 100 comes out in that order rather than 10, 100, 9. That single behaviour is the most common complaint about sorting in tools that treat everything as a string.
Mixed columns fall back to text comparison for the pairs that are not both numeric, which keeps the sort stable and predictable rather than throwing an error on the one row with "N/A" in it.
Text sorting uses locale-aware comparison, so accented characters order sensibly rather than being pushed to the end as their code points would put them.
Parsing handles quoted fields properly, so a comma, quote or line break inside a value does not split it. That is the difference between this and splitting on commas, and it is why exports containing addresses or free-text notes so often arrive mangled.
Everything runs in the page. Spreadsheets are usually the most sensitive files anyone handles — customer lists, payroll, financial records — so a tool that works on them without uploading them is doing the one thing that matters most here.
Common uses
- Ordering an export by date or amount.
- Sorting a list alphabetically before sharing it.
- Putting the largest values first to find outliers.
Frequently asked questions
- Why do other tools sort 10 before 9?
- They compare as text, character by character, so '1' precedes '9'. This detects numeric columns and sorts them as numbers.
- What happens with a mixed column?
- Pairs that are both numeric sort numerically; anything else falls back to text comparison, so one 'N/A' does not break the sort.
- Does the header get sorted too?
- No. The first row is treated as the header and stays where it is.
Related tools
Sort Lines
Sort lines alphabetically, numerically, by length, in reverse or shuffled.
Row Filter
Keep only the CSV rows matching a condition on one column.
Data Deduplicator
Remove duplicate rows from a CSV, matching on the whole row or one column.
CSV Validator
Check a CSV for ragged rows, duplicate headers and structural problems before importing it.