Text-to-Columns Parser
Split delimited or fixed-width text into clean columns and re-emit as CSV, TSV or JSON.
About this tool
The Text-to-Columns Parser turns messy delimited or fixed-width text into a clean, normalised table. It auto-detects the most likely delimiter (tab, comma, pipe or semicolon), handles quoted CSV fields, and supports fixed-width slicing by character count. Output it as RFC4180 CSV, TSV, or a JSON array of objects using your header row as keys. Handy for cleaning up pasted spreadsheet data, log lines, or report exports.
Frequently asked questions
How do I split text into columns?
Paste your rows in the input, leave mode=delimited and delimiter=auto to auto-detect the separator, then pick an output of csv, tsv or json.
What delimiters can it detect?
Auto-detect chooses between tab, comma, pipe and semicolon by frequency, and falls back to whitespace when none is present. You can also force one with delimiter=comma|tab|pipe|semicolon|whitespace.
Can it parse fixed-width records?
Yes. Set mode=fixed and widths=10,20,15 to slice each line at those character widths; any trailing characters become an extra column.
How are columns named in JSON output?
With header=yes the first row supplies the keys; otherwise columns are named col1, col2, col3 and so on.