Column Splitter
Split a column of text into multiple columns by any delimiter. Paste your data, choose the delimiter, and the tool splits each row — perfect for splitting "John Doe" into "John" and "Doe", separating tags, or converting delimited data into separate columns.
What Is a Column Splitter?
A column splitter (or "text to columns" tool) takes text that is packed into a single cell or column and separates it into multiple columns based on a delimiter. It is one of the most common data-cleaning operations — the inverse of concatenation.
In Excel, this is the "Text to Columns" feature. In Google Sheets, it is "Split text to columns" under the Data menu. This tool does the same thing in your browser — useful when you do not have Excel open, or when you want to process data without uploading it to a spreadsheet.
How Column Splitting Works
- For each row in your input, split on the chosen delimiter.
- If the row is
"John,Doe,30"with delimiter ",", split into ["John", "Doe", "30"]. - If splitting further (e.g., split the first column too), each part of the first column becomes its own column.
- Join the resulting cells with the output delimiter (default: tab, for easy paste into Excel).
- If a row has more columns than the first row, the extra columns are preserved as-is.
Worked Example
Input (4 rows, 3 columns):
John,Doe,30 Jane,Smith,25 Bob,Johnson,35 Alice,Brown,28
Output (4 rows, 3 columns — same structure, tab-separated for Excel paste):
John Doe 30 Jane Smith 25 Bob Johnson 35 Alice Brown 28
Example 2 — split "John Doe,30" into two columns:
Input delimiter: comma. First split gives ["John Doe", "30"]. Then split the first part on space → ["John", "Doe", "30"]. Output: John [TAB] Doe [TAB] 30.
Common Uses
- Split full names — "John Doe" → first name + last name (delimiter = space)
- Split addresses — "123 Main St, City, 12345" → street, city, postal code (delimiter = comma)
- Split tags or categories — "red,blue,green" → separate tag columns (delimiter = comma)
- Convert semicolon-CSV to comma-CSV — European CSV uses `;`; convert to `,` for Excel
- Split log data — "2026-01-01T10:00:00|INFO|User logged in" → date, level, message
- Prepare data for import — combine split columns to match the target system's format
Frequently Asked Questions
What is the difference between this and Excel's Text to Columns?
Functionally identical. Excel's "Text to Columns" wizard splits a single column into multiple columns in the spreadsheet. This tool does the same thing, but outputs the result as text (tab-separated by default) that you can paste into Excel or any other tool. The advantage: you don't need to open Excel, and your data stays in your browser.
How do I handle rows with a different number of columns?
Rows with fewer columns are output with fewer cells (the trailing cells will be empty or missing depending on the target tool). Rows with more columns are preserved with their extra columns intact. For best results, ensure your input data is consistent — all rows should have the same number of delimiter-separated fields.
Can I split by multiple delimiters at once?
Not in a single pass with this tool. If you need to split by multiple delimiters (e.g., both comma and semicolon), convert one to the other first — or run the splitter twice. For complex multi-delimiter splitting, use a scripting language (Python, JavaScript) or a regex-based tool. For most practical cases, a single delimiter is enough.
Does the splitter handle quoted fields with commas?
No — this tool does not parse CSV quoting rules. If your data contains quoted fields with embedded delimiters (e.g., `"Smith, John", Doe`), those quotes will be treated as part of the value and the comma inside them will still split. For robust CSV parsing, use a proper CSV library (Python's csv module, Papa Parse in JS, or Excel's built-in import).
Why is the output tab-separated by default?
Because tab-separated output pastes cleanly into Excel and Google Sheets — each tab becomes a column boundary in the spreadsheet. Comma-separated output would be split into columns by Excel's default "open CSV" but pasting comma-separated text usually goes into a single column unless you use "Text to Columns" again. Tab-separated is the most convenient for copy-paste. You can change it to comma or semicolon if needed.
Is my data private?
Yes — everything runs in your browser. Your data is not sent to any server, not stored, and not shared. When you close the tab, the data is gone. Copy or download the output before closing the tab if you need to keep it. This is especially important for customer data, financial records, or any sensitive information.