Delimiter Converter Online
Turn newline-separated lines into a comma, semicolon, pipe, tab, or custom delimited list — and split a list back into lines — right in your browser.
The Delimiter Converter runs entirely in your browser. The lines and lists you paste are converted on your device and never uploaded to ArrayKit.
Open Remove Duplicate Lines
About Delimiter Converter
The Delimiter Converter joins newline-separated lines into a single delimited list and splits a delimited list back into one item per line. Pick a comma, semicolon, pipe, tab, space, or type your own custom delimiter. In join mode you can quote each item with single or double quotes, wrap the whole list in [ ] or ( ), trim surrounding spaces, drop blank lines, and remove duplicates — handy for building a SQL IN-list, a config array, a spreadsheet paste, or a tag string. In split mode, paste a list separated by any delimiter and get clean lines back, ready to sort or edit. It is built for developers, analysts, and anyone reshaping quick lists. Everything runs on your device — the text you paste never leaves the browser.
Features
- Join lines into a comma, semicolon, pipe, tab, space, or custom delimited list
- Split a delimited list back into one item per line
- Quote each item with single or double quotes, escaping embedded quotes
- Wrap the joined list in square [ ] or round ( ) brackets
- Trim surrounding whitespace from every item
- Drop blank lines and remove duplicate items in one pass
- Round-trips cleanly: lines to a list and back to the same lines
- Works entirely in your browser with nothing uploaded
How to use the Delimiter Converter
- Keep the Lines → list tab selected and paste one item per line
- Pick a delimiter, or choose Custom and type your own
- Toggle quoting, brackets, trim, drop blanks, or dedupe as needed
- Copy the delimited list, or switch to List → lines to split one back apart
Example
Input
red
green
blue
Output
('red', 'green', 'blue')
Comma delimiter, single quotes, and round brackets build a SQL IN-list.
Common errors & troubleshooting
- The list joined with 'a,b,c' but you wanted 'a, b, c' with spaces. — Choose the Comma preset (which uses ', ' with a trailing space) or type ', ' as a custom delimiter — the delimiter is inserted verbatim between items.
- Splitting a list left leading spaces on every item. — Split mode trims each item, so 'a, b, c' split on a comma gives clean 'a', 'b', 'c'. If items still look padded, check that the delimiter you entered matches the one in the text.
- Quotes inside your items broke the output. — Embedded quotes are doubled automatically — o'clock becomes 'o''clock' with single quotes — matching how CSV and SQL escape a quote inside a quoted value.
- The tab or space delimiter looks the same as a comma in the box. — Tab and space are whitespace, so they are hard to see. Use Copy to grab the exact output, or switch to a visible delimiter like a pipe while you check the result.
Frequently asked questions
- How do I turn a list of lines into a comma-separated string?
- Paste your lines in the Lines → list tab, keep the Comma delimiter selected, and copy the result. Each line becomes one item joined by ', ', with blank lines dropped and spaces trimmed by default.
- Can I quote every item for a SQL IN-list?
- Yes. Set Quote each item to single quotes and Wrap list to round brackets. A list of colours becomes ('red', 'green', 'blue'), ready to drop into a WHERE column IN (...) clause.
- What delimiters can I use?
- Comma, semicolon, pipe, tab, and space are one-click presets. Choose Custom to type any string — a bullet, ' - ', ' / ', or a multi-character separator — and it is inserted between items exactly as typed.
- Does splitting a list back into lines undo the join?
- For most lists, yes. Join a set of lines with a delimiter, then split on the same delimiter to get the original lines back. Split trims each item, so a ', ' list also splits cleanly on a bare comma.
- What happens to duplicate or blank lines?
- In join mode you can turn on Remove duplicates to keep only the first of each item, and Drop blank lines to skip empty rows. Both run before the items are quoted and joined.
- How are embedded quotes handled?
- When you quote items, any quote character already inside an item is doubled, so "say ""hi""" stays valid. This matches the escaping used by CSV files and SQL string literals.
Related tools
- Sort Text Lines — Sort lines alphabetically, numerically, by length or randomly, with reverse, case and dedupe options.
- Remove Duplicate Lines — Remove duplicate lines from a list, with case, trim, keep-first-or-last and sort options.
- CSV to JSON — Convert CSV or TSV to JSON with type inference and nested keys, in your browser.
- Remove Line Breaks — Remove or replace line breaks and join paragraphs, with options to keep blank lines.
- Find and Replace Text — Find and replace text with plain or regex search, case sensitivity, whole-word and global options.
- Case Converter — Convert text between camelCase, snake_case, kebab-case, PascalCase and more.
All ArrayKit tools