Free tool
Split text into columns
Split text into columns at spaces, commas or any separator. Each part becomes a column (separated by tabs, so it pastes into a spreadsheet as columns). You can limit the number of columns and count from the right.
The example is loaded. Paste your own list to replace it.
→ 3 lines
Split at
Most columns (0 = no limit)
Count from the right (the last split comes first)
Trim spaces around each part
Your text
Result
What it does
Split each line at a separator into tab-separated columns (pastes into a spreadsheet as columns).
Settings you can change
- Split at: Spaces, Commas, Semicolons, Pipes |, Other text (type it), A pattern (regular expression)
- Other text or pattern
- Most columns (0 = no limit)
- Count from the right (the last split comes first)
- Trim spaces around each part
When to use it
Full names are in one column and you need first and last name in two. Split at the first space only.
Example: split text into columns
Settings used: Most columns (0 = no limit): 2.
Input
Result
Tips
- With "Count from the right", Mary Ann Smith splits into "Mary Ann" and "Smith".
Often used with
Break text at commas (or another separator) so each item gets its own line.
Keep one column of CSV or tab-separated rows.
Turn CSV into tab-separated text (for pasting into a spreadsheet), or the other way round.
Your text stays on this computer
Got your list from a web page?
HeyScraper turns the page you’re on into a spreadsheet, so you can skip the copying and pasting. Free: 500 pages a month.
Get HeyScraper