Paste a spreadsheet column and get it as one line of comma separated values
Processed in your browser. Nothing is uploaded. Updated on 24 Oct 2026.Copying a column out of Excel or Google Sheets gives you one value per line, which is exactly what most forms and filters will not take. Paste it here and it comes back as a single line separated by commas, with the trailing blank row that a spreadsheet copy always brings along removed and counted rather than quietly left in the middle of your data.
Copy the column in Excel and paste it into Your list.
The Separator is already Comma and space; change it if you need a plain comma.
Keep Trim spaces around each item and Remove blank lines on to drop empty cells.
Press Copy to take the joined line.
Joining a list of lines into one separated line is a two-minute job in a text editor and a five-second job here, and the difference is not the time. It is the three faults the manual version leaves behind: a separator hanging off the end, the blank row a spreadsheet copy always brings with it, and the entry that appears twice because the list was pasted from two places.
Choose the separator: comma, comma and a space, semicolon, pipe, space, tab, or anything you type yourself. Choose whether each item is quoted, with single, double or backtick quotes, and whether the whole line is wrapped in round, square or curly brackets. Those two together turn a column of order numbers into ('ORD-1041','ORD-1042','ORD-1043'), which is one paste into a SQL IN clause, or into a JavaScript array, or into a shell argument list.
The same page runs backwards. Switch the direction and a comma separated line becomes one item per line, which is what you want when somebody sends you a long line and you need it as a column again. Splitting also breaks at line ends, because a list pasted out of an email is usually a mixture of both.
The rest of the article, and all 7 questions about List to Comma Separated, are on the List to Comma Separated page.
Paste the list into the box on the left and the joined line appears on the right immediately. Choose comma, comma and space, semicolon, pipe, space or tab as the separator. No separator is left on the end, and the blank line a copy usually brings with it is dropped and counted.
Set quotes to single and the wrapper to round brackets. Each item is then quoted on its own and the whole line wrapped, giving ('A1','A2','A3') as one copy. Turn on remove duplicates as well, because a repeated value in an IN clause is harmless but usually means the source list was pasted twice.
Yes. Switch the direction and each value goes on its own line, which is what a spreadsheet column or a checklist needs. Splitting breaks at the chosen separator and at line ends together, so a list pasted out of an email, part on one line and part on the next, still comes out correctly.
List yahan paste kijiye. Comma separated line turant ban jaati hai, aur aap chunte hain ki comma chahiye, semicolon, pipe ya space. Excel formula kaise likhein yeh sochne ki zarurat nahi, khaali lines apne aap hat jaati hain aur ginti neeche dikh jaati hai.
Still stuck? Ask about List to Comma Separated and anybody who knows can answer. No account needed.
On the related tools: URL Extractor – Find every link in pasted text or HTML and get them as a clean, deduplicated list · Unicode to Kruti Dev Converter – Turn Unicode Hindi into Kruti Dev 010 keys for Word, PageMaker and typing practice · Dummy Text Generator – Fill a layout with neutral dummy text of the length you need.
In the collection Text Tools.