Split & Join Text
Local ProcessingSplit by a delimiter, join lines, switch between comma and line lists, and merge or zip two lists.
How It Works & Processing Standards
Split by a delimiter, join lines, switch between comma and line lists, and merge or zip two lists.
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
- Maximum input length: 2,000,000 characters
Six ways to reshape a list — for pasting into a spreadsheet or putting a comma list into code.
What You Can Do
- Split and join
- Split text into lines by any separator, or join lines with one.
- Comma list ↔ lines
- "a, b, c" to one item per line, or back.
- Concatenate two lists
- Appends list B after list A, optionally removing duplicates.
- Zip two lists
- Joins the nth item of A and B with a separator on one line.
How to Use Split & Join Text
- 1Choose a taskPick the conversion you need.
- 2Enter lists and separatorTwo-list tasks take list A and list B separately.
- 3CopyCopy the result.
Examples
Comma list to lines
Input: 서울,부산,대구
Result: 서울 / 부산 / 대구
Lines to a comma list
Input: 사과 / 바나나 / 포도
Result: 사과, 바나나, 포도
Zip names with teams
Input: A: 김철수, 이영희 / B: 영업팀, 개발팀 / separator ": "
Result: 김철수: 영업팀 / 이영희: 개발팀
Common Use Cases
- Turning a spreadsheet column into a comma list for code or SQL
- Combining two columns line by line
- Tidying a tag list one per line
Frequently Asked Questions (FAQ)
Can the separator be a newline or tab?
The separator is used exactly as typed (\t is the two characters "\t"). To split or join by lines, use the comma list ↔ lines tasks.
What if the lists differ in length when zipping?
Once the shorter list ends, remaining items are joined with an empty value (for example "b-").