Split a List into Columns

Keep one record per source row and choose the separator between its fields.

List Column Splitter

1. Paste the rows into Insert list. Keep each source record on its own line.
2. Leave Split by empty to separate whitespace-delimited items, or enter a literal separator. Clear Begin with uppercase letters if you want to preserve the original capitalization.
3. Click Split to process the current input.
4. Read Result — list 1 through Result — list 6. Each column holds the corresponding field from every input row; unused columns are empty.
5. Click Copy under the output you want to keep. Use Clear where shown to clear the text fields; option selections stay as set.

With apple red and pear green, the default first column is Apple, Pear, and the second is Red, Green.

Keep row alignment across columns

A row with fewer fields leaves an empty position in later used columns. Review all outputs together when reconstructing records in a spreadsheet.

Six fields per source row

Only the first six fields in each row are returned. This is literal delimiter splitting, not a CSV parser: quotes do not protect separators inside quoted values.