Join / Split Lines
Join lines into one text with any separator, or split text into lines at a separator.
You can use \n for a new line and \t for a tab in the separator.
From column to list and back
When you copy a spreadsheet column, every value is on its own line. Turning that into a comma-separated line for an email recipient list, tag list or code array, or splitting comma-separated text back into lines, takes seconds with this tool.
Options
- Join or split with any separator (comma, semicolon, pipe, space)
- Use \n for a new line and \t for a tab
- Trim items and drop empty ones
- Wrap every item in quotes
Processing happens in your browser and you can copy the result in one click.
How to use Join / Split Lines
- Paste your text or list.
- Choose join or split.
- Set the separator and other options.
- Copy the result.
Why use this tool?
Automates the most common conversion when moving data between spreadsheets, code and text.
FAQ
Can I use a new line or tab as the separator?
Yes. Type \n for a new line or \t for a tab in the separator field.
How do I paste back into Excel?
Use split mode; each item goes onto its own line and lands in separate cells when pasted into Excel.
Can items be wrapped in quotes?
Yes, the quote option wraps each item in " or '.
Related tools
Add Prefix / Suffix to Lines
Add the same text to the start or end of every line: quotes, commas, bullets or HTML tags.
Open toolAdd / Remove Line Numbers
Number every line with your own start, step and separator, or remove existing line numbers.
Open toolRemove Duplicate Lines
Remove repeated lines from a list in one click while keeping the original order.
Open toolCSV to JSON Converter
Convert CSV data into a JSON array of objects, using the header row as keys.
Open tool