# Text Joiner Join multiple text inputs with custom separators > Canonical page: https://elysiatools.com/en/tools/text-joiner - **Category:** Text Processing - **Keywords:** text, join, combine, concatenate, merge, text joiner ## Overview The Text Joiner is a streamlined utility designed to merge multiple lines of text into a single string using custom separators, helping you format data quickly and efficiently. ## Inputs - **Text Inputs** (textarea): Enter text inputs (one per line)... - **Separator** (text): Separator between texts - **Trim Whitespace** (checkbox) - **Remove Empty Lines** (checkbox) - **Add Line Numbers** (checkbox) ## When to use - Converting a vertical list of items into a comma-separated string for database queries. - Formatting raw data lines into a clean, readable format for reports or documentation. - Cleaning up messy input by removing empty lines and trimming unnecessary whitespace. ## How it works - Paste your text entries into the input area, ensuring each item is on a new line. - Define your preferred separator, such as a comma, semicolon, or custom character. - Toggle options like 'Trim Whitespace' or 'Remove Empty Lines' to refine your output. - Click process to generate your combined text string instantly. ## Use cases - Generating SQL 'IN' clauses from a list of IDs. - Creating comma-separated values (CSV) strings from raw text lists. - Formatting email addresses or usernames for bulk mailing lists. ## Frequently asked questions ### Can I use a newline as a separator? Yes, you can specify a newline character or simply leave the separator field empty if you want to join items directly. ### Does this tool handle large amounts of text? Yes, the tool is optimized to process large blocks of text efficiently within your browser. ### What happens if I have empty lines in my input? If the 'Remove Empty Lines' option is enabled, the tool will automatically ignore any blank lines during the joining process. ### Can I add line numbers to my joined text? Yes, enable the 'Add Line Numbers' option to prefix each item with its corresponding index number. ### Is my data sent to a server? No, all text processing is performed locally in your browser, ensuring your data remains private. ## Related tools - [Advanced Duplicate Line Remover](https://elysiatools.com/en/tools/advanced-duplicate-line-remover): Detect and remove duplicate lines with advanced options for mode, case sensitivity, and trimming - [Multiline Merger](https://elysiatools.com/en/tools/multiline-merger): Merge multiple lines into a single line with customizable separators and formatting options - [Remove Duplicate Lines](https://elysiatools.com/en/tools/remove-duplicate-lines): Deduplicate lines in a list or text block. Keep the first or last occurrence, with options for case sensitivity, whitespace trimming, and dropping empty lines. - [Sort Text Lines Enhanced](https://elysiatools.com/en/tools/text-enhanced-sorter): Sort lines alphabetically, numerically, or by their length with advanced options - [Text Line Merger](https://elysiatools.com/en/tools/text-line-merger): Merge multiple lines of text into a single line with customizable separators - [Whitespace Normalizer](https://elysiatools.com/en/tools/whitespace-normalizer): Replace consecutive spaces/tabs with single space and trim line start/end whitespace - [Text NLP Annotation Workbench](https://elysiatools.com/en/tools/text-nlp-annotation-workbench): Run explainable local tokenization, sentence splitting, stopword, lemma, stem, entity and n-gram annotation with JSONL or CoNLL export. - [Phone Number Extractor](https://elysiatools.com/en/tools/phone-number-extractor): Extract phone numbers from mixed text with support for multiple countries and formats ## Samples - [Text with Emoji Samples](https://elysiatools.com/en/samples/text-with-emoji-samples): Mixed language text containing various Unicode emojis for testing emoji extraction - [Duplicate Line Samples](https://elysiatools.com/en/samples/text-duplicate-line-samples): Sample files with various types of duplicate lines for testing duplicate removal tools - [Special Characters Samples](https://elysiatools.com/en/samples/text-special-characters-samples): Sample text files with various special characters, punctuation, and symbols for testing non-alphanumeric character removal - [Android File Operations Java Samples](https://elysiatools.com/en/samples/android-file-operations-java): Android Java file operations examples including text file read/write, file copy/move, directory traversal, and file validation