CSV column to list: pull one column out as a plain list or a comma-separated line
In short: Upload a list, choose a column and a format, and copy or download its values. Blanks are skipped and repeats can be dropped. Limit: One column per pass.
Upload a CSV or .xlsx file, or paste it with a header row. Choose a column and a format: one value per line, separated by commas or semicolons, each in double quotes, or each in single quotes for an SQL IN list. Blank cells are skipped and repeats can be dropped. Copy the list or download it.
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 give 3 emails, one blank skipped and one repeat removed: ava@acme.com,ben@globex.de,dev@hooli.com.
- Values
- 3
- Blank cells skipped
- 1
- Format
- Commas
What this means for you
Pulling out a column does not show which mailboxes work; a check shows which addresses exist.
- Lines, commas, quotes, SQL
- Blanks skipped
- Repeats optional
- Copy or download
- Column
- List
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Pulled out the column? Check the addresses before the send.
- Copy or download the list, or use the check button under the result, which carries the 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 turn a CSV column into a list?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Choose the column whose values you want.
- Choose how to write them: one per line, comma separated, quoted or for an SQL query.
- Copy the list or download it as a text file.
Example
- You enter
- Five rows with an Email column that holds ava@acme.com twice (once as AVA@acme.com) and one blank cell, written separated by commas.
- You get
- 3 values: ava@acme.com,ben@globex.de,dev@hooli.com. 1 blank cell skipped and 1 repeat removed.
- Limits
- Runs in your browser; nothing is uploaded. It copies the text of the cells and does not check that an address works.
What does it do with blanks and repeats?
Blank cells are skipped and counted. Each value is trimmed. With repeats removed, two values that differ only in upper and lower case count as the same, and the first spelling is kept, so AVA@acme.com after ava@acme.com is dropped.
Switch off the repeat option to keep every value, in the order of the file.
Which formats are there?
One per line suits a paste into a verification box or a suppression list. Comma or semicolon separated suits the To or Bcc line of a mail program that wants one line. Double quotes with commas gives a CSV-style row or a code array. Single quotes with commas is the list inside an SQL IN (...) clause, with any single quote in a value doubled.
Turn a list the other way with the email list formatter, or drop a whole column from a file with the CSV column editor.
What does it not do?
It copies the text of the cells and does not check it. A column of addresses is not checked for syntax or for working mailboxes here; for that, use the check button under the result. Before pasting a long line into a mail program, note that most limit how many recipients one message may have; see email sending limits.
Who uses this tool, and for what?
- Cold emailers
- Copy the email column as one per line to paste into a checker or a suppression list.
- Marketers
- Get a comma-separated line of addresses for a mail program that takes one.
- Analysts
- Turn a column of IDs into an SQL IN list for a query.
What can’t this tool tell you?
- One column per pass.
- It copies cell text as it is and does not check it.
- A very long single line may be too long for the program you paste it into.
- Only the first sheet of a workbook is read.
Common questions
- Can I get more than one column?
- One column per pass. To keep several columns in a file, use the CSV column editor.
- Are repeats removed by default?
- Yes, ignoring upper and lower case. Untick the option to keep every value.
- Is the order kept?
- Yes. Values are in the order of the file.
- Does it escape quotes?
- In the double-quote format a quote inside a value is doubled, as in CSV. In the SQL format a single quote is doubled.
- Does it need an email column?
- No. Any column works. If the list has a column of addresses, the check button under the result carries those 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.