ReplaceKit

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

What each option does

OptionWhat changes
Put this between itemsThe 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 separatorGives a, b, c instead of a,b,c.
Put around each itemWraps every item in quotes, so apple becomes "apple". Use this for SQL IN (...) lists and for text values in code.
Remove repeated itemsKeeps the first copy of each item. The check is exact: Apple and apple count as different.
ReverseSplits 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.

You're on the list. We'll email you when ReplaceKit is ready.

Free version: every find and replace, no click limit or trial clock.

More free ReplaceKit tools and guides