Merge lines from multiple lists

Merging joins the lists like a zipper: line 1 of list A with line 1 of list B, line 2 with line 2, and so on.

List A	List B	Merged (separator -)
Anna Smith	anna@example.com	Anna Smith - anna@example.com
Bob Jones	bob@example.com	Bob Jones - bob@example.com
Carol Lee	carol@example.com	Carol Lee - carol@example.com

You can add up to six lists. The separator goes between the parts; quick buttons offer space, comma, semicolon, tab, dash, equals or nothing, or type any separator you like.

Line start and Line end add fixed text to every merged row, for example ( and ), to build SQL value rows, or <option value=" … "> for HTML.

If the lists don't have the same number of lines, the tool shows the lengths and handles the difference the way you choose:

• Leave missing parts empty (keep separator). Rows keep the same structure: David Brown - . Best for CSV or tab-separated output where columns must line up.
• Skip missing parts and their separator. David Brown without a dangling separator.
• Stop at the shortest list. Extra lines in longer lists are dropped.
• Repeat shorter lists from the top. Handy when one list is a short pattern, like assigning three team colors across a long roster.

Trim spaces removes stray spaces around each item, and Skip empty lines drops blank lines before merging so the rows don't shift out of sync.

Lists: A = 1, 2, 3; B = 'Anna', 'Bob', 'Carol'.

Settings: separator , , line start (, line end ),.

Result:

(1, 'Anna'),
(2, 'Bob'),
(3, 'Carol'),

Paste the rows after INSERT INTO people (id, name) VALUES and change the final comma to a semicolon. To add the quotes around the names in list B automatically, run it through add prefix and suffix first.

• Contact lists: names and email addresses that came from two different columns or files.
• Spreadsheet columns: merge with a tab separator, and paste back into Excel to get the columns side by side.
• Key-value pairs: keys and values with = or : in between, for config files or translations.
• SQL and code: build ('value1', 'value2'), rows using quotes in the separator and line start/end.
• Product feeds: SKU, title and price from three separate lists.

To split merged data back apart, use extract columns. To produce every combination of items rather than pairing them line by line, use the keyword combiner.

• Check the line counts shown on each box before you copy the result; a single extra blank line in one list shifts every row after it. Skip empty lines prevents that.
• Sort both lists the same way first if the order was different, or the wrong items end up paired.
• The tab separator shows as ⇥ in the separator box so you can see it.

Everything runs in your browser; the lists are not uploaded.