Split CSV column by delimiter: turn one column into several, like Text to Columns
In short: Upload a list, choose the column and what to split at, and get a file with the pieces in their own columns. It works like Text to Columns in Excel. Limit: It cuts at a fixed piece of text only, with no pattern matching.
Upload a CSV or .xlsx file, or paste it with a header row. Pick the column to split and what to split at, such as a comma, a pipe, a dash, a space or a tab. Choose how many new columns to make and name them. The other columns are kept and you download the new file.
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
Four example rows with a Location column are split at the pipe into City, State and Country; one row keeps Asia | Remote together at the limit.
- New columns
- 3
- Split at
- |
- Rows
- 4
What this means for you
Split columns are not working mailboxes; a check shows which addresses exist.
- Any text to split at
- Cap on new columns
- Name the new columns
- Other columns kept
- Split
- CSV
- Columns
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Split the column? Check the addresses before the send.
- Download the new file, 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 split a CSV column into several columns?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Choose the column to split and type the character or text to split at.
- Set the most new columns to make, and name them if you like.
- Download the file with the pieces in their own columns.
Example
- You enter
- Four rows with a Location column such as Austin | TX | US, split at the pipe into at most 3 columns named City, State and Country.
- You get
- 4 rows with 3 new columns in place of Location: Austin, TX and US; Berlin and DE with a blank Country; Cardiff, Wales and UK; and Delhi, IN and Asia | Remote, the one row kept together at the limit.
- Limits
- Runs in your browser; nothing is uploaded. It cuts at a fixed piece of text and does not understand quotes or patterns.
How is the column split?
The cell is cut at each place the text you typed appears, from left to right, until the number of new columns you chose is reached. Spaces around each piece are trimmed. A cell with no such text fills only the first new column.
The last new column keeps whatever is left, so a limit of 3 on Austin | TX | US | Remote gives Austin, TX and US | Remote. The result shows how many rows hit that limit.
When is this useful on a lead list?
Use it on a location cell such as City, State, Country, a name and title joined by a dash, a tag column with several values, or an export that packs two fields into one. For an address, the split address into columns tool understands street, city and postcode; for full names, use split full name.
What does it not do?
It splits at a fixed piece of text; it does not understand quotes inside a cell or guess a pattern. If a cell holds several email addresses, split multiple emails in a cell gives one row per address. To join columns back together, use the CSV column combiner.
Who uses this tool, and for what?
- Marketers
- Split a City | State | Country cell so each part can be used to segment a send.
- Cold emailers
- Pull a title and a company apart when a scraper joined them with a dash.
- Analysts
- Turn a column of tags separated by semicolons into columns you can filter.
What can’t this tool tell you?
- It cuts at a fixed piece of text only, with no pattern matching.
- At most 20 new columns; the rest of the text stays in the last one.
- A delimiter inside quotes in a cell is treated like any other.
- Only the first sheet of a workbook is read.
Common questions
- Can I split at more than one character?
- Yes. Type the text to split at, such as a space and a dash, and the cell is cut wherever that exact text appears.
- Can I split at a tab?
- Yes. Type \t in the box and it is read as a tab.
- What if some rows have fewer pieces?
- The missing cells are left blank, and the result shows how many rows had nothing to split.
- Is the original column kept?
- Only if you tick the option. By default the new columns take its place.
- 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.