Free tool
List to comma separated text
Turn a list to comma separated text on one line. Choose the separator and whether each item gets quotes, which is handy for code and database queries.
The example is loaded. Paste your own list to replace it.
→ 1 line
Separator
Wrap each item in
Skip empty lines
Your text
Result
What it does
Turn the list into one line, like a, b, c.
Settings you can change
- Separator
- Wrap each item in: Nothing, Double quotes "a", Single quotes 'a'
- Skip empty lines
When to use it
You have 40 product IDs on separate lines and need them as 'a', 'b', 'c' for a database query.
Example: list to comma separated
Settings used: Wrap each item in: Single quotes 'a'.
Input
Result
Used in these recipes
Often used with
Break text at commas (or another separator) so each item gets its own line.
Put "quotes", (brackets) or similar around each line.
Merge the lines into one block of text.
Your text stays on this computer
Got your list from a web page?
HeyScraper turns the page you’re on into a spreadsheet, so you can skip the copying and pasting. Free: 500 pages a month.
Get HeyScraper