Convert an Excel Column to a Comma-Separated List
Copy a column out of Excel or Google Sheets, paste it here, and get a clean comma-separated list.
Examples
| Input | Output | |
|---|---|---|
| Simple | 1001 ⏎ 1002 ⏎ 1003 |
1001, 1002, 1003 |
| Realistic | 10241 ⏎ 10242 ⏎ 10243 |
10241, 10242, 10243 |
Why convert this way
Excel has no one-click way to do this. TEXTJOIN works but needs a formula, a helper cell, and a second pass if you also want quotes. Copying the column and pasting it here is faster for a one-off, and it deduplicates and sorts in the same step.
When you will need it
- Building a filter list from a column of IDs
- Turning a column of emails into a To: line
- Feeding a comma-separated parameter in a report tool
- Preparing values for a SQL IN clause
What the settings do here
- Split on newline — the tool reads
1001⏎1002⏎1003as 3 separate items. - Join with ,
— producing
1001, 1002, 1003.
Where this comes up
The most common request on this site. Someone has a column and needs it as one line, and the spreadsheet route involves a formula, a helper cell and a second pass to strip the trailing separator.
Related conversions
Going the other way, or joining with something else entirely? The delimiter converter accepts any split and join pair including custom separators, and the index has the 16 ready-made ones.
Frequently Asked Questions
How do I convert an Excel column to a comma-separated list?
Copy the column, paste it in and join with a comma. A copied column arrives newline-separated, so split on newline. No TEXTJOIN formula or helper cell needed.
Why does splitting on comma not work for an Excel column?
A copied column is separated by line breaks, not commas. Splitting on comma treats the whole column as one item. Copying a row instead gives tab-separated text.