Comma separated list converter
Paste a column of lines. Get one comma separated list back. Free, no sign-up. Your text never leaves this page: the tool runs in your browser and sends nothing anywhere.
How to join
You're on the list. We'll email you once.
What each option does
| Option | What changes |
|---|---|
| Put this between items | The mark placed between two items. A comma is the usual choice for lists in code, SQL and forms. Pick a semicolon, a pipe, a space or a tab if your target wants that. |
| Add a space after each separator | Gives a, b, c instead of a,b,c. |
| Put around each item | Wraps every item in quotes, so apple becomes "apple". Use this for SQL IN (...) lists and for text values in code. |
| Remove repeated items | Keeps the first copy of each item. The check is exact: Apple and apple count as different. |
| Reverse | Splits a list on the separator and gives one item per line. Spaces around items are trimmed, and matching quotes are taken off. |
Blank lines are always skipped, and spaces at the edges of each line are trimmed.
Convert a column to a comma separated list without a tool
In Google Sheets or Excel, use =TEXTJOIN(", ",TRUE,A1:A10). It joins the cells in A1 to A10 with a comma and a space and skips blank cells. In Notepad++ or VS Code, turn on regular expressions, find \r?\n and replace it with , . This page is for when you just want to paste, click and copy.
Is my text private?
Yes. The tool is one readable script, tool.js (no libraries), which works only on what is in the box. It makes no network requests and stores nothing; you can disconnect from the internet after the page loads and it keeps working. Separately, the page sends one cookie-free page view count when it loads (the page address and the referring site, never your text; see privacy).
In Google Docs: ReplaceKit finds and replaces inside the document
Copying text out of a document and back loses its headings, bold and links. ReplaceKit, the Google Docs add-on we are building, finds and replaces in place, only in your selection if you want, with formatting kept and a preview of each match. Related tools: the add text to each line tool, the remove line breaks tool and the remove duplicate lines tool.
ReplaceKit is built and in testing. It is not in the Google Workspace Marketplace yet. Leave your email and we send one message when you can install it.
Free version: every find and replace, no click limit or trial clock.
More free ReplaceKit tools and guides
- Add text to the start or end of each line
- Remove special characters from text
- Remove duplicate lines from a list
- Case converter (UPPER, lower, Title Case, Sentence case)
- Remove formatting from text
- Remove extra spaces from text
- Remove line breaks online (and fix pasted PDF text)
- Bulk find and replace (a whole list of pairs at once)
- Regex find and replace in Google Docs
- Find and replace in Google Docs on Android and iPhone