CSV tags to columns: turn a tags column into one yes or no column per tag
In short: Upload a list, pick the tags column and the separators, and download a file with a column for each tag and a yes or a blank on every row. Limit: It cannot tell a comma inside a tag from a separator.
Upload a CSV or .xlsx file, or paste it with a header row. Pick the column holding the tags and the separators between them: comma, semicolon or pipe. Every tag becomes its own column with yes on rows that have it. Tags that differ only in capitals are merged, and rare tags can be left out.
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 tags such as "vip, webinar" become 3 tag columns: vip and webinar on 2 rows each, trial on 1.
- Columns made
- 3
- Rows with no tag
- 1
- Tags left out
- 0
What this means for you
Tag columns do not show which mailboxes exist; a check of the addresses does.
- Comma, semicolon or pipe
- Capitals merged
- Your yes and no values
- Rare tags optional
- Tags
- CSV
- Columns
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Tags split? Check the addresses before you import.
- Download the 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 tags column into one column per tag?
- Upload the file as a CSV or .xlsx, or paste the cells with the header row first.
- Pick the tags column and tick the separators used between tags.
- Choose what a row with the tag and a row without it should hold, and the smallest tag worth a column.
- Check the table of tags and download the file.
Example
- You enter
- Four rows with Email and Tags: ava with "vip, webinar", ben with "Webinar, trial", cara with no tags and dev with VIP, separated by commas.
- You get
- 3 tag columns made (vip 2 rows, webinar 2 rows, trial 1 row) with yes or a blank on every row. 2 tags were merged across capitals (vip and VIP, webinar and Webinar) and 1 row has no tag.
- Limits
- Runs in your browser; nothing is uploaded. It cannot tell a comma inside a tag from a separator.
When do you need one column per tag?
Exports from email platforms, CRMs and form tools often put every tag a contact has in one cell, such as vip, webinar, trial. A spreadsheet filter or an import into a tool without tags cannot use that. One column per tag lets you filter, count and map each tag on its own.
Each new column holds the value you choose when a row has the tag, such as yes or TRUE, and a second value, or a blank, when it does not.
How are the tags read?
The cell is split on the separators you tick, spaces around each tag are trimmed, runs of spaces inside a tag become one, and blank pieces are dropped. VIP and vip are one tag and the first spelling is used; the tool tells you how many tags it merged. A tag repeated in one cell counts once for that row.
A comma inside a tag, such as Acme, Inc, cannot be told from a separator, so untick comma if your tags use semicolons.
What if there are hundreds of tags?
Set the smallest tag worth a column. Tags on fewer rows than that are listed in the table but get no column, and at most 200 columns are made, most common first. To split a cell into numbered columns instead, use the CSV column splitter; to tidy columns first, use the CSV column editor.
Who uses this tool, and for what?
- Newsletter owners
- Prepare a subscriber export for a platform that imports one field per segment.
- Sales teams
- Filter a CRM export by tag in a spreadsheet without text searches.
- Agencies
- Count how many contacts have each tag before a migration.
What can’t this tool tell you?
- It cannot tell a comma inside a tag from a separator.
- At most 200 tag columns are made, most common first.
- It does not rename or group related tags; it only merges ones that differ in capitals.
- Only the first sheet of a workbook is read.
Common questions
- What do the new columns hold?
- The value you choose for a row that has the tag, yes by default, and the value you choose for one that does not, a blank by default.
- Are VIP and vip the same tag?
- Yes. Tags that differ only in capitals become one column named after the first spelling, and the tool says how many were merged.
- Can I keep the original tags column?
- Yes, and that is the default. Untick the box to drop it from the new file.
- What if a new column name matches an existing column?
- It gets (tag) added to its name so no column is overwritten.
- Can I mix separators?
- Yes. Tick comma, semicolon and pipe together if your cells use more than one.
- 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.