1. Home
  2. Spreadsheets & Data
  3. Split Column

Split Column

Split one column into several by a delimiter or a fixed character count.

For every format and option in one place, use Excel & CSV Workbench →

Runs in your browser · No upload
Pick the column and how to split it (delimiter, fixed width or regex). Choose "Merge columns" at the top to join columns instead.

Operations

Split one column by delimiter, fixed width or regex, or merge several columns into one.
Files are processed in your browser and never sent to a server.

How to use

  1. Drop an .xlsx, .csv or .tsv file, or paste cells copied from Excel. This page opens with the Split · merge columns step already added.
  2. At the top, choose Split one column or Merge columns.
  3. For splitting, pick the column to split and how (delimiter, fixed width or regex groups). For merging, pick the columns to merge (joined in the order you tick them) and the text to put between them.
  4. Check the new columns in the preview and the step report (Split 2 rows into 3 columns), then download.

Ways to split

Way Description
Delimiter Cuts at the comma, space, tab, semicolon, / or - buttons, or any text you type (several characters are fine)
Fixed width Type character counts such as 4,2,2 and the value is cut to those lengths. Leftover characters become one extra column at the end
Regex groups One column per ( ) group. With no groups, the whole match becomes one column; rows that do not match are left blank

Computed results

The source table has columns 이름 / 주소 / 날짜 with two rows: 홍길동 / 서울, 강남구, 역삼동 / 20261007 and 김영희 / 부산, 해운대구 / 20260101.

Split 주소 by the delimiter , (the original column is replaced by the new ones)

이름 주소_1 주소_2 주소_3 날짜
홍길동 서울 강남구 역삼동 20261007
김영희 부산 해운대구 (blank) 20260101

The number of columns follows the row that splits into the most parts, and shorter rows are padded with blanks. New columns are named original_1, original_2… unless you type names.

Max columns 2, names 시도, 나머지: the rest goes into the last column.

이름 시도 나머지 날짜
홍길동 서울 강남구, 역삼동 20261007
김영희 부산 해운대구 20260101

Split 날짜 by fixed width 4,2,2, names 연, 월, 일: the zero in 01 and 07 survives because the parts are text.

이름 주소 연 월 일
홍길동 서울, 강남구, 역삼동 2026 10 07
김영희 부산, 해운대구 2026 01 01

Split file names with the regex ^(.+)_(\d{4})-(\d{2})\.(\w+)$, names 이름, 연, 월, 확장자

파일 → 이름 연 월 확장자
보고서_2026-10.xlsx 보고서 2026 10 xlsx
견적서_2025-03.pdf 견적서 2025 03 pdf

Split options

  • Keep the original column: when on, the new columns are added to the right of the original, which stays. When off, the new columns take its place.
  • Trim spaces around each part (on by default): cutting 서울, 강남구 at the comma would leave 강남구 with a leading space; this option removes it. Turn it off if the spaces matter.
  • Space as the delimiter: with the Space button (or one space), runs of spaces count as one, so a b c becomes a, b, c, and spaces at the ends are ignored.
  • Blank cells are not split and their new cells stay blank. Parts are always text, so zeros such as in 07 are kept.
  • Splitting by delimiter produces at most 50 columns; anything beyond that is folded into the last one.

Merging columns

The source table has columns 성 / 이름 / 메모 with the rows 김 / 철수 / x and 이 / (blank) / y.

  • Merging 성 and 이름 with no separator, the new name 성명, and deleting the originals gives 김철수 and 이 (columns 성명, 메모).
  • With a space separator and skipping blanks turned off, row 2 ends in a trailing space (이␠). Leave it on (the default) to get a clean 이.
  • The new column goes right after the right-most picked column. Columns are joined in the order you tick them, so picking 이름 then 성 gives 철수 김.
  • You can keep or delete the original columns after merging. You need at least two columns to merge.

Common jobs

  • Splitting a name into family and given name: character counts 1,2 fit three-character names, but two-character family names such as 남궁, two-character names and foreign names come out wrong. Check the result by eye.
  • 010-1234-5678 into three cells: delimiter -.
  • Address into region and district: Address Cleaner & Splitter also handles official names and ZIP codes.
  • A cell holding a comma-separated tag list: delimiter ,, and set a max column count so you do not get too many columns.

Your file is processed only in your browser and is never sent to a server.

Can't find the tool you need?

Tell us what you want to do. We build the most requested tools first.