Free tool

Column to Comma Separated List

Convert a column of text into a comma-separated list. Paste from Excel or Google Sheets, tweak the delimiter, then copy the result.

Free column to comma converter. Paste Excel or Sheets rows and get a delimited list with optional quotes and wrappers. Runs in your browser.

Column text

Copy list

Example

Comma · pipe · quotes · wrappers

a, b, c

Delimited list

Format CSV

How it works

1
Paste your column

Copy a column from Excel or Sheets and paste one item per line into the left box.
2
Copy list

Choose comma, pipe, or a custom delimiter. Optionally wrap each item or the whole result, then copy.
3
Paste it where you need

Drop the converted list into SQL, code, ads audiences, invite forms, or config files.

Use this tool to convert a column into a list

Founders constantly need “a, b, c” from a spreadsheet column — for SQL IN clauses, ad audiences, invite lists, or config files. This Mini App does that instantly.

Default comma+space delimiter, plus pipe, semicolon, newline, or custom.

Item prefix/suffix for quotes: "apple","banana".

Result prefix/suffix for arrays: ["apple","banana"].

Collapse blank lines so empty Excel rows do not create extra commas.

Why not paste into ChatGPT?

A dedicated converter is faster, private, and repeatable. Your list never leaves the browser, and settings stay put while you tweak.

What this does not do

Everything runs in your browser. Nothing is uploaded or stored on our servers.
Very large pastes may feel slow in older browsers. Split huge columns if needed.
This formats text. It does not validate emails, IDs, or CSV escaping beyond the wrappers you set.

Frequently asked questions

Is this column to comma converter free?

Yes. No signup. Paste, convert, copy. It runs entirely in your browser.

Can I use a delimiter other than a comma?

Yes. Pick pipe, semicolon, space, new line, or type any custom delimiter in Settings.

How do I wrap each item in quotes?

Open Settings, set Item prefix and Item suffix to a quote character. Add [ and ] as result prefix/suffix if you want a JSON-style array.

What does collapse blank lines do?

When on, empty rows are removed so you do not get double commas. Turn it off if you need to keep empty items.

Is my data uploaded?

No. Conversion happens locally in your browser. We do not send the paste to a server.

Does this work with Excel and Google Sheets?

Yes. Copy a single column, paste into the left box, then copy the converted list from the right.