How to use the join / merge text

1Paste the lists into List A and List B, one item per line. Press Add list for more.
2Under Merge, choose Line by line, Interleave or Join all into one line.
3Choose a Separator and what to do with Lists of different lengths.
4Press Copy or Download.

Example

Input

List A: Ana, Ben, Cara (one per line)
List B: Silva, Okafor, Lee

Output

Ana Silva
Ben Okafor
Cara Lee

Line by line with a Space separator. With Interleave the result is Ana, Silva, Ben, Okafor, Cara, Lee on separate lines.

Line-by-line merge

Line by line joins the first line of each list, then the second lines, and so on, with the separator between them. It's the text equivalent of putting two spreadsheet columns side by side. Up to five lists can be merged at once, so first names, last names and email addresses become one line per person.

Interleaving lists

Interleave alternates lines: A1, B1, A2, B2… Each item stays on its own line. Use it to mix questions with answers, prompts with responses, or two playlists into one alternating list.

Joining all lines into one

Join all into one line puts every line of every list on a single line with the separator between them: apple, banana, cherry with Comma and space become apple, banana, cherry. That's useful for tag fields, SQL IN lists and anywhere a comma-separated list is needed. To join the lines of a paragraph instead, use remove line breaks, which can keep paragraph breaks.

Separators and CSV output

Choose Comma and space, Tab, Hyphen, Underscore, Nothing, or Custom…. For CSV, use a custom separator of a single comma; for pasting into a spreadsheet, choose Tab so each list lands in its own column. If your values contain commas, wrap them in quotes first with add prefix and suffix. To pull columns back out of delimited text, use the column extractor.

Lists of different lengths

When lists aren't the same length, the footer says so and Lists of different lengths decides what happens:

Keep going, leave gaps empty: missing items become empty, so the separators stay aligned for CSV.
Keep going, skip missing items: missing items and their separators are left out.
Stop at the shortest list: extra lines in longer lists are ignored.

Empty lines in your lists are ignored, so check that the items line up before merging.

Is my text private?

This tool runs entirely in your browser. Your text is not uploaded to our servers.

Questions about the join / merge text

How do I combine first and last names from two lists?

Paste first names into List A and last names into List B, choose Line by line and a Space separator. Each line becomes “First Last”.

What if the lists are different lengths?

Choose under Lists of different lengths whether to leave gaps empty, skip missing items, or stop at the shortest list.

Can I merge .txt files?

Open each file, copy its contents into a list box, and merge. To combine whole files one after another, paste them into one box and use Join all into one line with a New line-style custom separator (\n).

Join / Merge Text