Sort CSV by column: put the rows of a list in order by any column
In short: Upload a list, choose a column and how to read it, and download the rows in order. Blank cells go last and every other column stays with its row. Limit: One column per pass.
Upload a CSV or .xlsx file, or paste it with a header row. Choose the column to sort by and how to read it: as text, as text with numbers in order so A2 comes before A10, or as a number that understands 1,250 and $12. Choose the direction. Blank cells go last and every row keeps all its columns.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Five example rows sorted by an Employees number put 9, 45, 120 and 1500 in order and the blank last.
- Rows sorted
- 5
- Sorted by
- Employees
- Read as
- Number
What this means for you
Order does not show which mailboxes work; a check shows which addresses exist.
- Text, natural or number
- Ascending or descending
- Blanks always last
- Equal rows keep order
- Sort
- CSV
- Column
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Sorted the list? Check the addresses before the send.
- Download the sorted list, or use the check button under the result, which carries its addresses across.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I sort a CSV by a column?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Choose the column to sort by.
- Choose how to read it: text, text with numbers in order, or number, and the direction.
- Download the sorted list.
Example
- You enter
- Five rows with an Employees column of 120, 9, 1500, a blank and 45, sorted as a number, smallest first.
- You get
- 5 rows sorted: Ben Hart (9), Eli Park (45), Ava Stone (120), Cara Lin (1500), and Dev Rao with the blank last.
- Limits
- Runs in your browser; nothing is uploaded. It sorts by one column and has no effect on which addresses bounce.
How are the three ways of reading a column different?
As text, cells are compared letter by letter without regard to upper and lower case, so 10 comes before 9. As text with numbers in order, digits inside the text are compared as numbers, so A2 comes before A10 and 9 before 10. As a number, the cell is read as a value, ignoring commas, spaces and the signs $, £ and €, so 1,250 comes after 120.
A cell that is not a number in a number sort is placed after the numbers and counted, so you can see what could not be read.
Where do blank cells go?
Always last, whether the order is ascending or descending, so the rows that have a value are together at the top. Rows with equal values keep the order they had in the file.
To sort addresses by domain, mailbox provider or domain ending, use the email list sorter. To put the rows in a random order instead, use the email list shuffler.
What does it not do?
It sorts by one column at a time; to sort by two, sort by the second column first, then load that file and sort by the first, since equal values keep their order. It does not read dates in different formats; a date column sorts correctly only as text when written year first, such as 2026-11-10. See also clean the list before a campaign.
Who uses this tool, and for what?
- Cold emailers
- Put a lead list in order by company size or a last-contacted number.
- Marketers
- Sort a customer export by name to find repeats by eye.
- Analysts
- Sort a numeric column as numbers, not as text, without opening a spreadsheet.
What can’t this tool tell you?
- One column per pass.
- Dates are sorted as text, so only year-first dates come out in order.
- Text sorting follows English collation and may place some accented letters differently from another language's rules.
- Only the first sheet of a workbook is read.
Common questions
- Does the header stay on top?
- Yes. The first row is the header and is never sorted.
- Are upper and lower case treated the same?
- Yes. apple and Apple sort together.
- Can I sort by two columns?
- One column per pass. Equal values keep their order, so sort by the second column first, then by the first.
- How are dates sorted?
- As text. That works for year-first dates such as 2026-11-10. Other date formats do not sort correctly.
- Does it need an email column?
- No. Any CSV works. If the list has a column of addresses, the check button under the result carries them across.
- Is my file uploaded?
- No. The file is read in your browser and goes nowhere.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.