Text to Columns
Split plain text into clean columns using commas, tabs, pipes, spaces, semicolons, or custom delimiters.
Split text into columns
Result
About this tool
Text to Columns splits plain text into structured columns using delimiters such as commas, tabs, pipes, semicolons, spaces, or custom separators. It is useful when converting copied lists, exports, log lines, pasted tables, and messy text rows into cleaner column-based output.
How to use Text to Columns
- Paste your text into the input area.
- Choose the delimiter type or enter a custom separator.
- Choose the output style you want, such as pipe preview, tab-separated output, comma-separated output, or numbered columns.
- Choose whether to trim cells and keep empty rows.
- Click Split into Columns and review the result before copying or downloading.
Why use Text to Columns?
Text to Columns is useful when copied text is packed into a single line format and needs to be separated into readable fields. It helps with spreadsheets, imports, pasted reports, CRM exports, logs, and structured text cleanup without manual editing.
Frequently Asked Questions
What does Text to Columns do?
It splits each row of text into separate columns based on the delimiter you choose.
Can it work with tabs and commas?
Yes. It supports tabs, commas, pipes, semicolons, spaces, and custom delimiters.
Can I keep empty cells?
Yes. You can choose whether to keep empty rows and preserve empty cells in the output.
Is this only for CSV files?
No. It works with many kinds of delimited plain text, not just CSV.