ExtraTools/join

COMBINING LISTS BY ROW

LINE-WAY COMBINATION OF TEXT

Join lists line by line

Combine two or more lists by matching rows. Set a separator and add prefixes, suffixes, or placeholders for missing values.

Review the combined output and copy it or save it as a text file.

Hides prefix, suffix, placeholders, and advanced string rules.
01 / ORIGINAL LISTS

Insert lists for concatenation

Line 1 from each field will be connected to row 1 of the remaining fields, line 2 to row 2, and so on further.

LIST 1

0 lines 0 characters

LIST 2

0 lines 0 characters

2 из 10 списков
How to collect strings

In prefix, separator, suffix and placeholder use \n or \x for transfer, \r for a carriage return, \t for tab stops, {n} for line number and {total} for the total number of rows. To display the template literally, write {{n}}.

Handles nulls and hyphens

Processing is done entirely in this browser.

Text statistics

Preliminary result
Characters0Unicode graphemes, including spaces
Without spaces0all whitespace is excluded
Words0Cyrillic and Latin
Lines0empty text — 0 lines

Characters are counted as Unicode graphemes. The “Without spaces” count excludes whitespace, including tabs and line breaks.

Possibilities of line-by-line merging

Specify a common separator (such as a comma, tab, or dash), and optionally add a prefix and suffix to each entry. If the lengths of the lists vary, provide placeholder text or leave missing values blank.

  • Up to ten lists with reordering and a separate line counter;
  • Skip blank values and completely blank records;
  • select LF, CRLF or CR carries, copy and download TXT;
  • result statistics: characters, words and lines.

Before importing the result, check the delimiters and rules for handling empty cells.

How to concatenate lists

Insert data into two or more fields: rows with the same number are combined into one record. Add up to ten lists and change their order using arrows.

Easy mode hides additional formatting fields without deleting their values.

Check your input