Home โ€บ Blog โ€บ Excel & CSV
๐Ÿ“Š Excel & CSV

Text to Columns Online: Split Text by Delimiter or Fixed Width

By Bilawal Hussain ยท 4 November 2026 ยท 2 min read
Text to Columns Online: Split Text by Delimiter or Fixed Width

Split lines of text into columns by comma, tab, pipe or a fixed width, just like Excel's Text to Columns, and copy the result straight into a spreadsheet.

Open the free Text to Columns โ†’

What is the Text to Columns?

Split lines of text into columns by a delimiter or fixed width, like Excel's Text to Columns. It's completely free, needs no sign-up and works on any phone or computer.

Screenshot of the Text to Columns on ReadyToUse
The Text to Columns, as it looks on ReadyToUse.

Why it's helpful

Who it's for

Office workers, analysts and anyone cleaning exported data.

How to use it

  1. Paste text, choose a delimiter (type \t for tab) or fixed widths like 10,8,12.
  2. Copy as tab-separated and paste straight into Excel.
๐Ÿ’ก Pro tip: Check for commas inside values (like addresses) before splitting by comma.

๐Ÿ’ป Open source: this tool is free and open source (MIT License). View the code on GitHub, download it and run it offline.

The bigger picture: Excel & CSV

Spreadsheets still run most offices. Cleaning data, converting formats and understanding formulas are daily tasks that eat hours; the right tool turns them into seconds.

What's changing: Excel and Google Sheets keep adding powerful functions like XLOOKUP, FILTER and LET, plus AI helpers. Knowing the fundamentals makes those features far more useful.

Frequently asked questions

Why tab separated?

Excel splits tab-separated text into columns automatically when you paste.

Ready to try it?
Use the Text to Columns free โ†’
No sign-up ยท Runs in your browser

Related guides

Clean a Messy CSV in Seconds: Remove Duplicates, Blank Rows and Extra Spaces๐Ÿ“Š Excel & CSV
Convert CSV or Excel Data to JSON Instantly๐Ÿ“Š Excel & CSV
Excel Formula Generator: Get the Right Formula Without Memorising Syntax๐Ÿ“Š Excel & CSV
Convert Date Formats in Bulk: DD/MM/YYYY, MM/DD/YYYY, ISO and Excel Serials๐Ÿ“Š Excel & CSV
BH
Bilawal Hussain
Full-stack developer in Dubai and creator of ReadyToUse: free tools that just work. Connect on LinkedIn