CSV Sorter

Put a mailing list in alphabetical order, rank products by sales or price, order transactions by date before reconciling them, group survey responses by answer, or prepare a file for an import that expects rows in a particular order. Sorting before comparing two exports also makes differences much easier to spot.

Choosing the right comparison avoids the classic sorting mistakes, such as 100 coming before 20 or 1 March coming after 31 January in text order.

When the first column has equal values, the second column decides their order, and then the third. Sort a customer list by country, then city, then surname; an order export by status, then date descending; or a product list by category, then price. Rows that are equal in every chosen column keep the order they had in the original file — a stable sort — so sorting again by another column never shuffles ties unpredictably.

Unlike a spreadsheet round-trip, sorting here does not change any value: leading zeros, long ID numbers, accents and line breaks inside quoted fields all survive. The separator is detected automatically — comma, semicolon, tab or pipe — and kept in the download. Values that cannot be read as the chosen type, such as n/a in a numbers column, are placed after the real values rather than causing an error, and empty cells always go last, whichever direction you choose.

Customer lists, sales reports and HR exports often contain personal data, so the file is read and sorted on your device and never uploaded. Large files with many thousands of rows sort in a moment. To remove duplicate rows use the CSV Deduplicator, to clean whitespace and empty rows use the CSV Cleaner, and to convert the result to a spreadsheet use CSV to Excel.