Split Column

Split one column of a table into several. Use a separator, regular expression, fixed positions or camelCase boundaries, or put the parts on new rows instead.

  • Free, no sign-up
  • Runs in your browser
  • Your data stays private

How to use the Split Column

  1. Paste your table and choose the column to split.
  2. Pick the split method and type the separator or pattern.
  3. Copy the new table, or put the parts on new rows.

Why use this Split Column

  • Four methodsSeparator, regular expression, fixed character positions or camelCase boundaries.
  • Rows instead of columnsTurn a "tags" cell into one row per tag while repeating other columns.
  • Part limitSplit a full name into first and the rest by limiting to two parts.
  • PreviewReview the result in a table before you copy.

Frequently asked questions

How do I split a full name into first and last name?

Choose the name column, split by a space and set the part limit to 2.

Can I split one cell into multiple rows?

Yes. Tick "Put parts on new rows" and the other columns are repeated for each part.

Can I split by position?

Yes. Choose fixed positions and enter, for example, 3,6,10.

Related tools

More Spreadsheet & CSV tools

User Reviews

–
No ratings yet
Write a review
Your rating *

Your email is never published. Reviews are moderated, and links aren't allowed.

What users are saying

No reviews yet

Be the first to share your experience with this tool — your feedback helps others.