1
2
3
Welcome to Excel Text to Columns Tool
This tool helps you split text from one column into multiple columns using delimiters or fixed widths.
Getting Started
- Upload your Excel file (.xlsx or .xls)
- Select the column(s) to split
- Choose splitting method (delimiter or fixed width)
- Preview and download your processed file
To begin, please upload your Excel file using the option in the sidebar.
Interactive Guide
Delimiter-based splitting divides text based on a specific character:
- Comma: "John,Doe,30" becomes "John" | "Doe" | "30"
- Space: "John Doe 30" becomes "John" | "Doe" | "30"
- Tab: "John[tab]Doe[tab]30" becomes "John" | "Doe" | "30"
Choose this method when your data is uniformly separated by characters.
Fixed width splitting divides text based on character positions:
- Example: For "JohnDoe30" with positions 4 and 7: "John" | "Doe" | "30"
Choose this method when your data follows a consistent width pattern.
Additional options to improve your splitting results:
- Treat consecutive delimiters as one: Multiple spaces will be treated as a single delimiter
- Trim spaces: Remove leading/trailing spaces from each resulting column
- Header row: Indicate if your file has a header row to preserve column names
Preview Original Data
Select column(s) to split from the sidebar and configure split settings.