How to use the Text Splitter & Joiner
- Choose split or join.
- Pick the separator — comma, semicolon, tab, pipe or your own.
- Optionally wrap each item in quotes, then copy the result.
What does this tool do?
Spreadsheets, emails and code often need lists in different shapes. Split “red, green, blue” into one item per line, or join a column of values into a single comma-separated line.
Items are trimmed and empty ones skipped by default, so stray spaces and double commas don't cause trouble.
Why use it?
- Both directions in one tool.
- Custom separators.
- Wrap items in quotes.
Use cases
- Turn a comma-separated list into a column for a spreadsheet.
- Build lists for SQL, code or email recipients.
- Clean up tags and keywords.
Ready for a SQL query
Join a column of IDs — 101, 102, 103 — with a comma, wrapping each in quotes: '101','102','103'. Paste it straight into WHERE id IN (…).
Common mistakes
- Splitting on commas when items themselves contain commas.
- Forgetting to choose quotes when the target needs them.
- Leaving duplicates in the list — remove them with Remove Duplicate Lines.
Privacy
The calculation happens instantly in your browser. The numbers you enter are not sent to our servers or saved. There's no account to create and nothing to install.
Frequently asked questions
Are spaces trimmed?
Yes, by default, and empty items are skipped.
Can I use my own separator?
Yes, type any separator, like “ / ” or “;”.
Can I split by new lines?
Yes — choose join to go from lines to one line, or split to go the other way.
Content last updated . See how M2Toolkit works.