How to use
- Drop an
.xlsx,.csvor.tsvfile, or paste cells copied from Excel. This page opens with the Split · merge columns step already added. - At the top, choose Split one column or Merge columns.
- 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.
- 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 |
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 cbecomesa,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
07are 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,2fit 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-5678into 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.
Related tools
- Stack several steps: Excel & CSV Workbench
- Address splitting: Address Cleaner & Splitter
- Replace text: Find & Replace in Excel
- Blank rows and spaces: Remove Blank Rows & Columns
- Line-based list conversion: List Converter
- Practice regexes: Regex Tester
Your file is processed only in your browser and is never sent to a server.