Text to columns
Split lines into columns by delimiter, width or pattern.
One line is one record. Empty lines are skipped.
Preview: 3 rows, 3 columns
| A | B | C |
|---|---|---|
| London | Camden | 8900000 |
| Leeds | Centre | 790000 |
| Bath | Widcombe | 94000 |
- Runs right in your browser
- Free, no sign-up
More about Text to columns
Text to columns without Excel
Paste the rows and choose how they should be split. The preview shows the result immediately, so you can tell whether the separator fits. Download the finished table as XLSX or CSV.
- By separator is the common case: comma, semicolon, tab or a character of your own. Text in quotes stays together, so “New York, NY” does not fall into two cells.
- By fixed width suits printouts from older systems, where columns are held by character counts. You give the widths and the rest of the line goes to the last column.
- By regular expression copes with irregular spacing.
\s+splits wherever there is one space or more.
Frequently asked questions
Are dates and numbers recognised?
Yes, when downloading to XLSX. A cell with 1,300 becomes a number and 8/4/2026 a date, so you can calculate with them straight away.
What if a row has a different number of columns?
The table widens to match the longest row and the missing cells stay empty. Nothing is lost.
Can I keep working on the result?
Yes, open the downloaded XLSX in our spreadsheet editor or in Excel.
Is the text sent to a server?
No, the splitting runs in your browser.