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.

1
Split into columns

→ 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

3 lines

Result

3 lines

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.

All free tools

Your text stays on this computer
The list editor works on your computer. The text you paste or open is not uploaded or stored by HeyScraper, and closing the page clears it. Saved recipes are kept in this browser only.

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