Tool 24 / 25

Delimiter Splitter & Joiner

Split CSV-style or delimited text into lines, or join lines back with a custom separator.

About this tool

Converting between a delimited string (like comma-separated values) and a plain line-by-line list is a frequent small task when moving data between a spreadsheet, a script, and a text field. This tool does both directions.

How to use it

  1. Paste your text — either a delimited string or a line-by-line list.
  2. Set the delimiter character (comma is the default).
  3. Click split to break it into lines, or join to combine lines back using the delimiter.

Tips

  • Splitting trims extra whitespace around each resulting item automatically.
  • Any single character or short string can be used as a delimiter, not just commas — try a pipe (|) or semicolon.
  • Joining skips empty lines, so blank rows in your list won't leave stray delimiters in the output.

FAQ

Can I use a multi-character delimiter, like '::'?

Yes, the delimiter field accepts any string, not just a single character.

Related tools