How it works
Split the selected parsed cell by a literal delimiter. Replace that column with enough numbered output columns for the widest split, padding shorter rows with blanks.
Input definitions
- CSV with headers
- Plain text; maximum 200,000 characters.
- Column to split
- Enter the value in the labeled unit.
- Literal delimiter
- Enter the value in the labeled unit.
A worked example
- CSV with headers
- person,location Ada,London|UK Lin,Paris|France
- Column to split
- location
- Literal delimiter
- |
Assumptions & limits
Browser-local processing. CSV uses one unique header row, at most 1,000 total input rows and 50 columns. Downloads escape spreadsheet formula prefixes.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
What happens if rows have different numbers of split parts?
The output uses the widest split and fills missing parts with empty cells. Delimiters are literal strings, not regular expressions.
How does Split a CSV column by a literal delimiter work?
Split the selected parsed cell by a literal delimiter. Replace that column with enough numbered output columns for the widest split, padding shorter rows with blanks.
What are the limits of Split a CSV column by a literal delimiter?
Browser-local processing. CSV uses one unique header row, at most 1,000 total input rows and 50 columns. Downloads escape spreadsheet formula prefixes.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.