What is the List Delimiter & Formatter?
It is a small text utility for turning a blob of values — often one column copied from Excel or Google Sheets — into another delimiter layout. You choose how to split the input into records, optionally deduplicate while keeping first-seen order, optionally wrap each value in SQL-friendly single or double quotes, pick what goes between values (comma, semicolon, pipe, space, or newline), and optionally wrap every record or every N records in open/close snippets such as HTML tags. The output panel updates live as you type.
Explode (split) modes
- New lines: split on CR/LF boundaries.
- Spaces / whitespace: split on any run of whitespace (good for pasted inline lists).
- Commas or semicolons: simple character splits — not a full CSV parser with quoted fields containing delimiters.
Quotes, tags, intervals, and tidy
Quote mode adds escaping for backslashes and nested quotes inside each token before wrapping. Optional record tags wrap each quoted token when both open and close fields are non-empty. Interval N groups records: when N is greater than zero, records are chunked; each chunk is joined with your output delimiter, chunks are separated by newlines, and if interval open/close tags are set they wrap each chunk’s inner string. Tidy removes every newline from the final assembled text so you get one long line — useful for compact IN lists.
Privacy
All splitting and joining happens in your browser. Nothing is uploaded to Dynamic Duniya servers.