How do I convert a list to comma separated values?

Paste your list into the input box. Delimit splits on line breaks, spaces, tabs, commas, semicolons and pipes automatically, then joins everything with the delimiter you pick. Copy the result with one tap.

How do I split a comma separated list into separate lines?

Switch to Split mode and each value appears on its own line, ready to paste into a spreadsheet column.

Can I build a SQL IN clause from a list?

Yes. Choose the SQL IN preset. Each value is wrapped in single quotes, joined with commas and enclosed in parentheses.

Is the text I paste sent anywhere?

No. The conversion runs entirely in your browser using JavaScript. The text you paste is never uploaded, never stored on a server and never logged.

Convert a list to comma separated values

Paste a column of anything — IDs, emails, SKUs, ticket numbers. Get back one clean line, or split a delimited line back into rows. The conversion runs in your browser.

JavaScript is switched off. The converter needs it, because the conversion runs on your device rather than on a server — that is also why nothing you paste is ever uploaded. Turn JavaScript on for this page to use the tool. Everything written below stays readable either way.

Paste here

0In list

0Pasted

0Repeats

0Characters

Output style

More options

Split the input on

Use line breaks only to keep values that contain spaces, like names or addresses.

Separator

Wrap each value

Wrap the whole line

Change the text

Order

Clean up

Add to every value

Find and replace

Saved setups

Setups are stored in this browser only. Use Share setup to send one to a colleague — the link carries your options, never your text.

Result —

What you can do with it

Database and ticket queries

Turn a column of IDs into an IN clause for SQL, or a filter list for ServiceNow, Jira and Salesforce.

Spreadsheet columns

Flatten a column into one cell, or split a packed cell back into rows.

Email and contact lists

Convert a list of addresses into the semicolon or comma format your mail client expects.

Code and config

Build JSON arrays, quoted string lists and environment values without hand-editing each line.

How to convert a list to comma separated values

Paste your list into the box. Any layout works — line breaks, spaces, tabs, or an existing delimiter. You can also drag a .txt or .csv file straight onto the box.
Pick an output style. Comma is the default; SQL IN and JSON array set everything for you.
Check the counters. If the number pasted doesn't match what you expected, something was lost upstream.
Tap copy, or press Ctrl + Enter.

Questions

How do I split a comma separated list into lines?

Switch to One line → list at the top, or pick the One per line output style. Each value lands on its own row, ready for a spreadsheet column.

Can I build a SQL IN clause?

Yes — the SQL IN preset wraps each value in single quotes, joins with commas and puts parentheses around the lot, so it pastes straight after IN.

Why does it warn me about long lines?

Browser address bars truncate URLs at roughly 2,000 characters, usually without saying so. If you're pasting a long list into a URL-based filter, you can lose the tail end and never notice. Past 1,900 characters the tool tells you to use a filter box instead, or split the list.

Is the text I paste private?

The conversion happens in your browser. What you paste is never uploaded, never stored on a server and never logged. The page itself is served from a CDN and loads a webfont, which is ordinary web traffic — the privacy policy spells out exactly what that involves.

Does it remove duplicates?

Yes, and it's on by default. The Repeats counter shows how many it dropped, so you always know whether the list actually contained duplicates. Matching ignores case, so AB12 and ab12 count as the same value.

Can I save a setup I use every day?

Yes. Open More options, name the setup and save it — it stays in this browser. To hand a configuration to someone else, use Share setup, which puts the options in the link and leaves your text out of it.