Text · Made a little simpler

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.

Free to useNo account neededProcessed on your device
Your workspaceProcessed on your device
Column settings

Add this tool to your website

Paste this code into your page to add the tool and a visible ToolMellow credit link.

HTML embed code
Preview embed

Text to Columns: how to use it

  1. Paste delimited rows or open a UTF-8 file. Choose a preset separator or enter a custom string.
  2. Set the header, trim, blank record, and quote options. Check the preview for missing fields or explicitly empty cells.
  3. 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.

Guides