Text to Columns Splitter
Free Text to Columns Splitter: split non-empty lines into columns with a comma, semicolon, tab, space or custom delimiter; copy or download the table.
3 rows
| Ada Lovelace | London | 1815 |
| Grace Hopper | New York | 1906 |
| Alan Turing | London | 1912 |
How it works
In Excel or Google Sheets, split non-empty lines into columns with a comma, semicolon, tab, space or custom delimiter; copy or download the table.
Paste one record per line into the input box.
Choose comma, semicolon, tab, space or custom, matching the separator in the text.
Check the column count and preview, then copy the tab-separated result or download the CSV.
What this does
The splitter applies one delimiter to every non-empty line, trims whitespace around each part and previews up to eight rows. A space delimiter treats repeated whitespace as one separator. Copy produces tab-separated text for pasting into spreadsheet columns; Download CSV saves the complete result.
A worked example
Enter `Ada Lovelace, London, 1815` and choose comma. The result is 3 columns: `Ada Lovelace`, `London` and `1815`. The column count is the widest parsed row. Shorter rows remain shorter, so review uneven source data before copying or downloading it.
Common mistakes
- Choosing comma for text that uses semicolons or tabs, which leaves each line in one column.
- Using space for values that contain meaningful spaces, because each whitespace-separated word becomes a field.
- Assuming every row has the reported column count; the count is taken from the widest row.
FAQ
What happens to blank lines?
Blank lines are omitted. Every remaining line becomes one output row.
Can I split on a custom delimiter?
Yes. Choose Custom and enter a delimiter up to four characters long.
What does Copy produce?
It copies tab-separated rows so pasting into Excel or Google Sheets places fields in separate columns.
Related guides
Built in your browser when you click. Nothing is uploaded, no signup, free for commercial use.