Loading…
Loading…
Split delimited text into one item per line, or join lines into a single comma-, tab-, or custom-separated line. Optionally quote items for SQL, JSON, or CSV.
Also covers: Text to list · List to text · Text splitter · Text joiner
The result appears here as you type.
A comma-separated line to split, or a list of lines to join.
Split turns "a, b, c" into one item per line. Join turns lines into one line with the delimiter you choose: comma, semicolon, pipe, tab, space, or anything custom.
Wrap items in 'single' quotes for a SQL IN (...) list, or "double" quotes for JSON and CSV. Quotes inside values are escaped by doubling.
Paste the values one per line, choose Join, Comma + space, and 'single' quotes. You get 'a', 'b', 'c', ready to wrap in IN ( … ). A value like O'Brien becomes 'O''Brien', which is correctly escaped for SQL.
No. It splits on every delimiter. For real CSV with quoted fields, use the Text ↔ CSV tool, which parses quoting correctly.
No. Everything runs in your browser, and nothing you paste is sent to a server or stored.
Text & code
Compare two texts or code files side by side, with changed words highlighted. Ignore whitespace or case, and export a unified .diff patch that git apply accepts.
Count
Count words, characters, sentences, paragraphs, and lines as you type, with reading and speaking time. Check text against X, SEO title, and meta description limits.
Case
Convert text to UPPERCASE, lowercase, Title Case, Sentence case, camelCase, PascalCase, snake_case, kebab-case, and more, line by line.
Cleanup
Clean up messy text: remove extra spaces, blank lines, invisible characters, and HTML tags, straighten quotes, and rejoin hard-wrapped lines.
Lines
Delete repeated lines from a list and keep the original order. Choose case sensitivity, whether to ignore surrounding spaces, and whether to keep the first or last copy.
Lines
Delete blank lines from text, or collapse runs of blank lines down to one so paragraphs stay separated.