Developer tools
CSV Sort
Sort rows by a column. Keep every field intact.
Processed in your browser
1. Add CSV
Paste CSV, or open a UTF-8 file.
Auto-detect tries comma, semicolon, tab and pipe. Choose explicitly if the preview looks wrong.
2. Choose order
1 is the first column. Preview headings show each column number, even for duplicate names.
Changing input or options clears the result. Choose Sort CSV again to apply them.
Preparing tool…
Sorted CSV
No result yet
Scroll within the table to see more columns. With the table focused, use the arrow keys.
Preview shows 25 rows and 8 columns at a time. Copy and download include every record.
Exports preserve field values, including formula-like text. Spreadsheet apps may interpret formulas or leading zeros when opening CSV; import columns as text when needed. Quoting and line endings are normalized.
How to sort a CSV
- Add your CSV
Paste text or open a UTF-8 file. Check the delimiter and header setting.
- Choose the order
Select a column, text or exact numbers, direction and blank placement.
- Save your result
Sort, inspect the preview, then copy or download every record.
Predictable sorting
Ties keep their original order. Exact numbers keep all their digits, and blank cells go where you choose. Field values stay intact; export formatting is normalized.
Processing stays in your browser. Copy and download happen only when you choose them.
Frequently asked questions
How do text and exact number sorting differ?
Text uses English locale rules, with significant accents and optional case sensitivity. Digits sort as characters, so “10” comes before “2”. Locale details may vary with browser Unicode data. Exact number accepts signed decimals and scientific notation such as -2.5 and 1e6, compares every digit without rounding, and ignores surrounding whitespace for comparison only. Currency symbols, grouped numbers, NaN and Infinity produce a record-specific error.
How are blank cells and equal values sorted?
Empty, whitespace-only and missing keys share your chosen first or last placement in both directions. Equal keys keep their original order, and every row retains its original fields.
How do I choose a column with no unique name?
Use its position, starting at 1. The preview numbers columns independently of their header labels. Sort once by column 1 to inspect the table, then change the column number.
Are there file or row limits?
No fixed admission limit is imposed. Input, parsed rows and the download must fit browser memory. Processing runs in your browser; Cancel stops processing. If the browser cannot finish, retry with a smaller input.
Are files uploaded or saved?
No. Processing stays in your browser. The tool does not upload or persist your files. Copy writes to your clipboard only when chosen; download saves only when you choose it. Reset clears the current input and output.
Does sorting change my data?
Only row order changes. Equivalent sort keys remain in their original order. The first row stays fixed when header is enabled. A result already in the requested order says so. Export formatting may differ from the source because every field is quoted and record separators use CRLF. An initial UTF-8 BOM is omitted. Pasted text follows the browser’s newline normalization; open the file to preserve line breaks within quoted fields exactly.