Wrap every item in quotes and brackets, ready for a SQL IN clause or an array
Processed in your browser. Nothing is uploaded. Updated on 24 Oct 2026.Writing `WHERE id IN (...)` by hand around forty order numbers is where typos come from. Paste the list and every item is quoted individually and the whole thing wrapped in brackets, so the result is one copy straight into your query. Switch to double quotes and square brackets for a JavaScript or JSON array, or backticks for a shell command.
Paste the IDs or names into Your list, one per line.
The page starts with Single 'quotes', Comma and Round brackets ( ), ready for a SQL IN clause.
Switch to Double "quotes" or Square brackets [ ] for JSON or code.
Press Copy and paste the line into your query.
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.
Blank lines are dropped by default, and duplicates are dropped if you asked for that. Both are counted in the sentence under the result, which says how many items went in and how many came out. Switch off remove blank lines to keep every row exactly as pasted, including the empty ones.
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.
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.