Split Column in Excel Files Online
Split a column into multiple columns by delimiter in Excel files directly in your browser. Turn "First Last" into separate first and last name columns — no upload required.
About this tool
Split a single column in a Excel file into multiple columns by a delimiter. Turn "First Last" into separate first-name and last-name columns, or split pipe-delimited codes into individual fields.
Frequently Asked Questions
What delimiters can I use to split a column in a Excel file?
Any single character — comma, space, hyphen, pipe, underscore, or a custom character you enter. The split applies to every row in the column.
What are the output columns named after splitting a column in a Excel file?
The original column name with a numeric suffix: col_1, col_2, and so on. You can rename them afterwards using the Rename Columns tool.
What happens if a value has fewer parts than other rows when splitting a Excel column?
Short values produce null in the extra output columns for that row. No data is lost from other columns.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Detect Outliers in Excel Files Online
Detect statistical outliers in Excel files directly in your browser. Flag or remove rows where numeric values exceed a chosen number of standard deviations from the mean — no upload required.
Validate Email Addresses in Excel Files Online
Validate email addresses in Excel files directly in your browser. Add a boolean column flagging valid and invalid emails, or filter to show only invalid rows — no upload required.
Add Moving Average to Excel Files Online
Add a moving average, rolling sum, rolling min, or rolling max column to Excel files directly in your browser. Choose window size, order-by column, and optional partitioning — no upload required.
Search Text in Excel Files Online
Search for text across all string columns in Excel files directly in your browser. Filter rows to only those containing your search term and download the results — no upload required.
Get Top N Rows from Excel Files Online
Extract the top N rows per group from Excel files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.