How to use
- Set Direction to Column → List to join lines, or List → Column to split a list.
- Click Paste to insert your copied column or list into the left box.
- Choose Separator for Column → List, or Input separator for List → Column.
- Click Copy to copy the text from Result.
Examples
Join email addresses from a spreadsheet
alex@example.com jordan@example.org sam@example.net
alex@example.com, jordan@example.org, sam@example.net
Build an SQL IN list of last names
O'Brien Johnson Garcia
('O''Brien', 'Johnson', 'Garcia')Split a CSV row with commas inside values
"New York, NY","Austin, TX","Portland, OR"
New York, NY Austin, TX Portland, OR
FAQ
Can I use a custom delimiter instead of a comma?
Choose Custom… in Separator and enter your text in Custom separator. To split a list, choose Custom… in Input separator and fill in Custom input separator. These fields use literal text, not regular expressions.
How do I remove duplicates from my list?
Turn on Remove duplicates to keep only the first occurrence of each value. Matching is case-sensitive; with Trim items on, spaces and tabs around values are removed before comparison.
Does this add thousands separators to numbers?
This tool joins or splits list items; it does not format 1234567 as 1,234,567.
Can I paste several columns from Excel or Google Sheets?
In Column → List, each line is one item, so tabs between spreadsheet columns stay inside that item. Copy a single column if you want each cell to become a separate list value.
Is my list uploaded or saved?
Your list is processed in your browser without network requests containing the text, and the input text is not saved. Option settings, including custom separators, prefixes, suffixes and wrapping text, are stored in localStorage. The production page also sends Google Analytics usage events without list content.