usefmtly

Comma to List Converter

Comma to List Converter — Free comma to list converter. Paste CSV, semicolon-separated, pipe-delimited, or tab-separated values and convert them to a clean list with one item per line. Trim whitespace, remove blanks, and deduplicate. No signup required.

Split by
Items
CommaSeparator
OnDupes
Delimited input
List

What does this tool do?

This tool takes a single line of delimited values — separated by commas, semicolons, pipes, or tabs — and converts it into a vertical list with one item per line. It is the reverse of the List to Comma Separated tool.

Use it to clean up CSV data, split configuration values, convert API responses, or prepare data for further processing.

Supported separators

SeparatorExample inputCommon in
Commaa, b, cCSV, most APIs, config values
Semicolona; b; cEuropean CSV, SQL query lists
Pipea|b|cLog files, Unix tools, PSQL
Taba\tb\tcTSV exports, spreadsheet paste
Newlinea\nb\ncAlready a list — use to clean/dedup

Options explained

  • Trim — Removes leading and trailing whitespace from each item. Recommended: keeps apple, banana from producing banana with a leading space.
  • Remove empty — Drops blank items that result from trailing delimiters or double separators (e.g. a,,b → two items, not three).
  • Remove dupes — Keeps only the first occurrence of each value, removing duplicates from the output list.

Frequently Asked Questions

What separators does this tool support?

Comma (CSV), semicolon, pipe (|), tab (TSV), and newline. Select the separator that matches your input from the toolbar.

How do I convert CSV to a list?

Paste your comma-separated values into the input field with "Comma" selected as the separator. Each value becomes its own line in the output. Use "Trim" to remove extra spaces around each item.

What is the difference between this and List to Comma Separated?

This tool goes the other direction — it splits a single delimited string into a vertical list. The List to Comma Separated tool does the opposite: it takes a list (one item per line) and joins it with a delimiter.

Can I remove duplicates while converting?

Yes — toggle "Remove dupes" to deduplicate the output. Items are compared exactly (case-sensitive). Combined with "Trim", this handles most practical deduplication needs.

Related Tools