How it works
Paste a list to add commas: each newline is replaced with a comma and a space, and the items land on one line. The sample becomes spare key, torch, biscuits, a second torch, with no comma after the last.
Read the full guide
Convert text to comma separated values
Paste a column from a spreadsheet, or any text with one value a line. Spaces and tabs at the two ends of a line go with its line break, and the order stays as pasted.
Blank lines and commas already there
A blank line makes no empty item: tea, two blank lines and coffee come back as tea, coffee. A line that already ends in a comma gets no second one. A comma inside an item stays, so Lisbon, Portugal reads as two values afterwards.
Questions and answers
How do I get comma separated values online from plain text?
Put each value on a line of its own, paste the lines here and copy the result. Text that is already one line has no line breaks to replace, so it comes back unchanged.
Is the result a CSV file?
It is one row of a CSV file, with two cautions from RFC 4180, the format’s description. A space counts as part of a field, so join with a comma alone. A field holding a comma belongs in double quotes, and this page adds none.
How do I add a comma without a space, or a semicolon?
Type the separator into the Your own box: a comma alone, a semicolon, a pipe, anything up to 10 characters. The sample then starts spare key,torch or spare key;torch.
Can it add a comma to the end of each line and keep the lines?
Not here: this page always joins the lines. Add text to each line keeps every line and puts a comma after each one but the last, with quotation marks round the items if you want them.