Split Column
Split one column into two columns by a delimiter
CSV Input
Try a sample:
Drop a CSV file here or
Only the first file is used if multiple are dropped.
The request is made directly from your browser. No proxy is used.
Options
Provide CSV input above to select a column.
CSV Output
Select a column and delimiter to see split output...
More Options
CSV Format
Input
Output
How to Use This Tool
This tool splits a column into two new columns based on a delimiter. Choose the column, enter the delimiter character or string, and name the two new columns. The split happens on the first occurrence of the delimiter only. Whitespace is trimmed from both values by default, so you can split on a comma without worrying about extra spaces.
- Provide your CSV — Paste CSV text into the input area, drop a CSV file onto the File tab, or enter a URL on the URL tab.
- Select a column — Choose the column you want to split from the dropdown.
- Enter a delimiter — Type the character or string to split on (e.g., a comma, dash, or pipe).
- Name the new columns — Optionally change the default names for the two new columns.
- Get your output — Copy the result to your clipboard or save it as a .csv file.
FAQ
5 questionsDoes this tool upload my data?
No. It runs entirely in your browser using JavaScript. Your CSV data is never sent to a server.
Does it split on every occurrence of the delimiter?
No. It splits on the first occurrence only. Everything before the first delimiter goes to the first new column, and everything after goes to the second.
What happens if the delimiter isn't found in a cell?
The entire value goes into the first new column, and the second new column gets an empty value.
Is the original column removed?
No. The original column is preserved. The two new columns are added at the end of the output.
What about extra spaces after the delimiter?
By default, whitespace is trimmed from both split values. So splitting 'Portland, OR' on a comma gives 'Portland' and 'OR', not 'Portland' and ' OR'. You can turn this off in the More Options panel.