Text to Columns
Split delimited rows, choose columns, and rearrange the result.
Enter text to get started.
How to use Text to Columns
- Paste or type your input. You can also load the example below.
- Adjust the available options. Results update after you finish typing; for very large inputs, select Run.
- Review the result, then copy it or download it to your device.
How this tool works
CSV-aware splitting handles quoted fields and multiline cells. The two-or-more-spaces mode targets terminal tables and does not interpret quotes. Columns may repeat and reorder; missing cells are empty. Auto-detection compares up to 40 non-empty rows. A 100-row preview accompanies the complete output.
Input and output stay in the current page. Refreshing or closing the page clears them. For very large inputs, use Run to start processing; a task that takes too long is stopped so you can change the input.
Frequently asked questions
How do I keep only the second column?
Enter 2 in Columns. Use New line as the joiner for a simple vertical list.
Can I repeat a column?
Yes. A selection such as 2,2,1 duplicates column two and then appends column one. Out-of-range indexes are rejected.