CSV Merge / Split Columns

CSV Merge / Split Columns

Local Processing

Combine several columns into one or split a column by a delimiter.

How It Works & Processing Standards

Combine several columns into one or split a column by a delimiter.

Tool processing runs in your browser. If you create a calculator or conversion share link, its values are included in the URL. See the privacy policy for account, analytics and advertising data.

Current Limits

  • Desktop max file size: 50MB
  • Mobile max file size: 20MB

Choose merge or split under "Task". Original columns stay and results are appended as new columns, so you can check before deleting anything.

What You Can Do

Merge
Joins two columns with a connector (space, -, none…) into a new column.
Split
Splits one column by a separator into name_1, name_2… columns.

How to Use CSV Merge / Split Columns

  1. 1
    Choose a taskMerge or split.
  2. 2
    Set columns and charactersColumns and the connector or separator.
  3. 3
    Get the resultCopy the CSV or download Excel.

Examples

Family + given name
Input: 성,이름 김,민수 이,지영 / no connector, new column 성명
Result: 성,이름,성명 김,민수,김민수 이,지영,이지영
Split a full name
Input: 성명,나이 김 민수,30 / by space
Result: 성명,나이,성명_1,성명_2 김 민수,30,김,민수

Common Use Cases

  • Combining first and last names into one cell
  • Splitting "city district street" addresses into cells

Frequently Asked Questions (FAQ)

Does the original column disappear?

No. Results are added as new columns and the originals remain. Delete them with the CSV column editor if needed.

Have feedback or ideas for this tool? Suggest & Inquire →