Split Column in TSV Files Online
Split a column into multiple columns by delimiter in TSV files directly in your browser. Turn "First Last" into separate first and last name columns — no upload required.
How to split Column in TSV files
- Drop your file onto the upload area. The first column is selected as the column to split, and the first 200 rows are shown.
- Pick the column to split and type the delimiter. The default is a single space. Any text works, including multi-character delimiters such as " | ".
- Set the number of parts, from 2 to 10. Each part gets a name box, pre-filled as column_1, column_2 and so on, which you can rename.
- Tick Remove original column if you only want the parts, then click Split Column.
- Check the preview and download the file. The new columns sit directly after the source column, or in its place if you removed it.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A warehouse stock sheet packs category, colour and size into one SKU code. The buying team wants to filter by colour and size separately.
Input (TSV)
sku stock warehouse
SHOE-RED-42 14 WLG
SHOE-BLK-39 3 AKL
HAT-BLUE 22 WLG
SOCK-WHT-M-3PK 40 CHCSettings
- Column to split: sku
- Delimiter: -
- Number of parts: 3, named category, color, size
- Remove original column: ticked
Result
| category | color | size | stock | warehouse |
|---|---|---|---|---|
| SHOE | RED | 42 | 14 | WLG |
| SHOE | BLK | 39 | 3 | AKL |
| HAT | BLUE | 22 | WLG | |
| SOCK | WHT | M | 40 | CHC |
Each part is taken by position. HAT-BLUE has only two parts, so its size is an empty string. SOCK-WHT-M-3PK has four, and anything after the third part is dropped, so 3PK is lost. Raise the number of parts to keep it. The size column is text even where it holds numbers like 42.
Frequently Asked Questions
What happens when a value has more parts than I asked for?
The extra parts are dropped. Splitting "Mary Ann Lee" into 2 parts on a space gives "Mary" and "Ann", and "Lee" is lost. Set the number of parts to the largest count in your data.
What happens when a value has fewer parts?
The missing parts are empty strings, not NULL. A NULL in the source column gives NULL in every part.
Is the delimiter a regular expression?
No. It is matched as literal text and is case-sensitive. Use Regex Extract if you need a pattern.
Related Tools
Trim Whitespace in CSV Files Online
Trim leading and trailing whitespace from all text columns in CSV files, directly in your browser. No upload required.
Cast Column Types in CSV Files Online
Change column data types in CSV files directly in your browser. Cast text to numbers, dates to timestamps, or any supported type conversion — no upload required.
Rename Columns in CSV Files Online
Rename columns in CSV files instantly in your browser. No upload, no server — your data stays on your device.
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.
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.
Split Column in Parquet Files Online
Split a column into multiple columns by delimiter in Parquet files directly in your browser. Turn "First Last" into separate first and last name columns — no upload required.
Split Column in JSON Files Online
Split a column into multiple columns by delimiter in JSON files directly in your browser. Turn "First Last" into separate first and last name columns — no upload required.
TSV Viewer Online
View and inspect TSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.