Excel Column Splitter
Split one Excel column into several — by comma, space or any separator, at fixed positions, or full names into first and last name.
- Files never leave your device
- 100% free
- No sign-up
- No watermark
- Works offline after first load
or drag & drop a workbook or CSV here
How to split a column in Excel
- Select or drop an Excel, ODS or CSV file and choose the sheet with the tabs.
- Pick the column to split and how: by separators (comma, space, semicolon…), full names into title / first / middle / last, fixed positions, line breaks, or letters from numbers. The preview shows the new columns as you go.
- Name the new columns if you like, choose to put them after the column or replace it, and click Split column.
About Excel Column Splitter
Split one column into several, like Excel’s Text to Columns — without Excel. Split by commas, spaces, semicolons or any characters at once, keep quoted text together, split only at the first or last separator, or cut at fixed character positions.
Split full names into title, first, middle and last name, addresses into their parts, cells at line breaks, or codes into letters and numbers. The new columns go after the original or replace it, with headers you choose, and a live preview shows the result. Nothing is uploaded.
Good for
- Splitting full names into first and last name
- Breaking addresses or tag lists into columns
- Separating codes like ABC123 into parts
Tip: Use “Only at the first one” to split “City, State, Country” into the city and the rest.
Frequently asked questions
Is this like Excel’s Text to Columns?
Yes — and a bit more. Split by one or several separators at once, treat repeated separators as one, keep text in quotes together, split only at the first or last separator, or at fixed positions, line breaks, or between letters and numbers.
Can I split full names into first and last name?
Yes. Choose Full names and you get Title, First name, Middle name and Last name columns. “Smith, John” style names are understood too.
How do I split an address or a list?
Choose By separator and tick the comma (or the separator your data uses). Use At most to limit the number of columns — the rest stays together in the last one.
Where do the new columns go?
Right after the column you split, or in its place. The other columns move along, and you can type headers for the new columns.
Are numbers kept as numbers?
Yes. Parts that are plain numbers become numbers; codes with leading zeros stay text, and the rest of the sheet keeps its values.
Are my files uploaded?
No. Everything happens in your browser — your data never leaves your device.