No Login Data Private Local Save

Text to Columns - Online Split by Delimiter

Data Tool Text Tool columns data split text
50
0
0
0

Text to Columns – Split by Delimiter Online

When unchecked, consecutive delimiters do not create empty columns.
Preview
Click "Convert to Columns" to see results.

Frequently Asked Questions

A text to columns tool splits a block of text into structured columns based on a character called a delimiter. It’s commonly used to convert CSV, TSV, or other delimiter‑separated data into a readable table, similar to Excel’s “Text to Columns” feature.

We support comma (,), space, tab (\t), and a custom delimiter you can specify yourself – for example a pipe (|), semicolon (;), colon (:), or any other character(s).

Currently the tool processes one delimiter at a time. If your data uses several delimiters, we recommend first replacing them with a single consistent delimiter (e.g., using a simple text find‑and‑replace) before pasting the text here.

By default, empty cells resulting from consecutive delimiters are kept, showing an empty value in the table. If you uncheck "Keep empty cells," the tool will skip those empty values – so two commas in a row (,,) will not create an extra column.

Yes! After conversion, click the "Download CSV" button to export the parsed table as a standard CSV file (comma‑separated values). The file can be opened directly in Excel, Google Sheets, or any text editor.

Absolutely. All processing is done locally in your browser. Your text never leaves your device and is not uploaded to any server.
🔧 Related Tools