Delimiter Converter
Convert lists between newline, comma, tab, pipe, semicolon, space, and custom delimiters with trimming, quotes, and deduplication.
Convert list separators without rewriting every value
Delimiter conversion is useful when moving lists among spreadsheets, text editors, command lines, databases, and programming languages. Common separators include new lines, commas, tabs, semicolons, pipes, and spaces.
Automatic detection is convenient for ordinary lists, but an explicit delimiter is safer when punctuation or whitespace is part of the data itself.
Delimiter Converter FAQ
Can I convert new lines to commas?
Yes. Choose New line as the input delimiter and Comma or Comma plus space as the output delimiter.
Does this parse quoted CSV fields?
This page performs literal list splitting. Use the CSV and JSON Converter when quoted delimiters, escaped quotes, or multiline fields are present.
Can values be quoted automatically?
Yes. Choose single or double quotes, and ArrayText escapes matching quote characters and backslashes.
Continue working with your data
Compare two lists and find values only in A, only in B, shared values, union, or symmetric difference with configurable matching rules.
Remove Duplicate LinesRemove duplicate lines while preserving order, keep first or last occurrence, and control case, whitespace, blank lines, and Unicode normalization.
Sort List OnlineSort text lines alphabetically, naturally, numerically, by length, or in reverse with trimming, blank-line, and duplicate controls.
Split List Into ChunksSplit a list by items per batch, target batch count, or maximum characters and copy or download each generated chunk.