Split Column in CSV Files Online
Split a column into multiple columns by delimiter in CSV 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 CSV 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 CSV 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 CSV 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 CSV 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
Filter by Date Range CSV Files Online
Filter CSV files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.
Compute Correlation Matrix for CSV Files Online
Compute a Pearson correlation matrix for numeric columns in CSV files directly in your browser. Instantly spot which variables move together — colour-coded heatmap, no upload required.
Find Fuzzy Duplicates in CSV Files Online
Find near-duplicate rows in CSV files using Levenshtein edit distance or Jaro-Winkler similarity — all in your browser. Set your own threshold and download the matched pairs as CSV — no upload required.
Hash & Anonymise Columns in CSV Files Online
Anonymise or pseudonymise columns in CSV files by replacing values with MD5, SHA-256, or DuckDB hashes — directly in your browser. Useful for GDPR compliance and sharing data without exposing PII — no upload required.
Group Concatenate CSV Files Online
Concatenate text values within each group in CSV files directly in your browser. Group rows by a column and join the values of another column into a single delimited string — no upload required.