Text to Columns Splitter
Split delimited text into columns and export.
Delimiter:
Frequently Asked Questions
How does auto-detect pick the delimiter? +
It checks the first few lines for common delimiters (tab, comma, pipe, semicolon) and picks whichever appears most consistently across lines. Tab is checked first since it is rarely used inside field values.
How are quoted fields handled? +
Fields wrapped in double quotes are treated as a single value, even if they contain the delimiter character. Escaped quotes (two double quotes in a row) are converted to a single quote in the output.
What happens if rows have different numbers of columns? +
Rows with fewer fields get empty cells added to match the widest row. The tool does not discard data from rows that have extra columns either. Everything is preserved.
Can I rename or reorder columns after splitting? +
Yes. Click any column header to rename it. Use the arrow buttons on each column to move it left or right, or click the X to delete a column entirely. Changes are reflected in all export formats.