Numeric versus text order
For 9, 12, and 100, ascending numeric order is 9, 12, 100. Text order is 100, 12, 9.
172 / 500,000 characters. Processing stays in this browser.
Sort CSV records
Limits: 10,000 data records, 200 columns, 200,000 cells. Fields remain text, including long IDs and leading zeros. Duplicate and blank headers are identified by column number.
All parsing and exports run locally in your browser. Example records are original fictional data, not an external dataset.
How to use the CSV Sorter
- 01
Load CSV with the matching delimiter and header policy.
- 02
Select a primary sort column, comparison type, and direction. Add up to two tie-breaker keys.
- 03
Choose empty-field placement, review the sorted table, and export the CSV.
Examples
Keep large IDs distinct
9007199254740993 sorts after 9007199254740992 in numeric mode. Both original strings remain unchanged in the output.
Compare decimal values exactly
Numeric mode accepts signed decimal integers, fractions, and exponent notation. It compares sign, digit strings, and decimal magnitude without floating-point coercion. Equivalent values such as 1, 1.0, and 1e0 compare equal. Currency symbols, thousands separators, spaces, NaN, and Infinity are rejected with a record and column reference.
Make ties and empty values predictable
Sort keys are evaluated in their displayed priority order. Equal values continue to the next key; records equal on every key retain original order. With empty-fields-last enabled, empty strings stay last in either direction. Otherwise empties compare below nonempty numeric values before direction is applied. Spaces are not empty.
Text order is deterministic, not locale-aware
Text mode uses JavaScript string comparison, which follows UTF-16 code-unit order. It does not infer calendar dates or natural filename numbers. Case-insensitive mode lowercases text before comparison. ISO dates with a consistent fixed-width representation often sort usefully as text, but mixed formats need normalization first.
What to know
- Input is limited to 500,000 characters. Review the supported syntax and export policy described above.
Common questions
Can I sort several columns?
Yes. Add up to three distinct columns. Each key can independently use text or numeric comparison and ascending or descending direction.
Does numeric sorting rewrite 00123 to 123?
No. Comparisons interpret values, but output uses the original field text.
Can it find the newest date?
It has no date parser. Sort consistently formatted date text deliberately, or normalize dates before using this tool.