PapiralPapiralPixelForgePixelForgeTabularTabular
TabularTabular
HomeCSV ToolsSplit Column

Split a CSV Column into Multiple Columns

Split one column into multiple columns by a delimiter. Separate full names, addresses, or compound values into distinct fields.

What this tool does

Splitting a column is one of the most frequent data cleaning operations — turning 'Alice Smith' into separate First Name and Last Name fields, splitting 'City, State' into two columns, or breaking apart delimited tags. Tabular handles it in seconds: pick the column, define the delimiter, name the resulting parts, and download clean data.

Problems it solves

  • Splitting a Full Name column into First Name and Last Name
  • Breaking a combined City, State field into separate columns
  • Extracting domain from an email address column
  • Separating a date-time field into date and time columns
  • Splitting product codes like 'SKU-COLOR-SIZE' into parts

Example

Full Name split on space into First Name and Last Name.

Before

Full NamePlan
Alice SmithPro
Bob JonesFree

After

First NameLast NamePlan
AliceSmithPro
BobJonesFree

Frequently asked questions

What delimiter can I split on?

Any string — a single character like space, comma, or dash, or a multi-character string like ' - '.

What happens if a cell has fewer parts than the defined columns?

The extra column cells are left empty. For example, if you split on space and a cell is 'Alice' with no space, Part 2 will be blank.

Can I keep the original column as well?

Yes. Uncheck 'Remove original column' to retain the source column alongside the new split columns.

Is this available on the free plan?

Yes. Split Column is a free tool available to all users.

Related tools

Merge Columns

Combine two or more columns into a single column with a separator. Great for building full names, addresses, or IDs.

Open tool

Rename Columns

Pro

Rename any column header in your CSV or XLSX file. Map old names to new ones before importing to another system.

Open tool

Trim Whitespace

Strip leading and trailing spaces from every cell in your CSV or spreadsheet with one click.

Open tool