Text to Columns
Split text by a built-in or custom separator. Preview quoted fields and ragged rows, then export CSV, TSV, JSON or Markdown.
Split a Warehouse Log into Columns
Text to Columns: how to use it
- Paste delimited rows or open a UTF-8 file. Choose a preset separator or enter a custom string.
- Set the header, trim, blank record, and quote options. Check the preview for missing fields or explicitly empty cells.
- Choose the output format, inspect the export, and copy or download it.
Limits and notes
Runs locally. Use up to 200,000 UTF-16 code units, 5,000 records, 100 columns, and 100,000 rectangular cells. The table previews 25 rows. CSV and TSV pad missing cells. JSON distinguishes missing nulls from empty strings and retains cell values as strings.
How your privacy works →Text to Columns: common questions
Does a separator inside quotes split the field?
With Respect quoted fields enabled, the separator can appear inside a field wrapped with double quotes. Two adjacent quotes inside that field become one literal quote.
What happens when the header repeats a name?
CSV and TSV preserve the original header. JSON adds suffixes to repeated keys to retain every field, and uses generated names for blank or missing headers.
Can I split a log on two colons?
Yes. Choose Custom and enter ::. Enable Trim cell whitespace if the fields include spaces surrounding that separator.