Split Text into Columns Online

Split each line by a delimiter — a fast alternative to Excel Text to Columns.

100% private. Everything runs in your browser. Your data never leaves your device.

Split Text

What does this tool do?

This tool splits each line of text into columns using a delimiter you choose (comma, semicolon, tab, space, or a custom character). It is a quick online version of Excel's Text to Columns, and it runs entirely in your browser.

How to use Split Text (Text to Columns) - Free Online Tool

  1. Paste your text, one record per line, or click "Try with sample data".
  2. Choose the delimiter that separates the fields.
  3. Click Split.
  4. View the resulting columns and copy or download them as Excel/CSV.

Example

Splitting comma-separated names:

Before

Line
Ali,Sales,Delhi
Sara,HR,Mumbai

After

Col 1 Col 2 Col 3
Ali Sales Delhi
Sara HR Mumbai

Each comma-separated value becomes its own column.

Excel formula alternative

Prefer a formula? You can achieve a similar result with TEXTSPLIT:

=TEXTSPLIT(A2, ",")

Excel 365's TEXTSPLIT splits one cell. This tool splits your whole list at once and works without 365.

When should I use this tool?

Separating full names into parts
Breaking CSV lines into columns
Splitting address or tag fields
Parsing log or export data
Turning delimited text into a table
Preparing data for a spreadsheet import

Frequently Asked Questions

Comma, semicolon, tab, space, and any custom character you type.

No. Splitting happens in your browser; nothing is sent to a server.

Yes. Export the split columns as an Excel file.

Each line is split independently, so rows can have different numbers of columns.

Related tools

Trim, Clean & Convert Case
Extract Numbers from Text
Extract Email Addresses
Change Text Case
Excel ↔ CSV Converter

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator