Merge lines into a list or paragraph
Copied a column from a spreadsheet and need it as a, b, c? Got a comma list that should be one item per line? Paste it, pick the format, copy the result.
- Instant
- No signup
- Nothing uploaded
How to turn lines into a comma-separated list
- Paste your items, one per line, into the left box.
- Pick a format: comma separated, one paragraph, bulleted list or numbered list. Choose Split into lines to go the other way.
- Turn on Wrap in quotes for SQL, JSON or code.
- Click Copy result.
What each format gives you
| Format | Result for apples / pears / plums |
|---|---|
| Comma separated | apples, pears, plums |
| Comma separated, in quotes | "apples", "pears", "plums" |
| One paragraph | apples pears plums |
| Bulleted list | • apples • pears • plums, one per line |
| Numbered list | 1. apples 2. pears 3. plums, one per line |
| Split into lines | Commas, semicolons and line breaks all become one item per line |
Spaces around each item are trimmed and empty lines are skipped, so a column pasted from Excel, Numbers or Google Sheets comes out clean.
When it comes in handy
- Turning a spreadsheet column of emails into a list for the To: field.
- Building an SQL
IN (…)list or a JavaScript array from IDs. - Joining lines a PDF broke mid-sentence back into one paragraph.
- Turning notes into a bulleted or numbered list for a message.
Questions
How do I convert a column to a comma-separated list?
Copy the column from your spreadsheet, paste it above and choose Comma separated. Each cell becomes one item, joined with commas.
How do I split a comma-separated list into lines?
Paste the list and choose Split into lines. Items separated by commas, semicolons or line breaks each go on their own line.
How do I remove line breaks from text?
Choose One paragraph. Every line is joined with a single space. To keep paragraph breaks, use Join broken lines in the remove formatting tool instead.
Can I merge clips on a Mac without a website?
Yes, with Maclip. Select several clips in your history and merge them into one list or paragraph, with new lines, bullets, numbers, commas or spaces, or paste them one after another as a paste stack.
Keep reading
- GuideHow to paste several things at once on a MacThe Mac clipboard holds one thing. Here is how to queue several clips and paste them in order, fill a form field by field with Tab, or merge clips into one list.
- GuideHow to organize your clipboard history on a Mac automaticallySort what you copy on a Mac without doing it by hand: boards for clips you keep, and smart boards that collect links, screenshots, contact details or code by rules.
- GuideEvery copy and paste shortcut on the MacEvery copy, cut and paste shortcut on the Mac, including pasting without formatting, moving files in Finder and copying a screenshot straight to the clipboard.
- GuideHow to see your clipboard history on a MacWhere your Mac keeps what you copy, how to open the clipboard history built into macOS Tahoe's Spotlight, and what to use when you need more than the last few items.