Comma Separator

From a long column to a single line

You copied a column of names or product codes from a spreadsheet and now need it on one line, separated by commas: for the tags field of a blog post, the recipients of an email, or a database query. Typing a comma after every item by hand is tedious and easy to get wrong. Jood's comma separating tool joins the lines into one, with the separator you choose.

How to use it

1. Paste your list, one item per line.
2. Choose a separator.
3. Click "Start Now" and copy the result.

The separators on offer

• Comma ( , ): the most common choice for software, databases and tag fields.
• Arabic comma ( ، ): for an Arabic list that people will read.
• Semicolon ( ; ): Outlook uses it between recipient addresses, and spreadsheet programs set to many European languages expect it in CSV files.
• Vertical bar ( | ): handy when the items themselves contain commas.
• Space: to put words together on an ordinary line.

Extra spaces at the start and end of each item are trimmed and blank lines are skipped, so you never get two separators in a row.

Practical examples

• Entering thirty tags for an article or a video in one go.
• Pasting a list of addresses into the BCC field to send one message to everyone.
• Preparing a list of order numbers for an SQL query. One caution: the tool does not put quotes around values, so if they are text, add the quotes yourself.

Before joining, it is worth cleaning the list with remove duplicate lines and checking how many items it has with the line counter.

Where your list goes

The list is sent to Jood's server, joined there, and the result appears on the same page. It is not kept afterwards.