Toolvore

CSV Cell Splitter

Split one CSV column by a literal separator, retain text identifiers and choose rows or numbered columns with reviewed exports.

This tool processes its input contents in your browser instead of sending them to a processing service. Page, asset and fixed usage-measurement requests are described on the Privacy page.

Expand packed CSV cell values into rows or numbered columns using one literal separator, with explicit empty/trim and spreadsheet-export choices.

How to use it

  1. 1Paste comma-separated CSV and choose its column number and literal separator.
  2. 2Select rows or columns and review trim, empty-part and formula-protection choices.
  3. 3Split, inspect the result, then download CSV or its count report.

Example

Input
id,tags 001,"red;blue"
Output
id,tags 001,red 001,blue

Split column 2 by semicolon into rows. The ID stays the text 001.

What happens to your data

Cell splitting uses Toolvore's strict CSV parser in this tab. Source rows, repeated identifiers and generated CSV are not uploaded; the count report records settings rather than the original table.

Last updated November 2026

Split a packed CSV column into individual values without opening a spreadsheet. A tags cell containing red;blue can become two rows with the same ID, or two numbered columns. This operates inside a cell; it does not split an entire CSV into separate files or unpivot measurement headings.

How it works

Choose the one-based column number, the exact separator text and whether parts become rows or columns. Separators are literal, so punctuation such as .* has no regex meaning. The input itself is comma-separated CSV with strict quoted-field handling. Quoted commas and line breaks are parsed before splitting cells.

Rows mode repeats all other cells for each retained part. Columns mode replaces the selected column with headers such as tags.1 and tags.2, preserving the order of other columns and padding shorter records with empty strings. Duplicate generated headers fail instead of overwriting data. Empty parts remain by default, including adjacent or trailing separators. Optional trim occurs before optional empty-part removal. Expansion is checked before allocating an excessive table.

CSV output uses UTF-8 without BOM and CRLF endings. Up to 500 KiB input, 10,000 records including the header, 128 columns, 200,000 cells and 2 MiB output. Spreadsheet formula protection is enabled by default and visibly prefixes formula-like cells and headers with an apostrophe. You can deliberately disable it for literal output; spreadsheet software may then execute formula-like strings. A header collision introduced by protection fails. No numeric/date coercion is performed.

Worked example: CSV Cell Splitter example

Input
id,tags 001,"red;blue"
Result
id,tags 001,red 001,blue

Split column 2 by semicolon into rows. The ID stays the text 001.

Common use cases

  • Expand a reviewed list of tags into one tag per record.
  • Separate packed account codes while repeating the source identifier.
  • Create numbered columns from consistently separated cell values.

Frequently asked questions

How is this different from CSV Split?+

CSV Split creates smaller files from complete rows. This tool divides values inside one selected column and produces one reshaped CSV.

Does it understand quoted separators inside a cell?+

Outer CSV quotes are handled by the CSV parser. The chosen inner separator is literal text; there is no second nested CSV grammar inside each cell.

Are empty parts removed?+

They remain by default. Enable skip-empty to remove exactly empty parts after any explicit trim operation.