What This Tool Does

This tool splits one column from your CSV into multiple separate columns. Choose a column to split, specify how to split it (delimiter, regex, or fixed width), and get new columns with the separated values. Optionally remove the original column after splitting.

Split Methods

By delimiter: Split on a character like comma, space, hyphen, or pipe. "John Doe" splits to "John" and "Doe" on space.

By regex: Use a regular expression pattern for complex splits. Capture groups become separate columns.

Fixed width: Split at specific character positions. Useful for fixed-format data like "CA90210" splitting to "CA" and "90210".

Preview: See the split results before exporting to verify the output.

Example: Split by Delimiter

Input CSV:

id,full_name,email
1,John Smith,[email protected]
2,Jane Doe,[email protected]

Split "full_name" on space, new columns: first_name, last_name

Output CSV:

id,first_name,last_name,email
1,John,Smith,[email protected]
2,Jane,Doe,[email protected]

Example: Split by Regex

Input CSV:

id,code
1,ABC-123-XYZ
2,DEF-456-UVW

Regex: (\w+)-(\d+)-(\w+), columns: prefix, number, suffix

Output CSV:

id,prefix,number,suffix
1,ABC,123,XYZ
2,DEF,456,UVW

Example: Fixed Width Split

Input CSV:

id,state_zip
1,CA90210
2,NY10001

Split at position 2: state (0-2), zip (2-7)

Output CSV:

id,state,zip
1,CA,90210
2,NY,10001

When to Use This

Name parsing: Split "full_name" into "first_name" and "last_name" for personalized communications.

Address parsing: Split "address" into "street", "city", "state", "zip" components.

Product codes: Split SKU like "CAT-123-RED" into category, item number, and color.

Date parsing: Split "2024-01-15" into year, month, day columns for analysis.

Phone number parsing: Split "(555) 123-4567" into area code, prefix, line number.

Regex Split Tips

Capture groups: Each () in your regex becomes a new column.

Common patterns:

(w+)s+(w+)     - Two words separated by space
(d+)-(d+)       - Two numbers separated by hyphen
(.+)@(.+)         - Email local part and domain
(w+):(d+)       - Key:value pairs

Non-capturing groups: Use (?:...) for groups you don't want as separate columns.

Limitations

Inconsistent data: If some rows don't match your split pattern, they may produce empty columns or errors.

Variable parts: Names with middle names or suffixes won't split cleanly into just first/last.

Large files: Works best with files under 50MB. Very large files may cause slow performance.

Frequently Asked Questions

What if some rows don't have the delimiter?

Those rows will have the full value in the first new column, with remaining columns empty.

Can I split on multiple delimiters?

Use regex mode with a character class like [-_\s] to split on hyphens, underscores, or whitespace.

Can I keep the original column?

Yes. Toggle the "remove original column" option to keep both the original and the new split columns.