Split/Expand CSV rows by delimiter
One cell with multiple values becomes multiple rows. Pick the column, choose the delimiter, and download the expanded CSV — all in your browser.
No preview yet
Upload a CSV or paste data and click Split Rows.
Split CSV rows by delimiter — in seconds. No Excel formulas.
I exported contacts from my CRM. All emails were packed into one cell, comma-separated. I needed one email per row. Excel made it painful. This tool takes 10 seconds.
Why splitting multi-value cells matters
CRMs, e-commerce platforms, and survey exports routinely dump multiple values into a single cell. Tags, emails, phone numbers, categories — they pile up behind a delimiter. Normalized data is easier to import, deduplicate, filter, and enrich. One value per row is the standard your tools expect.
Split a column into multiple rows in CSV
Use this tool when you need to split a column into multiple rows in a CSV. It is built for files where one cell contains several emails, tags, phone numbers, categories, skills, or IDs separated by a delimiter.
This is one of the fastest ways to normalize CSV data and normalize CSV multi-value cells before importing the file into another system. Instead of keeping several values in one record, you expand rows in the CSV so each value gets its own row.
How to split a cell into multiple rows in Excel
Many people search for how to split a cell into multiple rows in Excel or how to split comma separated values into multiple rows in Excel. For CSV files, this online tool is usually faster than building formulas, using Power Query, or manually copying rows.
Paste or upload your CSV, choose the column, confirm the delimiter, and download the result. If your goal is to convert a multi value cell to rows in CSV online, this page is built exactly for that workflow.
Example: split multi-email contacts into one row per email
A common CRM export puts every contact email in a single cell. Splitting expands each contact into individual rows you can import into any tool.
Name,Emails Mia Chen,"mia.chen@example.test,mia@workmail.test" Lucas Martin,"lucas@northwind.test,l.martin@personal.test,lucas@ops.test" Sofia Lopez,sofia.lopez@example.test
Name,Emails Mia Chen,mia.chen@example.test Mia Chen,mia@workmail.test Lucas Martin,lucas@northwind.test Lucas Martin,l.martin@personal.test Lucas Martin,lucas@ops.test Sofia Lopez,sofia.lopez@example.test
Example: explode product tags into individual rows
Product catalogs often pack multiple tags into one cell. Splitting gives you a clean tag-per-row structure ready for filtering, grouping, or analytics.
Product,Tags Laptop,"electronics,computers,work" Headphones,"electronics,audio"
Product,Tags Laptop,electronics Laptop,computers Laptop,work Headphones,electronics Headphones,audio
How the tool splits CSV rows
Column to split
Pick the column that contains multiple values in a single cell. All other columns are duplicated across the new rows. Only one column is expanded at a time in this version.
Cell delimiter
This is the character that separates values inside the cell — different from the CSV column separator. Common choices are comma, semicolon, pipe, and tab. The tool suggests a delimiter based on your data.
Trim spaces
Enabled by default. Removes leading and trailing whitespace from each value after splitting. Useful when values are separated by ", " instead of just ",".
Advanced options
Remove duplicates
When a cell contains `a,a,b`, enabling this option keeps only one `a` and produces two rows instead of three. Useful when your source data has accidental repetition.
Skip empty values
When a split produces an empty string (e.g. from a trailing delimiter like `a,b,`), this option drops that empty value instead of creating a blank row.
Empty cells are kept by default
If a cell is completely empty, the row is preserved as-is. Only cells that actually contain the delimiter are expanded.
Works with large CSV files
Splitting expands your row count, sometimes significantly. A file with 5,000 rows averaging 3 values per cell becomes 15,000 rows. The tool handles that without breaking a sweat.
The preview shows the first 100 output rows so the browser stays responsive. Download the full CSV once you've confirmed the split is correct.
Your file never leaves your browser
All parsing and splitting happens locally in your browser using a Web Worker. No file is uploaded to a server. That matters when you're working with customer data, CRM exports, or confidential contact lists.
This tool is free to use and requires no account.
When to use this tool
Split comma separated values into rows
Turn `a,b,c` inside one cell into three separate rows — the most common use case for CRM and e-commerce exports.
Normalize CSV with multiple emails per cell
Expand contact lists where one person has multiple emails packed into a single column so each email gets its own row.
Split a column with multiple values into rows
When one CSV column stores several values in one cell, expand it into separate rows so the file becomes easier to import, filter, and analyze.
Explode tags and categories
Product catalogs, blog posts, and support tickets often store multiple tags in one field. Normalize them before analysis.
Unnest phone numbers
When contacts have multiple phone numbers in one cell, split them into individual rows for cleaner imports into dialers or CRMs.
Tidy data for deduplication
One value per row is the tidy data standard. After splitting, use Datablist to deduplicate, filter, and enrich the results.
Prepare data for imports
Most CRM and marketing platforms expect one value per row. Splitting is often the first step before importing or enriching your data.
CSV explode, unnest, flatten, or unpivot
Different tools describe this transformation in different ways. You might be looking for a CSV explode column tool, a way to unnest a CSV column, a method to flatten a CSV column, or a CSV unpivot multi-value column workflow.
In practice, the objective is the same: tidy data with multiple values per cell so one value becomes one row. That structure is easier to join, deduplicate, group, enrich, and export.
FAQ
Can I use a semicolon as the cell delimiter?
Yes. The tool supports comma, semicolon, pipe, tab, and custom delimiters. It also tries to auto-detect the correct delimiter from your data when you select a column.
Does it work with large CSV files?
Yes. The splitting is done inside a Web Worker so it does not block the browser. The preview is capped at 100 rows, but the full output is available for download even when your file has tens of thousands of rows.
Is my data uploaded to a server?
No. Everything runs locally in your browser. Your CSV is never sent to any server. This makes it safe for customer data, internal exports, and anything else you wouldn't want to upload.
What happens to cells that don't contain the delimiter?
They are kept as-is. Only cells that actually contain the delimiter character are expanded into multiple rows. Empty cells are also kept by default.
Does it handle quoted CSV fields correctly?
Yes. The underlying CSV parser handles quoted fields properly. A value like "mia.chen@example.test,mia@workmail.test" (quoted) is treated as a single value and split by the cell delimiter, not the CSV separator.
Need to deduplicate or enrich your data after splitting?
Once your data is normalized — one value per row — Datablist makes it easy to deduplicate contacts, enrich with external data, filter by any column, and export a clean final file.
Try Datablist free