Text Transform

A recurring chore when moving data between tools: a spreadsheet column or a pasted list of names needs to become a SQL IN (...) clause, a comma-separated CLI argument, or a JSON array of strings — and later the reverse, turning a delimited blob back into one item per line for a spreadsheet paste.

This tool handles both directions, plus the cleanup that usually comes with it: trimming stray whitespace, dropping blank lines, removing duplicates, and sorting — before joining with any separator, optional quoting, and an optional prefix or suffix per item.

Doing this by hand in a text editor means several passes of find-and-replace and manual dedupe. This tool applies every option live as you type, so you can see the result update and copy it the moment it looks right — entirely in your browser.

1. Pick a direction: Lines → List to join, or List → Lines to split a delimited string.
2. Set the separator — defaults to a comma and space.
3. For Lines → List, optionally wrap each item in quotes and add a prefix or suffix.
4. Toggle trim, remove-empty, dedupe and sort as needed.
5. Copy the result from the output panel.