CSV Splitter & Joiner - CSV to List and Back
Split a CSV row into separate lines, or join lines into a single CSV row.
Input
Output
Output Options
Frequently Asked Questions
What does Split mode do?
Split mode takes a single CSV row (values separated by a delimiter) and puts each value on its own line - the reverse of Join.
Input apple,banana,cherry
Output apple banana cherry
What does Join mode do?
Join mode takes a list of values (one per line) and combines them into a single delimited row - the reverse of Split.
Input apple banana cherry
Output apple,banana,cherry
How do I use a delimiter other than a comma?
Change the Delimiter dropdown. The tool supports tab, semicolon, pipe, colon, slash, equals, and more. Both Split and Join use the same delimiter setting.
Input (Delimiter: pipe) apple|banana|cherry
Output apple banana cherry
What does "Strip existing quotes" do in Split mode?
It removes surrounding quote characters from each extracted value. Useful when your CSV wraps items in double or single quotes.
Input "apple","banana","cherry"
Output (strip on) apple banana cherry
What does "Quote Item" do in Join mode?
Wraps each individual value in the chosen quote style before joining them. Useful when building SQL strings or values that need quoting.
Input (Quote Item: double) apple banana cherry
Output "apple","banana","cherry"
What does "Quote Line" do in Join mode?
Wraps the entire joined result in the chosen style. Use it to wrap the whole row in brackets, parentheses, or quotes - handy for SQL
IN (…) clauses.
Input (Quote Line: parentheses) apple banana cherry
Output (apple,banana,cherry)
What is the difference between "Each line separately" and "Entire input" in Split mode?
Each line separately treats every line in the textarea as its own CSV row and splits each one. Entire input treats the whole textarea as a single CSV value - use this when quoted fields in your CSV contain embedded newlines.
Is my data stored anywhere?
No. All processing is done entirely in your browser. Your data never leaves your device.
Related reading