Comma to Lines Converter
Convert between comma-separated values and one-item-per-line format. Handles quoted fields, trims whitespace, and removes duplicates. Paste CSV data, get a clean list — and back.
Result
Result
How to use the comma to lines converter
Paste a comma-separated string on the left to get one item per line; paste a list on the right to join with your separator. Toggles let you trim whitespace, drop empties, or dedupe.
Formula & explanation
Splits and joins are exact — the only transformations are the toggles you enable.
Examples
"apple, banana, cherry" → three lines. With dedupe on, repeated values collapse.
Frequently asked questions
- How do I convert a comma-separated list to one item per line?
- Paste your CSV into the left box and the tool splits it by commas automatically, putting each item on its own line.
- Can I use a separator other than a comma?
- Yes — change the Separator field to any character such as a semicolon, pipe, or tab, and both panels update instantly.
- How do I remove duplicate entries while converting?
- Enable the Dedupe toggle; it keeps the first occurrence of each value and drops subsequent repeats.
- What does the Trim toggle do?
- It strips leading and trailing whitespace from each item, so ' apple ' becomes 'apple'. This prevents invisible mismatches when deduping.
Related list tools tools
- List StatsGet statistics on any list: total count, unique count, min and max line length, average length, and the longest and shortest items. Useful for auditing data before further processing.
- List Set OperationsPerform set operations on two lists: union, intersection, difference, A-only, B-only, and symmetric difference. Paste two lists and choose the operation — results update instantly.
- List FilterKeep or remove lines matching a plain-text substring or regular expression. Useful for filtering log output, cleaning data, or extracting matching lines from large lists.
- List to JSON ArrayConvert a one-item-per-line list into a JSON array of strings and back again. Handles quoting and escaping automatically — useful for turning clipboard lists into API payloads.
- Prefix / Suffix WrapperWrap every line with a custom prefix and suffix. Useful for building SQL IN clauses ('value'), quoting shell arguments, wrapping HTML tags, or generating code from a list.
- Column PickerExtract a specific column from tab-separated or comma-separated rows. Enter column index or name — useful for pulling a single field from TSV exports or pasted spreadsheet data.