convert

Join Lines

Combine a list of lines into one line separated by commas or any delimiter, optionally quoting each item.

Runs on your deviceBatch readyPaste textNew

Paste or drop

Paste text below, or drop a file instead.

0 chars · 0 lines
…or drop a file
Drag and drop, or choose files
TXTMDCSVTSVLOGJSONXML+10

Choose an output

Combine a list of lines into one line separated by commas or any delimiter, optionally quoting each item.

Fine-tune

Optional — sensible defaults are already set.

Wrap items in

About Join Lines

Combine a list with one item per line into a single line, with a delimiter of your choice between items. You can also wrap each item in double quotes, single quotes or backticks, which turns a column copied from a spreadsheet into a ready-to-use list for code, SQL or a tag field.

When it helps

  • Turning a column of IDs into a quoted list for a SQL IN (...) clause.
  • Building a JavaScript or Python array from a list of strings.
  • Combining email addresses with '; ' to paste into an email client's To field.
  • Turning a list of keywords or tags into one comma-separated line.

Tips

  • The delimiter accepts \n and \t, so you can join with a tab for spreadsheets or with blank lines between items.
  • Quote characters inside an item are not escaped. If your values can contain the quote you chose, pick a different one or escape them first.
  • Trimming and skipping empty lines are on by default, which removes the stray spaces and blank rows that often come with copied columns.

Good to know

Quick answers about join lines in your browser.

Copy the column from Excel or Google Sheets, paste it here, keep the delimiter as ', ' and convert. Pick a quote style if the values are text that will go into code.

The split text tool. It takes a delimited line and puts each item on its own line.

Yes. There is no sign-up, no watermark and no limit on how many files you process.

No. Files are read and processed locally in your browser, so they never leave your device.

Related tools

DEVURL DecodeDecode percent-encoded text back to readable text.TXTNewWord CounterCount words, characters, sentences and paragraphs, and estimate reading and speaking time, with a top-words list.TXTNewWord Frequency CounterList every word in your text with how often it appears, ranked and exported as a CSV spreadsheet.TXTNewCase ConverterConvert text to UPPERCASE, lowercase, Title Case, Sentence case, camelCase, snake_case, kebab-case and more.TXTNewFind and ReplaceFind and replace words or patterns in text, with optional regular expressions, case matching and whole-word search.TXTNewText Compare (Diff)Compare two texts line by line and get a unified diff showing exactly what was added, removed or changed.TXTNewReverse TextReverse text backwards character by character, flip the order of lines or words, or mirror each line.TXTNewFancy Text GeneratorTurn plain text into bold, italic, script, gothic, bubble, small caps or upside-down Unicode text you can paste anywhere.TXTNewRemove AccentsStrip accents and diacritics from text (é → e, ñ → n, ü → u) and optionally expand ligatures like ß and æ.

Part of the Text Tools collection.